Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
A mirrored Dremio catalog in Fabric integrates your data managed by Dremio with the rest of your data in Fabric. You can continuously replicate your Dremio catalog directly into Fabric's OneLake.
For a tutorial on configuring your Dremio environment for Dremio catalog mirroring into Fabric, see Tutorial: Configure mirrored Dremio catalog.
Important
This feature is in preview.
When you mirror a Dremio catalog, there is no data movement or data replication. Only the Dremio catalog structure is mirrored to Fabric, and the underlying catalog data is accessed through shortcuts. Changes to the underlying data may not appear in Fabric immediately. Propagation can take anywhere from a few seconds to several minutes, as described in the SQL Analytics Endpoint Performance documentation.
What analytics experiences are built in
Mirrored catalogs are items in Fabric distinct from other items such as Lakehouses and SQL analytics endpoints.
When you mirror a Dremio catalog, Fabric creates these items:
- Mirrored Dremio catalog item
- A SQL analytics endpoint for this item
You can access your mirrored Dremio catalog data multiple ways:
- Use T-SQL commands to define and query data objects from the read-only SQL analytics endpoint. Each mirrored Dremio catalog item has an autogenerated SQL analytics endpoint that provides a rich analytical experience created by the mirroring process.
- Use Power BI with Direct Lake mode to create reports against the mirrored Dremio catalog item.
- Use other Fabric workloads to query tables in the mirrored Dremio catalog item.
Metadata sync
When you create a new mirrored Dremio catalog in Fabric, the Automatically sync future tables option is enabled by default. The following metadata changes are reflected from your Dremio environment to Fabric if automatic sync is enabled:
- Addition of namespaces to the catalog
- Deletion of namespaces from the catalog
- Addition of tables to a namespace
- Deletion of tables from a namespace
Schema/table selection:
- The user can select which namespaces should be included as schemas, and they can exclude certain tables.
- Unselecting a namespace unselects all the tables within the namespace.
- If the user goes back and selects the namespace, all tables within the namespace are selected again.