Linked Service Synapse pipelines changing while migrating from Dev to QA

Question

I have Azure Synapse pipeline which is attached to linked service A in development, While migrating to QA using Azure Devops its automatically attaching and showing under different linked service from QA, I didnt pass any over ride parameter and its supposed to carry the same linked service attachment.Any ideas what could be happening.

I have checked all templateparameters and there is no over ride happening at any level for linked services.

Answer 1

Hello dhiraj garg,

Welcome to the MS Q&A platform.

Please correct me if my understanding is wrong. You want to replicate a synapse pipeline with the same exactly linked service configuration from your dev to QA. But once you have migrated the pipeline, you do not see the same linked service configuration in your QA environment.

Are you talking about the linked service name here? or any other parameters on the linked service? What is your dataset here?

If you are not using the override parameters, the linked service name will carry over from your development environment to your QA environment.

Please provide your pipeline details and the linked server configuration to replicate the issue from my end. meanwhile, you can verify the below details. Please check if your template has any incorrect references to the linked services. check the deployment logs to see if there are any errors related to the linked service changes. verify the devops pipeline configuration to make sure there are no override parameters causing the linked service to change during the deployment. I am looking forward to your reply.