This article answers frequently asked questions about Mirroring Fabric SQL database.
Features and capabilities
How does mirroring for Fabric SQL database differ from mirroring for Azure SQL Database?
The same technology is used for both Azure SQL and Fabric SQL databases. The main difference is that authentication and setup are taken care for you in case of Fabric SQL database.
Is there a staging or landing zone for Fabric SQL database? If so, is it outside of OneLake?
A landing zone in OneLake stores both the snapshot and change data, to improve performance when converting files into delta verti-parquet.
How long does the initial replication take?
It depends on the size of the data that is being brought in.
How long does it take to replicate inserts/updates/deletes?
Near real-time latency.
Do you support replicating of views, transient or external tables?
No. Currently, only replicating regular tables are supported.
Can Power BI reports on mirrored data use direct lake mode?
Yes, since tables are all v-ordered delta tables.
Self-help
How do I know if my data is replicated?
If you're experiencing mirroring problems, perform the following database level checks using Dynamic Management Views (DMVs) and stored procedures to validate configuration. Contact support if troubleshooting is required.
- Execute the following query to check if the changes properly flow:
SELECT * FROM sys.dm_change_feed_log_scan_sessions
For troubleshooting steps, see Troubleshoot mirroring from Fabric SQL database.
What are the replication statuses?
Can I mirror only specific tables from my SQL database in Fabric?
No, all tables eligible for mirroring will be automatically included into mirroring.
Security
Is data ever leaving the customers Fabric tenant?
No.
Is data staged outside of a customer environment?
No. Data isn't staged outside of customer environment, it's staged in the customer's OneLake.
Cost Management
What are the costs associated with Mirroring?
There is no compute cost for mirroring data from Fabric SQL database to Fabric OneLake. The Mirroring storage cost is free up to a certain limit based on the purchased compute capacity SKU you provision. Learn more from the Mirroring section in Microsoft Fabric - Pricing.