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 Reputation points
2023-02-24T08:41:16.97+00:00

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.

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.
4,364 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Vinodh247-1375 11,046 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.


  2. 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.

    0 comments No comments