Skip to main content

triggers

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

Overview

Nametriggers
TypeResource
Idazure.data_factory.triggers

Fields

The following fields are returned by SELECT queries:

OK.

NameDatatypeDescription
idstringThe resource identifier.
namestringThe resource name.
etagstringEtag identifies change in the resource.
propertiesobjectProperties of the trigger.
typestringThe resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, factoryName, triggerNameapi-version, If-None-MatchGets a trigger.
list_by_factoryselectsubscriptionId, resourceGroupName, factoryNameapi-versionLists triggers.
create_or_updateinsertsubscriptionId, resourceGroupName, factoryName, triggerName, data__propertiesapi-version, If-MatchCreates or updates a trigger.
deletedeletesubscriptionId, resourceGroupName, factoryName, triggerNameapi-versionDeletes a trigger.
query_by_factoryexecsubscriptionId, resourceGroupName, factoryNameapi-versionQuery triggers.
subscribe_to_eventsexecsubscriptionId, resourceGroupName, factoryName, triggerNameapi-versionSubscribe event trigger to events.
unsubscribe_from_eventsexecsubscriptionId, resourceGroupName, factoryName, triggerNameapi-versionUnsubscribe event trigger from events.
startexecsubscriptionId, resourceGroupName, factoryName, triggerNameapi-versionStarts a trigger.
stopexecsubscriptionId, resourceGroupName, factoryName, triggerNameapi-versionStops a trigger.

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
factoryNamestringThe factory name.
resourceGroupNamestringThe resource group name.
subscriptionIdstringThe subscription identifier.
triggerNamestringThe trigger name.
If-MatchstringETag of the trigger entity. Should only be specified for update, for which it should match existing entity or can be * for unconditional update.
If-None-MatchstringETag of the trigger entity. Should only be specified for get. If the ETag matches the existing entity tag, or if * was provided, then no content will be returned.
api-versionstringThe API version.

SELECT examples

Gets a trigger.

SELECT
id,
name,
etag,
properties,
type
FROM azure.data_factory.triggers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND factoryName = '{{ factoryName }}' -- required
AND triggerName = '{{ triggerName }}' -- required
AND api-version = '{{ api-version }}'
AND If-None-Match = '{{ If-None-Match }}'
;

INSERT examples

Creates or updates a trigger.

INSERT INTO azure.data_factory.triggers (
data__properties,
subscriptionId,
resourceGroupName,
factoryName,
triggerName,
api-version,
If-Match
)
SELECT
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ factoryName }}',
'{{ triggerName }}',
'{{ api-version }}',
'{{ If-Match }}'
RETURNING
id,
name,
etag,
properties,
type
;

DELETE examples

Deletes a trigger.

DELETE FROM azure.data_factory.triggers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND factoryName = '{{ factoryName }}' --required
AND triggerName = '{{ triggerName }}' --required
AND api-version = '{{ api-version }}'
;

Lifecycle Methods

Query triggers.

EXEC azure.data_factory.triggers.query_by_factory 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@factoryName='{{ factoryName }}' --required,
@api-version='{{ api-version }}'
@@json=
'{
"continuationToken": "{{ continuationToken }}",
"parentTriggerName": "{{ parentTriggerName }}"
}'
;