Microsoft Fabric Updates Blog

Boost performance and save costs with Fast Copy in Dataflows Gen2

In this blog, you’ll learn how the Fast Copy feature helps to enhance the performance and cost-efficiency of your Dataflows Gen2.

In March, we announced the Public Preview of Fast Copy in Dataflows Gen2 within Microsoft Fabric. This feature allows you to ingest large amounts of data efficiently, leveraging the same backend as the Copy Activity in data pipelines. This helps to reduce data processing duration, and helps to improve cost efficiency. You also can find detailed instructions on enabling Fast Copy.

Let’s explore a real-world example to show case the benefits of enabling Fast Copy in Dataflows Gen2 within Microsoft Fabric. We used Dataflow Gen2 to load four CSV files, totaling 6GB, into a Lakehouse table. By comparing the performance and cost before and after enabling Fast Copy, we’ll demonstrate the significant improvements you can achieve.

Case 1: using native Dataflow Gen2 engine without Fast Copy

Configurations

To accomplish this scenario, create a Dataflow Gen2 by following these steps:

  • Upload 6GB of CSV files from ADLS Gen2 into Dataflow Gen2
  • Configure Power Query to combine the CSV files and
  • Set Lakehouse as the data output destination.

Performance result and cost

Dataflow Gen2 refresh of using native Dataflow Gen2 engine without Fast Copy

The Dataflow Gen2 Refresh operation consumed about 30 minutes with 28,816 CU seconds.

MetricCompute consumption
Dataflow Gen2 Refresh CU seconds 28,816 CU seconds

Total run cost at $0.18/CU hour = (28,816) / (60*60) CU-hours * ($0.18/CU hour) ~= $1.44

Case 2: using Dataflow Gen2 powered by Fast Copy

Configurations

To accomplish this scenario, you need to create a dataflow with the same steps from the previous test case. The only different step is to enable Fast Copy Feature as below:

Enable Fast Copy in Dataflow Gen2

Performance result and cost

Dataflow Gen2 refresh of using Dataflow Gen2 powered Fast Copy

The Dataflow Gen2 Refresh operation consumed almost about 4 minutes with 3,696 CU seconds on Dataflow Gen2 Refresh and 5,448 CU seconds on Data movement.

MetricCompute consumption
Dataflow Gen2 Refresh CU seconds3,696 CU seconds
Data movement CU seconds5,448 CU seconds

Total run cost at $0.18/CU hour = (3,696 + 5,448) / (60*60) CU-hours * ($0.18/CU hour) ~= $0.46

Summary

 FeaturePerformanceCostConclusion
Dataflow Gen2 without Fast CopyCopy Duration: 29:56$1.44 
Dataflow Gen2 powered by Fast CopyCopy Duration: 3:47$0.468x increase in performance
3x decrease in cost.

With Fast Copy in Dataflow Gen2, you will see significantly reduced data processing times and improved cost efficiency. From the example above, loading a 6 GB CSV file to a Lakehouse table in Microsoft Fabric results in an 8x increase in performance and a 3x decrease in cost.

More resources

Related blog posts

Boost performance and save costs with Fast Copy in Dataflows Gen2

October 10, 2024 by Abhishek Narain

At the Microsoft Fabric Community Conference Europe 2024, we announced the General Availability (GA) of Copilot for Data Factory. It operates like a subject-matter expert (SME), collaborating with you to design your dataflows. Find our Copilot for Data Factory GA announcement blog.   Today, we all brainstorm ideas and draw sketches before formalizing them. As … Continue reading “Use Azure OpenAI to turn whiteboard sketches into data pipelines”

October 4, 2024 by Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”