An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hi Drithi,
This usually happens when Synapse Publish is not actually reading the custom parameter definition file, or the JSON path in the file does not match the linked service JSON.
A few things to check:
- The file name must be exactly:
template-parameters-definition.json
It must be committed in the root of the Git branch that Synapse uses as the collaboration branch. If the file is only in another branch, local folder, or not committed before Publish, Synapse will use the default parameter template.
For Synapse, make sure the resource type is:
"Microsoft.Synapse/workspaces/linkedServices"
not the Data Factory type:
"Microsoft.DataFactory/factories/linkedServices"
Make sure the property path matches the linked service JSON. For example, for a connection string under typeProperties:
{
"Microsoft.Synapse/workspaces/linkedServices": {
"*": {
"properties": {
"typeProperties": {
"connectionString": "|:-connectionString:secureString"
}
}
}
}
}
Re-publish from Synapse Studio after committing the file, then check whether TemplateParametersForWorkspace.json in the publish branch contains the new parameter.
ScopeBindings and synapse.httpextensionParameters.json will not create parameters by themselves. They can only override parameters that already exist in TemplateParametersForWorkspace.json.
If it is still not generated, I would test with a very small parameter definition first, for only one obvious linked service property such as connectionString or Key Vault baseUrl. If that works, then add the remaining linked service properties one by one.
Also, if the linked service uses Key Vault, it is usually better to keep the secret name consistent across environments and parameterize the Key Vault linked service/base URL rather than hardcoding connection strings in the deployment pipeline.
Docs:
Synapse CI/CD custom parameters: https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery#create-custom-parameters-in-the-workspace-template
Synapse workspace deployment task: https://learn.microsoft.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery
Parameterize linked services: https://learn.microsoft.com/en-us/azure/data-factory/parameterize-linked-services