hello, In adf I use global parameters. what is the alternative to this in synapse pipelines? Thank you

Hey, Unfortunately Synapse doesn't support Global Parameters : https://learn.microsoft.com/en-us/answers/questions/145623/global-parameters-in-azure-synapse-workspace.html The alternative would be to create pipeline parameters in every pipeline and duplicate the values

synapse - global parameters

Accepted answer

Nandan Hegde 32,336 Reputation points MVP

2022-08-17T10:27:56.07+00:00

Hey,
Unfortunately Synapse doesn't support Global Parameters :
https://learn.microsoft.com/en-us/answers/questions/145623/global-parameters-in-azure-synapse-workspace.html

The alternative would be to create pipeline parameters in every pipeline and duplicate the values
Please sign in to rate this answer.

1 person found this answer helpful.
arkiboys 9,691 Reputation points

2022-08-17T10:40:51.173+00:00

in adf, I use global parameter to hold the name of the keyvault in each instance i.e. dev/test, etc.
then inrelease pipeline I set it according to the environment

Nandan Hegde 32,336 Reputation points MVP

2022-08-18T07:49:35.897+00:00

You can refer the below blog:
https://thewindowsupdate.com/2022/06/21/cicd-automation-in-synapse-analytics-taking-advantage-of-custom-parameters-in-workspace-templates/

to handle change of values for Environments by using default parameters.
You can add that parameter yourself

Julian Gimbel 31 Reputation points Microsoft Employee

2023-03-30T09:29:31.6466667+00:00

You can also upvote the feature request here:

https://feedback.azure.com/d365community/idea/eaa47674-0442-ec11-a819-000d3ae2b5ca
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

synapse - global parameters

0 additional answers

Your answer