Microsoft Fabric Updates Blog

Announcing the General Availability of Mirroring for Snowflake in Microsoft Fabric

Mirroring for Snowflake is now generally available, a frictionless way to add your entire Snowflake databases into OneLake data estate. Setting up Mirroring is trivial and simple. Once Mirroring starts the replication process, the mirrored data is automatically kept up to date at near real-time in OneLake. With your Snowflake data landed into OneLake, the data is now available everywhere in Fabric and ready to accelerate your data potential.

Easily Mirror your Snowflake database into OneLake 

Mirroring enables you to replicate your Snowflake database into OneLake in Fabric with just a few simple clicks. By providing connection details or select a previously created connection, you can securely login onto your Snowflake database and start replication your data in near-real time into OneLake in Fabric. It is really that easy!

Setting up Mirroring for Snowflake is trivial with just a few clicks

Mirrored data is automatically kept up-to-date at near-real-time 

With the connection to your Snowflake database, Mirroring will create an initial snapshot of your data in OneLake and then continue to replicate your data in sync in near real-time with every transaction whenever a new table is created, or data is inserted, updated, and deleted. 

Underneath the hood, Mirroring leverages Snowflake change data capture (CDC) Streams to land data into a landing zone in OneLake. Once the change data is in the landing zone, Mirroring will automatically manage the changes to your data in a reliable way and convert your data into tables and ready for consumption immediately by any Fabric workload.

How Mirroring for Snowflake works underneath the hood

Accelerate data potential with your Mirrored Snowflake data in OneLake

Once your Snowflake data is mirrored, any Mirrored database can be queried and cross joined with other Mirrored databases, warehouses, or lakehouses in Fabric. As every analytics workload in Fabric works seamlessly with OneLake, your Snowflake data in OneLake can be used with Notebooks to analyze and create models, while building Power BI reports and semantic models quickly and efficiently. 

Mirrored Snowflake data can be used for all analytics workloads in Fabric

Mirrored Snowflake Databases are Fast and Efficient

With the same Snowflake data that is already mirrored into OneLake, you can now create PowerBI reports and semantic models with blazing fast performance using Direct Lake mode.

Direct lake vs Direct Query mode with Snowflake data

Mirroring Pricing

Mirroring for Snowflake, same for all Mirrored databases, offers you with free compute and free storage based on the capacity size. For example, if you purchase an F64 capacity, you get 64 free terabytes worth of storage exclusively for mirroring. OneLake storage is charged only when the free Mirroring storage limit is exceeded. 

You can learn more about Mirroring and OneLake storage pricing here.

Mirroring Availability

Today, Snowflake customers on any cloud can Mirror their Snowflake data into OneLake and accelerate their data potential with all workloads in Fabric. Together with Mirroring for Azure SQL DB, Azure Cosmos DB, and many more sources to be added, you can leverage the same Mirroring technology and trivial setup to bring your data estate into OneLake.

You can learn about the latest Mirroring for Azure SQL DB updates here.

We also love to learn about your ideas and what you need to run Mirroring in your production workload. Please add your ideas here.

Finally, please stay tuned to our Mirroring roadmap for new data sources and feature updates.

Learn more about Mirroring 

Related blog posts

Announcing the General Availability of Mirroring for Snowflake in Microsoft Fabric

September 26, 2024 by Ye Xu

Fast Copy in Dataflow Gen2 is now General Available! This powerful feature enables rapid and efficient ingestion of large data volumes, leveraging the same robust backend as the Copy Activity in Data pipelines. With Fast Copy, you can experience significantly shorter data processing times and improved cost efficiency for your Dataflow Gen2. Additionally, it boosts … Continue reading “Announcing the General Availability of Fast Copy in Dataflows Gen2”

September 26, 2024 by Guy Reginiano

Now you can set up Data Activator alerts directly on your KQL queries in KQL querysets.