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

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”

October 2, 2024 by Miguel Llopis

Last week was such an exciting week for Fabric during the Fabric Community Conference Europe, filled with several product announcements and sneak previews of upcoming new features. Thanks to all of you who participated in the conference, either in person or by being part of the many virtual conversations through blogs, Community forums, social media … Continue reading “Recap of Data Factory Announcements at Fabric Community Conference Europe”