Search code examples
azure-data-factory

Adding Parameters to dataflow Azure Data Factory

I have a problem, I want to get data from a source but with parameter. I created new parameter:

enter image description here

And I try to concat the query:

enter image description here

This is the error I get:

enter image description here

Solution

  • The above error is not because of the dataflow parameter. It's because your query in the string contains new line characters. I tried a query like below without any parameter, but you can see I got same error when I tried to publish or validate the dataflow.

    concat("select * from student 
where Name='AA'")

    enter image description here

    enter image description here

    So, to avoid this error, give your query in the concat() in a single line like below.

    concat("select * from student where Name='AA'")

    enter image description here