Fabric and Azure SQL in a few clicks: Mirroring a Database


Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now.

Before getting into a step-by-step of the process, let’s understand the basics.

Why Mirror a Database

You need to read data from production to build a single source of truth. If you create pipelines reading directly from production, you will create additional load over the production environment. The mirror allows you to