Blog Post

Azure Synapse Analytics Blog
8 MIN READ

Azure Synapse Studio CICD using YAML pipelines

poornamishra's avatar
poornamishra
Icon for Microsoft rankMicrosoft
Jan 07, 2022
Introduction:   In this article we are going to use YAML pipelines for doing the deployment of synapse code along with customization of input parameters which can help you create the deployment d...
Updated Apr 06, 2022
Version 4.0
Synapse SQL
colinrippeyfinarne's avatar
colinrippeyfinarne
Copper Contributor
May 26, 2022

A comment on the Powershell to stop/start the triggers, there is a current bug in the module and so a workaround is documented in this issue:

 

https://github.com/Azure/azure-powershell/issues/16368#issuecomment-975110601

 

Here's a sample to get it working:

 

           Install-Module -Name "Az.Synapse" -Confirm:$false  -Scope CurrentUser  -Force;
           $bearerToken = Get-AzAccessToken -ResourceUrl https://dev.azuresynapse.net
           $authHeader = @{
             'Content-Type' = 'application/octet-stream'
             'Authorization' = 'Bearer ' + $bearerToken.Token
           }

           $triggersSynapse = Get-AzSynapseTrigger -WorkspaceName "$(synapseWorkspaceNameProd)";
           $triggersSynapse | ForEach-Object { Invoke-WebRequest -Method POST -Uri "https://$(synapseWorkspaceNameProd).dev.azuresynapse.net/triggers/$($_.name)/stop?api-version=2020-12-01" -Headers $authHeader}