Skip to main content

connector_dryruns

Creates, updates, deletes, gets or lists a connector_dryruns resource.

Overview

Nameconnector_dryruns
TypeResource
Idazure.service_connector.connector_dryruns

Fields

The following fields are returned by SELECT queries:

OK. The request has succeeded.

NameDatatypeDescription
propertiesobjectThe properties of the dryrun job.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, location, dryrunNameget a dryrun job
listselectsubscriptionId, resourceGroupName, locationlist dryrun jobs
createinsertsubscriptionId, resourceGroupName, location, dryrunNamecreate a dryrun job to do necessary check before actual creation
updateupdatesubscriptionId, resourceGroupName, location, dryrunNameupdate a dryrun job to do necessary check before actual creation
deletedeletesubscriptionId, resourceGroupName, location, dryrunNamedelete a dryrun job

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
dryrunNamestringThe name of dryrun.
locationstringThe name of Azure region.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

get a dryrun job

SELECT
properties
FROM azure.service_connector.connector_dryruns
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND location = '{{ location }}' -- required
AND dryrunName = '{{ dryrunName }}' -- required
;

INSERT examples

create a dryrun job to do necessary check before actual creation

INSERT INTO azure.service_connector.connector_dryruns (
data__properties,
subscriptionId,
resourceGroupName,
location,
dryrunName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ location }}',
'{{ dryrunName }}'
RETURNING
properties
;

UPDATE examples

update a dryrun job to do necessary check before actual creation

UPDATE azure.service_connector.connector_dryruns
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND location = '{{ location }}' --required
AND dryrunName = '{{ dryrunName }}' --required
RETURNING
properties;

DELETE examples

delete a dryrun job

DELETE FROM azure.service_connector.connector_dryruns
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND location = '{{ location }}' --required
AND dryrunName = '{{ dryrunName }}' --required
;