Data Cleansing: Dataflow Gen1 vs Dataflow Gen2 vs Notebook?

[Anonymous]

As the subject suggested, which one should I use?

Which one is cheaper and faster?


I read from https://www.fourmoo.com/2024/01/25/microsoft-fabric-comparing-dataflow-gen2-vs-notebook-on-costs-and...
that using code-based is better, but is that true?

[Anonymous]

Thank you for your answer.

My data is quite complex but not so big (2GB at most). So, I probably use Notebook then.
However, my question on cost optimization is still unknown.

[mohitkumawat]

Hi @Anonymous ,

it depends on the Different Use Cases mention below

Small data or specific connector-:Use Dataflow Gen2
Large data source Use Copy tool -:in pipelines
Complex data transformations -:Use Notebook code

Options to get data into the Lakehouse - Microsoft Fabric | Microsoft Learn
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.