Synapse - Linked service parameterization in ci-cd pipeline

Question

If we use use Managed Identity as the authentication to SQL DB/Datalake from synapse/adf. Do we need to still override the parameter for connection string in ci/cd override parameter section. If yes which part do we need to override. Not only with SQL DB also with synapse DB.

Answer 1

Hi @NAGA SANDEEP KUMAR KAPA ,

Thank you for posting query in Microsoft Q&A Platform.

If your SQL server information is different for different environments then yes you should consider overriding it. During deployment you may see option to override parameters there you should consider doing it.

Hope this helps. Please let us know how it goes.

-------
Please consider hitting Accept Answer. Accepted answers help community also.

Answer 2

Just for completness, only some parameters are visible for parametrization. To widen this scope to include the parameters you need, you can use the file template-parameters-definition.json described at https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/cicd-automation-in-synapse-analytics-taking-advantage-of-custom/ba-p/3513546#:~:text=Using%20a%20customized,your%20collaboration%20branch.