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

July 19, 2024 by Penny Zhou

We are thrilled to share that you can easily browse and connect to your Azure resources automatically with the modern get data experience of Data Pipelines. With the Browse Azure experience, you don’t need to manually fill in the endpoint, URL or server and database name when connecting to Azure resources. Instead, the connection will … Continue reading “Quickly Connect to your Azure Resources in Fabric with the Data Pipeline Modern Get Data Experience”

July 17, 2024 by Ye Xu

Fast Copy boosts the speed and cost-effectiveness of your Dataflows Gen2. We loaded a 6 GB CSV file to a Lakehouse table in Microsoft Fabric with 8x faster and 3x cheaper result. See our last post for details. Today, we’re excited to announce that Fast Copy in Dataflow Gen2 now supports high-performance data transfers from … Continue reading “Fast Copy with On-premises Data Gateway Support in Dataflow Gen2”