Skip to main content

connectors

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

Overview

Nameconnectors
TypeResource
Idazure.service_connector.connectors

Fields

The following fields are returned by SELECT queries:

Connector details.

NameDatatypeDescription
propertiesobjectThe properties of the Linker.
systemDataobjectThe system data.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, location, connectorNameReturns Connector resource for a given name.
listselectsubscriptionId, resourceGroupName, locationReturns list of connector which connects to the resource, which supports to config the target service during the resource provision.
create_or_updateinsertsubscriptionId, resourceGroupName, location, connectorName, data__propertiesCreate or update Connector resource.
updateupdatesubscriptionId, resourceGroupName, location, connectorNameOperation to update an existing Connector.
deletedeletesubscriptionId, resourceGroupName, location, connectorNameDelete a Connector.
validateexecsubscriptionId, resourceGroupName, location, connectorNameValidate a Connector.
generate_configurationsexecsubscriptionId, resourceGroupName, location, connectorNameGenerate configurations for a Connector.

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
connectorNamestringThe name of resource.
locationstringThe name of Azure region.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Returns Connector resource for a given name.

SELECT
properties,
systemData
FROM azure.service_connector.connectors
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND location = '{{ location }}' -- required
AND connectorName = '{{ connectorName }}' -- required
;

INSERT examples

Create or update Connector resource.

INSERT INTO azure.service_connector.connectors (
data__properties,
subscriptionId,
resourceGroupName,
location,
connectorName
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ location }}',
'{{ connectorName }}'
RETURNING
properties,
systemData
;

UPDATE examples

Operation to update an existing Connector.

UPDATE azure.service_connector.connectors
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND location = '{{ location }}' --required
AND connectorName = '{{ connectorName }}' --required
RETURNING
properties,
systemData;

DELETE examples

Delete a Connector.

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

Lifecycle Methods

Validate a Connector.

EXEC azure.service_connector.connectors.validate 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@location='{{ location }}' --required,
@connectorName='{{ connectorName }}' --required
;