Hi Team,
I would like to inform that my issue is resolved.
Please find summary:
Issue - Linked Service (Dataverse) using Credential with User Assigned Managed identity is not getting parametrized in Azure Synapse Analytics.
Summary - When we create Linked service in Azure Synapse workspace and publish main branch then Workspace_publish branch gets 2 files a)TemplateForPrameter.json b) TemplateForWorkspace.json and using Override Parameters its values gets changed environment wise environment.
But for me in Azure Synapse Analytics, I couldn't see these attributes in Parameters (like serviceUri in Linked Service & resourceId in Credential).
I would like to thank for your suggestion to create custom template file in root folder named templates-parameters-definition.json.
But when I followed the suggested code as below:
{ "linkedService":
{ "Dataverse":
{ "properties":
{ "typeProperties":
{ "serviceUri":
{ "type": "String", "defaultValue": "" }
}
}
}
},
"credential": { "abcCredential":
{ "properties":
{ "typeProperties":
{ "resourceId":
{ "type": "String", "defaultValue": "" } }
}
}
}
}
This has removed my existing parameters.
Then, I have used below code:
"Microsoft.Synapse/workspaces/linkedServices": { "": { "properties": { "typeProperties": { "accountName": "=", "username": "=", "connectionString": "|:-connectionString:secureString", "secretAccessKey": "|" } } }, "AzureDataLakeStore": { "properties": { "typeProperties": { "dataLakeStoreUri": "=" } } }, "AzureKeyVault": { "properties": { "typeProperties": { "baseUrl": "|:baseUrl:secureString" }, "parameters": { "KeyVaultURL": { "type": "=", "defaultValue": "|:defaultValue:secureString" } } } } }, "Microsoft.Synapse/workspaces/datasets": { "": { "properties": { "typeProperties": { "folderPath": "=", "fileName": "=" } } } }, "Microsoft.Synapse/workspaces/credentials" : { "properties": { "typeProperties": { "resourceId": "=" } } } }
Reference: https://dori-uw-1.kuma-moon.com/en-us/azure/synapse-analytics/cicd/continuous-integration-delivery
And, I am able to get parameters for serviceUri & resourceId.
I am really thankful for your help & support through out the journey and adding my knowledge in custom arm template implementation in Azure Synapse Analytics.
Thanks
Atul Kumar