Skip to main content

triggers

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

Overview

Nametriggers
TypeResource
Idazure.data_share.triggers

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource id of the azure resource
namestringName of the azure resource
kindstringKind of synchronization on trigger.
systemDataobjectSystem Data of the Azure resource.
typestringType of the azure resource

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, shareSubscriptionName, triggerNameapi-versionGet a Trigger in a shareSubscription
list_by_share_subscriptionselectsubscriptionId, resourceGroupName, accountName, shareSubscriptionNameapi-version, $skipTokenList Triggers in a share subscription
createinsertsubscriptionId, resourceGroupName, accountName, shareSubscriptionName, triggerName, data__kindapi-versionCreate a Trigger
deletedeletesubscriptionId, resourceGroupName, accountName, shareSubscriptionName, triggerNameapi-versionDelete a Trigger in a shareSubscription

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
accountNamestringThe name of the share account.
resourceGroupNamestringThe resource group name.
shareSubscriptionNamestringThe name of the shareSubscription.
subscriptionIdstringThe subscription identifier
triggerNamestringThe name of the trigger.
$skipTokenstringContinuation token
api-versionstringThe api version to use.

SELECT examples

Get a Trigger in a shareSubscription

SELECT
id,
name,
kind,
systemData,
type
FROM azure.data_share.triggers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND shareSubscriptionName = '{{ shareSubscriptionName }}' -- required
AND triggerName = '{{ triggerName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Create a Trigger

INSERT INTO azure.data_share.triggers (
data__kind,
subscriptionId,
resourceGroupName,
accountName,
shareSubscriptionName,
triggerName,
api-version
)
SELECT
'{{ kind }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ shareSubscriptionName }}',
'{{ triggerName }}',
'{{ api-version }}'
RETURNING
id,
name,
kind,
systemData,
type
;

DELETE examples

Delete a Trigger in a shareSubscription

DELETE FROM azure.data_share.triggers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND shareSubscriptionName = '{{ shareSubscriptionName }}' --required
AND triggerName = '{{ triggerName }}' --required
AND api-version = '{{ api-version }}'
;