Issue in azure synapse analytics while publishing (Custom Parameter Template File)

Tej 146 Reputation points
2023-03-09T11:37:37.7633333+00:00

Hi,

I am using custom template parameter file ('template-parameters-definition.json file') in the root folder of git branch to expose the required artifact properties which are missing in default template (TemplateParametersForWorkspace.json). I was able to expose the required properties needed, but only seeing issue with the triggers.

Let me explain my query in detail:

This is the code I'm using in template-parameters-definition.json file for trigger section (Microsoft.synapse/workspaces/Triggers)

	"Microsoft.Synapse/workspaces/triggers": {
			"properties": {
				"pipelines": [
					{
						"pipelineReference": {
							"referenceName": "=",
							"type": "="
						},
						"parameters": {
							"*":"="
						}
					}
				],
				"typeProperties": {
					"scope": "="
				}
				
			}
	}

After publishing this code, Iam seeing the incorrect/invalid parameter in TemplateParametersForWorkspace.Json file as below.


		"TriggerName_properties_0_parameters_Parameter": 

It should look like below which was reflecting correctly with the default template.

"TriggerName_properties_PipelineName_parameters_Parameter":

Not sure, if it's because the there is an array object pipelines.

I'm using this for event trigger, please let me know if the json code in custom template parameter file have to be modified or provide me the json sample needs to be used for Event trigger to get the proper parameter in templateparamaterForWorkspace file?

@AnnuKumari-MSFT @BhargavaGunnam-MSFT

Please assist on this?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,329 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Tej 146 Reputation points
    2023-03-10T08:41:47.0966667+00:00

    Hi @MartinJaffer-MSFT ,

    Thanks for your quick response.

    I have tried the code which was provided adding the 'pipeline:{' in custom template parameter file ('template-parameters-definition.json file') but still I do not see the required parameter name in the TemplateParameterForWorkspace.Json file.

    I'm still seeing the parameter key name as "TriggerName_properties_0_parameters_Parameter:" which is incorrect.

    which is supposed to be "TriggerName_properties_PipelineName_parameters_Parameter":

    Could you please replicate the issue on your side by creating the event trigger in synaspe workspace and then adding the template for triggers in custom template file ('template-parameters-definition.json file').

    Please assist on this.

    Thank you in advance.


  2. Romalee Amolic 0 Reputation points
    2023-08-08T04:28:07.8+00:00

    I faced the same issue. I resolved it by following the steps mentioned in the video below at 8:40 mins onward. The solution works but I still don't have any clarity on why the issue takes place or why the solution works. It will be good to know more about this from Microsoft.
    https://www.youtube.com/watch?v=4qhopCzsfM0&list=PLzUAjXZBFU9NPD095eD-9TOHk3O7DExdl&index=4

    Request you to mark this answer as 'Accepted' if this works for you :)

    0 comments No comments