triggers

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

Overview

Name	triggers
Type	Resource
Id	azure.data_share.triggers

Fields

Name	Datatype	Description
id	string	The resource id of the azure resource
name	string	Name of the azure resource
kind	string	Kind of synchronization on trigger.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	Type of the azure resource

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, shareSubscriptionName, subscriptionId, triggerName	Get a Trigger in a shareSubscription
list_by_share_subscription	SELECT	accountName, resourceGroupName, shareSubscriptionName, subscriptionId	List Triggers in a share subscription
create	INSERT	accountName, resourceGroupName, shareSubscriptionName, subscriptionId, triggerName, data__kind	Create a Trigger
delete	DELETE	accountName, resourceGroupName, shareSubscriptionName, subscriptionId, triggerName	Delete a Trigger in a shareSubscription

SELECT examples

List Triggers in a share subscription

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

INSERT example

Use the following StackQL query and manifest file to create a new triggers resource.

All Properties

/*+ create */
INSERT INTO azure.data_share.triggers (
accountName,
resourceGroupName,
shareSubscriptionName,
subscriptionId,
triggerName,
data__kind,
kind
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ shareSubscriptionName }}',
'{{ subscriptionId }}',
'{{ triggerName }}',
'{{ data__kind }}',
'{{ kind }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: systemData
      value:
        - name: createdAt
          value: string
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: lastModifiedAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
    - name: type
      value: string
    - name: kind
      value: string

DELETE example

Deletes the specified triggers resource.

/*+ delete */
DELETE FROM azure.data_share.triggers
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND shareSubscriptionName = '{{ shareSubscriptionName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND triggerName = '{{ triggerName }}';