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
;