Synapse Pipeline Parameters parametrising in ci/cd not appearing

NAGA SANDEEP KUMAR KAPA 51 Reputation points
2022-08-15T17:23:55.777+00:00

Hi,

I have a pipeline with parameters, when I published in synapse i don't see any parameters in templateparameters json file for deploying it to different environments.
Parameter value changes for each environment. How can I achieve it if there is another way.

Thanks in advance.

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,362 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,525 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 25,976 Reputation points Microsoft Employee
    2022-08-16T19:51:29.64+00:00

    Hello @NAGA SANDEEP KUMAR KAPA ,

    TemplateParametersForWorkspace.json file containing a global parameter for your workspace name and a parameter for each workspace
    ex: default linked service: the default SQL Server and the default Storage account.

    But if you check the TemplateForWorkspace.json in your publish branch, you will find several other properties(the artifact whose properties are not exposed by the default workspace parameters template.)

    On your end, you are seeing correct behavior. You no need to delete and publish again.

    So looks like you are trying to override the artifact properties(environment specific) that are not parameterized by the default parameters template(TemplateParametersforworkspace.json) right?

    In this case, you can use a customized parameters template. Please see the below documents.

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/cicd-automation-in-synapse-analytics-taking-advantage-of-custom/ba-p/3513546

    https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#create-custom-parameters-in-the-workspace-template

    I hope this helps. Please let me know if you have any further questions.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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