Synapse Stop and Restart Triggers missing in Github Actions

Question

In the following link:

https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#configure-the-deployment-task

There is a way for stopping and restarting triggers in Azure DevOps Release pipeline. But this is missing for Github Actions. The only thing we have available is to deploy/validate templates.

How can I stop and restart triggers so they can be automatically deployed using Github Actions?

Answer 1

Hello Rhuan Samary Barreto,

Welcome to the MS Q&A platform.

To stop a trigger, you can include the below code in the workspace template.

az synapse trigger stop --name "myTrigger" --workspace-name "myWorkspace"

To start a trigger:

az synapse trigger start --name "myTrigger" --workspace-name "myWorkspace"

To stop all triggers in a Synapse workspace using the az synapse trigger stop command, you can use the az synapse trigger list command to get a list of all triggers in the workspace, and then loop through the list to stop each trigger.

# Set the workspace name and resource group name
workspaceName="myWorkspace"
resourceGroupName="myResourceGroup"

# Get the list of triggers in the workspace
triggerList=$(az synapse trigger list --workspace-name $workspaceName --resource-group $resourceGroupName --query "[].name" -o tsv)

# Loop through the list of triggers and stop each one
for triggerName in $triggerList
do
  echo "Stopping trigger $triggerName"
  az synapse trigger stop --name $triggerName --workspace-name $workspaceName --resource-group $resourceGroupName
done

To start all triggers in the end:

# Loop through the list of triggers and start each one
for triggerName in $triggerList
do
  echo "Starting trigger $triggerName"
  az synapse trigger start --name $triggerName --workspace-name $workspaceName --resource-group $resourceGroupName
done

I hope this helps. Please let me know if you have any further questions.