How to parameterize SQL pool name, Spark pool name, Self hosted Integration runtime name in Template parameter file created by publish button Synapse studio.

Anand, Vivek 5

Hi,

I have below Question:

We have different SQL pool name, Spark pool name, Self hosted Integration runtime names for DEV, QA and PROD env.

How to parameterize SQL pool name, Spark pool name, Self hosted Integration runtime name in Template parameter file created by publish button Synapse studio. So that override Dev values to QA/PROD values for Synapse workspace artifacts deployment task in CI/CD pipeline.

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2023-02-27T23:05:29.1666667+00:00

@Anand, Vivek Just checking in to see if the below information from @Vinodh247 was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2023-03-01T00:03:54.5933333+00:00

@Anand, Vivek We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you
Anand, Vivek 5 Reputation points

2023-03-10T11:02:10.0633333+00:00

The link shared is working good if we have published ARM template based on collaboration branch.

In our project, We are looking to deploy from different branches to our QA/PROD synapse workspace.

If we use "Validate and deploy" option from synapse deployment task v2 to publish ARM template runtime and deploy. We are not getting SQL pool name, Spark pool name, Self hosted Integration runtime names as parameter name. So we are not able to override dev values. To override dev values, we need to get these value as a parameter.

I went through documentation and understood we need to create one custom template parameter json file and to parameterize particular value which are not parameterize by default.
https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery

But i can not find code i need to put to parameterize SQL pool name, Spark pool name, Self hosted Integration runtime name.

Please suggest.

2 answers

Vinodh247 13,801 Reputation points

2023-02-26T11:43:18.08+00:00

Hi

Thanks for reaching out to Microsoft Q&A.

Please check the below link with accepted answer for one the requirement similar to that of yours. You will have to check and tweak with reference to your need.

https://learn.microsoft.com/en-us/answers/questions/704741/update-pipeline-parameters-in-the-deployment-to-an?childtoview=709088#comment-709088

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.
Please sign in to rate this answer.
Anand, Vivek 5 Reputation points

2023-03-09T13:11:05.29+00:00

Thank you for the Link.
Sign in to comment
Anjali 5 Reputation points

2023-10-11T06:30:03.69+00:00

How can we parameterise the sparkpoolname in GitHub action CICD deployment? The sparkpoolname are different in dev and QA environment. I don't see parameterization happening for sparkpool and SQL pool of I use custom parameter template approach .Please reply.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

How to parameterize SQL pool name, Spark pool name, Self hosted Integration runtime name in Template parameter file created by publish button Synapse studio.

2 answers