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. Required. "ScheduleBased"
systemDataobjectSystem Data of the Azure resource.
typestringType of the azure resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, account_name, share_subscription_name, trigger_name, subscription_idGet Trigger in a shareSubscription. Get a Trigger in a shareSubscription.
list_by_share_subscriptionselectresource_group_name, account_name, share_subscription_name, subscription_id$skipTokenList Triggers in a share subscription. List Triggers in a share subscription.
createinsertresource_group_name, account_name, share_subscription_name, trigger_name, subscription_id, kindThis method creates a trigger for a share subscription. Create a Trigger.
deletedeleteresource_group_name, account_name, share_subscription_name, trigger_name, subscription_idDelete Trigger in a shareSubscription. Delete 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
account_namestringThe name of the share account. Required.
resource_group_namestringThe resource group name. Required.
share_subscription_namestringThe name of the shareSubscription. Required.
subscription_idstring
trigger_namestringThe name of the trigger. Required.
$skipTokenstringContinuation token. Default value is None.

SELECT examples

Get Trigger in a shareSubscription. Get a Trigger in a shareSubscription.

SELECT
id,
name,
kind,
systemData,
type
FROM azure.data_share.triggers
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND account_name = '{{ account_name }}' -- required
AND share_subscription_name = '{{ share_subscription_name }}' -- required
AND trigger_name = '{{ trigger_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

This method creates a trigger for a share subscription. Create a Trigger.

INSERT INTO azure.data_share.triggers (
kind,
resource_group_name,
account_name,
share_subscription_name,
trigger_name,
subscription_id
)
SELECT
'{{ kind }}' /* required */,
'{{ resource_group_name }}',
'{{ account_name }}',
'{{ share_subscription_name }}',
'{{ trigger_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
kind,
systemData,
type
;

DELETE examples

Delete Trigger in a shareSubscription. Delete a Trigger in a shareSubscription.

DELETE FROM azure.data_share.triggers
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND account_name = '{{ account_name }}' --required
AND share_subscription_name = '{{ share_subscription_name }}' --required
AND trigger_name = '{{ trigger_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;