Share via

ADF Dataflow parametrize with query option

Vs2021 46 Reputation points
2022-01-28T06:45:38.59+00:00

I am trying to use query option in ADF dataflow source .
Since I need to pass a parameter, I am using dynamic sql as below

concat(toString('select * from '),toString($ParamTable),toString(' WHERE ColA IS NULL AND COLB IS NULL '))

Error got while trying to import schema
DSL compilation failed: DF-DSL-001 - DSL stream has parsing errors
Line 9 Position 107: token recognition error at: '\n'

can you please advice what am i doing wrong

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator
    2022-01-28T17:04:29.703+00:00

    Hi @Vs2021 ,

    Thank you for posting query in Microsoft Q&A Platform.

    Kindly use your dynamic SQL expression as 'select * from ' + $ParamTable + ' WHERE ColA IS NULL AND COLB IS NULL'

    Please check below screenshots where I tried same. It was working fine.

    169469-image.png

    Hope this will help. Please let us know if any further queries.

    -------------

    Please consider hitting Accept Answer. Accepted answers helps community as well.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.