I am trying to pass filename as parameter to dataflow in synapse pipeline but facing issues.
I am setting a variable and passing that to dataflow as below.
Also created a parameter inside the dataflow
Inside connection given filepath as
When I try to import projection getting error. No idea about this, appreciate your help in resolving this. I suspect may be I am doing something wrong in passing parameters?
If you want to pass filename as parameter to dataflow follow below procedure:
Create dataset string parameter fileName for dataset as shown below:
Create pipeline string parameter fileName with value as shown below:
Provide above parameter as set variable value @pipeline().parameters.fileName
as shown below:
In data flow provide the variable fileName which is created in set variable activity to the data flow @variables('fileName')
as shown below:
Then you will be able to pass file name successfully without any error.
Note: No need to create parameters in data flow to pass file name while parameter created in dataset.