Synapse - Linked service parameterization in ci-cd pipeline

NAGA SANDEEP KUMAR KAPA 51 Reputation points
2022-07-11T17:59:51.943+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,082 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 37,136 Reputation points Microsoft Employee
    2022-07-12T16:13:39.593+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Jan Kučera 0 Reputation points
    2023-07-31T10:14:40.4533333+00:00

    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.

    0 comments No comments