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 

Liittyvät blogikirjoitukset

Announcing the General Availability of Mirroring for Snowflake in Microsoft Fabric

lokakuuta 31, 2024 tekijä Jovan Popovic

Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the textual data, Fabric DW supports the VARCHAR type that can store up to 8KB of text, which is suitable for most of the textual values … Continue reading “Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse”

lokakuuta 29, 2024 tekijä Dandan Zhang

Managed private endpoints allow Fabric experiences to securely access data sources without exposing them to the public network or requiring complex network configurations. We announced General Availability for Managed Private Endpoint in Fabric in May of this year. Learn more here: Announcing General Availability of Fabric Private Links, Trusted Workspace Access, and Managed Private Endpoints. … Continue reading “APIs for Managed Private Endpoint are now available”