triggers

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

Overview

Name	triggers
Type	Resource
Id	azure.data_factory.triggers

Fields

vw_triggers

Name	Datatype	Description
id	text	The resource identifier.
name	text	The resource name.
description	text	field from the properties object
annotations	text	field from the properties object
etag	text	Etag identifies change in the resource.
factoryName	text	field from the properties object
resourceGroupName	text	field from the properties object
runtime_state	text	field from the properties object
subscriptionId	text	field from the properties object
triggerName	text	field from the properties object
type	text	The resource type.

triggers

Name	Datatype	Description
id	string	The resource identifier.
name	string	The resource name.
etag	string	Etag identifies change in the resource.
properties	object	Azure data factory nested object which contains information about creating pipeline run
type	string	The resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	factoryName, resourceGroupName, subscriptionId, triggerName	Gets a trigger.
list_by_factory	SELECT	factoryName, resourceGroupName, subscriptionId	Lists triggers.
create_or_update	INSERT	factoryName, resourceGroupName, subscriptionId, triggerName, data__properties	Creates or updates a trigger.
delete	DELETE	factoryName, resourceGroupName, subscriptionId, triggerName	Deletes a trigger.
query_by_factory	EXEC	factoryName, resourceGroupName, subscriptionId	Query triggers.
start	EXEC	factoryName, resourceGroupName, subscriptionId, triggerName	Starts a trigger.
stop	EXEC	factoryName, resourceGroupName, subscriptionId, triggerName	Stops a trigger.
subscribe_to_events	EXEC	factoryName, resourceGroupName, subscriptionId, triggerName	Subscribe event trigger to events.
unsubscribe_from_events	EXEC	factoryName, resourceGroupName, subscriptionId, triggerName	Unsubscribe event trigger from events.

SELECT examples

Lists triggers.

vw_triggers

SELECT
id,
name,
description,
annotations,
etag,
factoryName,
resourceGroupName,
runtime_state,
subscriptionId,
triggerName,
type
FROM azure.data_factory.vw_triggers
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

triggers

SELECT
id,
name,
etag,
properties,
type
FROM azure.data_factory.triggers
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
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_factory.triggers (
factoryName,
resourceGroupName,
subscriptionId,
triggerName,
data__properties,
properties
)
SELECT 
'{{ factoryName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ triggerName }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string
    - name: properties
      value:
        - name: type
          value: string
        - name: description
          value: string
        - name: runtimeState
          value: []
        - name: annotations
          value:
            - object

DELETE example

Deletes the specified triggers resource.

/*+ delete */
DELETE FROM azure.data_factory.triggers
WHERE factoryName = '{{ factoryName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND triggerName = '{{ triggerName }}';