topic Re: pass parameters to dataflow in Data Engineering

pass parameters to dataflow

arkiboys2 — Fri, 25 Oct 2024 06:42:48 GMT

Hello,

I have created a data factory pipeline in fabric.

I have also created a dataflow with parameters on year, month and day

When I add the dataflow to the data factory pipeline, it does not see the parameters and so not sure how to call the dataflow to pass parameters.

any suggestions?

thank you

Re: pass parameters to dataflow

Anonymous — Fri, 25 Oct 2024 08:04:17 GMT

Hi @arkiboys2 ,

When importing data into the pipeline, you should be able to see information about the parameter, I think it may be that you are not harmonizing the parameter types inside the dataflow, please check:

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: pass parameters to dataflow

Anonymous — Fri, 25 Oct 2024 08:18:32 GMT

Map pipeline parameters to Dataflow parameters in the activity settings. For example:

For the Dataflow parameter year, set it to @pipeline().parameters.year.

Do the same for month and day.

Re: pass parameters to dataflow

arkiboys2 — Fri, 25 Oct 2024 08:29:47 GMT

I see in your screen-shot you are referring to the pipeline parameter whereas I am referring to calling a dataflow activity from pipeline

Re: pass parameters to dataflow

frithjof_v — Sat, 26 Oct 2024 08:19:04 GMT

It's not possible.

We can vote for this Idea:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f761603-a400-ee11-a81c-6045bdb98602

Re: pass parameters to dataflow

jigneshpatel — Mon, 13 Jan 2025 14:00:14 GMT

The solution given in this post is about pipeline parameters. I am looking for dataflow parameter to be supplied when I add dataflow in my pipeline.

Also, in dataflow is there any way to have destination table name from parameter? as I do not see any script to update for destination.

Jignesh