Skip to main content

trigger_run

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

Overview​

Nametrigger_run
TypeResource
Idazure.synapse_artifacts.trigger_run

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
continuationTokenstringThe continuation token for getting the next page of results, if any remaining results exist, null otherwise.
valuearrayList of trigger runs. Required.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
query_trigger_runs_by_workspaceselectendpointQuery trigger runs.
rerun_trigger_instanceexectrigger_name, run_id, endpointRerun single trigger instance by runId.
cancel_trigger_instanceexectrigger_name, run_id, endpointCancel single trigger instance by runId.

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
endpointstringThe service endpoint host (no scheme). (default: )
run_idstringThe pipeline run identifier. Required.
trigger_namestringThe trigger name. Required.

SELECT examples​

Query trigger runs.

SELECT
continuationToken,
value
FROM azure.synapse_artifacts.trigger_run
WHERE endpoint = '{{ endpoint }}' -- required
;

Lifecycle Methods​

Rerun single trigger instance by runId.

EXEC azure.synapse_artifacts.trigger_run.rerun_trigger_instance
@trigger_name='{{ trigger_name }}' --required,
@run_id='{{ run_id }}' --required,
@endpoint='{{ endpoint }}' --required
;