Forum Discussion
Paramaterize Linked Service per Branch
Trying to design our workflow for developing changes to our Data Warehouse in Synapse and want to understand if this approach is possible. Say we want to have our Synapse-Live be our current pro...
Don't now if you already find a correct solution. But ideal you need to have 2 Synapse Workspace and within the release (Azure Dev Ops) you can change the db_name.
You just have to make sure that you parameterize the database name. An even better way is to store the connection string to your SQL Pool in a Keyvault secret and then create a Keyvault per environment and store the database including connection string in it