Hi there,
I have solution - data pipeline in Synapse taking data from mysql database. I need to parametrize it to be able run process across many environemnts (CI/CD). I set many linked services with code referencing on variable in yml file in style like this
"url": "#{SYNW.adlsaaa}#"
It was still working and after my CD run it promoted correct value from yml file to dev/test/stage branch withou any issues. When I try to do the same thing within linked service referencing to mysql - it will promote changes to dev/test/stage from my main branch - but it will break the main branch and getting errormessage:
"Could not load resource 'ls_mysql_empadm_aaa'. Please ensure no mistakes in the JSON and that referenced resources exist. Status: Connection String Syntax Error, Position: 23, Possible reason: Connection String Syntax Error, Position: 23"
This is my code
{
"name": "ls_mysql_empadm_aaa",
"type": "Microsoft.Synapse/workspaces/linkedservices",
"properties": {
"connectVia": {
"referenceName": "AutoResolveIntegrationRuntime",
"type": "IntegrationRuntimeReference"
},
"type": "AzureMySql",
"typeProperties": {
"connectionString": "#{SYNW.mysqlstringaaa}#",
"password": {
"secretName": "mysql-empadm",
"store": {
"referenceName": "ls_kv_master",
"type": "LinkedServiceReference"
},
"type": "AzureKeyVaultSecret"
}
},
"annotations": []
}
}