This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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.
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!
Announcing_the_General_Availability_of_Mirroring_for_Snowflake_in_Microsoft_Fabr
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.
Announcing_the_General_Availability_of_Mirroring_for_Snowflake_in_Microsoft_Fabr
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.
Introducing_Open_Mirroring_in_Microsoft_Fabric
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.
Announcing_the_General_Availability_of_Mirroring_for_Snowflake_in_Microsoft_Fabr
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.