Share via

ARM templates

arkiboys 9,711 Reputation points
2021-08-10T07:00:23.377+00:00

We have a-lot of pipelines in synapse.
How is it possible to regenerate these pipelines using ARM templates?
Is it just a matter of saving each pipeline's jason ARM templates individually in notepad and re-run them one at a time if required (i.e. if something goes wrong with development pipeline)?

Thank you

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

0 comments No comments

Answer accepted by question author

MartinJaffer-MSFT 26,161 Reputation points
2021-08-10T20:23:05.063+00:00

Hello @arkiboys and welcome back.

That could work, I think, however you would have to be careful about the things the pipeline depends upon. This will not work for linked services whose secrets are saved into Data Factory, not Key Vault. If there is a change in dataset, or which dataset the pipeline references, that must be resolved before regenerating the pipeline.

Triggers could also get messed up.

If you have that many pipelines, re-saving them one at a time sounds like a pain. On a one-off, and for edge cases, it works.

Umm, I just realized, I might be totally misunderstanding your ask. Are you talking about undoing a change in a single environment? Or are you talking about promoting dev -> prod like CI/CD?

For both cases, integrating a repository can help.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.