Azure Synapse Studio CICD using YAML pipelines

Hi Elliott_LW  The correct file should be template-parameters-defination.json  not template-parameters-defination.txt and in that file you should write the correct path in order to parameterize the arm template generated.

That file should be placed in the main branch where the workspace code is committed.(The same path mentioned in Git configuration in the workspace)

cc : poornamishra 

For example : In my case I mentioned /SynapseDev as root folder (Screenshot below)

So I need to place the template-parameters-definition.json in the same path(Screenshot below)

Final Step : After you place the template-parameters-defination.json , you need to republish the code from the Synapse Workspace so that the ARM template is parameterized according to the template-parameters-defination.json file

Please follow the heading "Custom parameter syntax(Quoted from Microsoft Documentation)" in the blog above and

"Create custom parameters in the workspace template"  heading in the documentation Continuous integration & delivery in Azure Synapse Analytics - Azure Synapse Analytics | Microsoft Docs which has some guidelines on how to create a template-parameters-defination.json for customer parameterization .

Please also refer the sample template-parameters-defination.json file above in the blog

For example : If I want to parameterize bigdatapool reference names for the notebooks in workspace we need to mention the following, so that it refers to the JSON path in the ARM template and parameterizes it 

{
"Microsoft.Synapse/workspaces/notebooks": {
        "properties":{
            "bigDataPool":{
                "referenceName": "="
            }
        }
    }

Note :  

- Based on the location you want to parameterize in ARM template, you should mention the path like the above example

Hope this gives you a insight and helps 🙂 Thanks for following the blog