Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Producing Dynamic SQL in Dataflow

As we can't currently pass parameters from Pipeline to Dataflow in Fabric, a workaround is to access Dynamic SQL from a txt file. We can use Table.FirstValue to read the first row of a txt file   ...
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

     

    I was just sharing a workaround for passing parameters into a Dynamic SQL query as we can't directly pass parameters to a Dataflow.

    The snippet above was intended for anyone who wanted to do the same.

    If you create a basic Gen2 Dataflow, and add a datasource....

    then modify the code generated to read the Dynamic SQL from a file and parse it into the Query. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Thanks for using Fabric Community.

Are you sharing any information or asking any query.
With the above context I am not able to get a bigger picture of it.
Could you please share few more details of your scenario and about your issue?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

I was just sharing a workaround for passing parameters into a Dynamic SQL query as we can't directly pass parameters to a Dataflow.

The snippet above was intended for anyone who wanted to do the same.

If you create a basic Gen2 Dataflow, and add a datasource....

then modify the code generated to read the Dynamic SQL from a file and parse it into the Query.