Issue in configuring synapse pipeline triggers during deployment

Question

Issue in configuring synapse pipeline triggers during deployment

Tej 146

Hi,

I am facing issue in synapse pipeline trigger deployment. I am using event trigger in dev environment and have created as below.

When I deployed the synapse workspace to UAT through synapse workspace deployment using azure devops. I am seeing the same dev subscription,storage account and other details after deployment to UAT in triggers which is causing me to manually change the details and start the triggers again.

Could someone assist on how to make changes to point to correct subscription, storage account for triggers during deployment so that I don't have to change manually?

Is there anything I have to make changes in override template parameters, if yes please assist on this.

0 comments

1 answer

Your answer

Answer 1

Hi @Tej ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As I understand the query, you are trying to deploy the Synapse ARM template from Dev to UAT, and want to know how to override parameters in the process. Please let me know if that is not the ask here.

Below are the resources you can leverage that talks through the end to end deployment steps including overriding parameter in synapse workspace/ADF :

CI CD in Azure Synapse Analytics
Continuous integration and deployment in Azure Data Factory

For updating a particular string , kindly check out: Update pipeline parameters in the deployment to another environment through Azure DevOps

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Tej 146 Reputation points

2022-12-09T16:51:53.847+00:00

Hi @AnnuKumari-MSFT ,

Thanks for your respose. I was able to deploy all the artifacts to higher environment successfully but have an issue only with the triggers deployment. After deployment the subscription is still pointing to the wrong one and storage account as well.

Let me explain my query in detail

When I create event trigger in dev enviroment, I have to configure the things as below screenshot like subscription, storage account, container etc.

When I deploy it via 'synapse workspace deployment' to the higher environment, the values are still same pointing to dev one.

I know one method that I have to override the template parameter i.e. 'TriggerName_properties_typeProperties_scope' to point to the correct subscription ,storage account,container etc. But the problem I have 30 triggers and will increase more, Do I have to manadatorily override all the 30 trigger parameters during release (TriggerName_properties_typeProperties_scope) to fix it.

is there any alternate automate way to handle this?

Thanks in advance

Share via

Issue in configuring synapse pipeline triggers during deployment

1 answer

Your answer