Synapse Replace typeParamaters Connection String using CICD

Giri, Seshu 26

I followed steps mentioned in this URL for Synapse CICD. https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/how-to-use-ci-cd-integration-to-automate-the-deploy-of-a-synapse/ba-p/2248060

But,

1. How do I replace connection string with production values ??

Giri, Seshu 26 Reputation points

2022-11-08T16:18:04.397+00:00

@AnnuKumari-MSFT

I tried your answer given in this thread and added a powershell script, but it says

Cannot find path 'D:\a\r1\a\abcd-synapse-repo\abcd-synapse-workspace-uat\TemplateForWorkspace.json'

Any idea, what I am doing wrong here?

https://learn.microsoft.com/en-us/answers/questions/704741/update-pipeline-parameters-in-the-deployment-to-an.html#comment-709088
AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2022-11-09T13:09:48.487+00:00

Hi @Giri, Seshu ,

Thankyou for using Microsoft Q&A platform and thankyou for posting your question here.

I understand you are trying to replace the parameters while trying to deploy your code from dev to higher environment. Are you trying to provide your local machine path? Is your code not uploaded to azure devops GIT repo?

You need to provide the artifact name from the release pipeline and synapse workspace name like this : (System.DefaultWorkingDirectory)/abcd-synapse-repo/abcd-synapse-workspace-uat/TemplateForWorkspace.json .

Kindly try the above suggested path and let me know how it goes. Thankyou.
AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee

2022-11-14T05:22:49.01+00:00

Hi @Giri, Seshu ,
Just checking back if the issue got resolved for you? Please let us know if the previous response was helpful. Kindly share the resolution details with community if the above response was not what helped you. Thanks