Data Cleansing: Dataflow Gen1 vs Dataflow Gen2 vs Notebook?

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.

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.