Microsoft Fabric Updates Blog

Fast Copy with On-premises Data Gateway Support in Dataflow Gen2

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 on-premises data stores using a gateway. You can use your existing on-premises data gateway in your Data Factory to access on-premise stores like SQL Server with Fast Copy in Dataflow Gen2.

Let’s see how it works. 

Assume that you have the on-premises data gateway installed and registered in your Data Factory as below.

Create your Dataflow Gen2, and you can access data from a SQL Server through that on-premises data gateway.

Click the Options button from Dataflow Gen2 pane to enable Fast Copy feature.

The indicator will also show you that your data will be loaded via Fast Copy after evaluating your data loading step.

After you finish all the configurations in Dataflow Gen2, publish it. You will see the copy activity engine is used to transfer your data from an on-premises SQL Server in a fast way.

More resources

Have any questions or feedback? Leave a comment below!

Gerelateerde blogberichten

Fast Copy with On-premises Data Gateway Support in Dataflow Gen2

oktober 30, 2024 door Patrick LeBlanc

Welcome to the October 2024 Update! Here are a few, select highlights of the many we have for Fabric this month. API for GraphQL support for Service Principal Names (SPNs). Introducing a powerful new feature in Lakehouses: Sorting, Filtering, and Searching capabilities. An addition to KQL Queryset that will revolutionize the way you interact with … Continue reading “Fabric October 2024 Monthly Update”

oktober 29, 2024 door Leo Li

We’re excited to announce several powerful updates to the Virtual Network (VNET) Data Gateway, designed to further enhance performance and improve the overall user experience. These new features allow users to better manage increasing workloads, perform complex data transformations, and simplify log management. Expanded Cluster Size from 5 to 7 One of the key improvements … Continue reading “New Features and Enhancements for Virtual Network Data Gateway”