ADF Dataflow parametrize with query option

Question

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

Answer 1

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.

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

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

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