Skip to main content

connectors

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

Overview

Nameconnectors
TypeResource
Idazure_extras.customer_insights.connectors

Fields

The following fields are returned by SELECT queries:

OK. Successfully get the connector.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
propertiesobjectProperties of connector.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, hubName, connectorName, subscriptionIdGets a connector in the hub.
list_by_hubselectresourceGroupName, hubName, subscriptionIdGets all the connectors in the specified hub.
create_or_updateinsertresourceGroupName, hubName, connectorName, subscriptionIdCreates a connector or updates an existing connector in the hub.
deletedeleteresourceGroupName, hubName, connectorName, subscriptionIdDeletes a connector in the hub.

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 the connector.
hubNamestringThe name of the hub.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Gets a connector in the hub.

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.connectors
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND hubName = '{{ hubName }}' -- required
AND connectorName = '{{ connectorName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates a connector or updates an existing connector in the hub.

INSERT INTO azure_extras.customer_insights.connectors (
data__properties,
resourceGroupName,
hubName,
connectorName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ hubName }}',
'{{ connectorName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Deletes a connector in the hub.

DELETE FROM azure_extras.customer_insights.connectors
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND hubName = '{{ hubName }}' --required
AND connectorName = '{{ connectorName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;