Forum Discussion
Can't see table from Databricks Mirror
Just set up mirroring in Fabric to my databricks catalog. There is a table that I cannot see. Attempted to refresh. The object is not a view. Struggling to troubleshoot. Any ideas?
Hello trentglover
Seems like a permission issue, if mirroring process is completed and table is not visible
Ensure that the account used to set up the mirroring connection has the necessary permissions in Databricks Unity Catalog- EXTERNAL_USE_SCHEMA privilege on the schema containing the table
- USE permission on the relevant catalogs and schemas
- SELECT and MODIFY permissions on the tables
- Verify Fabric Permissions: Remember that Unity Catalog policies and permissions are not mirrored in Fabric. You may need to reconfigure access controls within Fabric
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/troubleshooting
- Confirm that the "External data access" flag is enabled on the Databricks metastore
- Verify that the table is a supported type. Mirroring only supports UC managed and unmanaged tables. Views, streaming tables, and certain other object types are not supported
Hope this helps.
please accept the solution if this is helpful.
Thanks
4 Replies
- nilendraFabric
Super User
Hello trentglover
Seems like a permission issue, if mirroring process is completed and table is not visible
Ensure that the account used to set up the mirroring connection has the necessary permissions in Databricks Unity Catalog- EXTERNAL_USE_SCHEMA privilege on the schema containing the table
- USE permission on the relevant catalogs and schemas
- SELECT and MODIFY permissions on the tables
- Verify Fabric Permissions: Remember that Unity Catalog policies and permissions are not mirrored in Fabric. You may need to reconfigure access controls within Fabric
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/troubleshooting
- Confirm that the "External data access" flag is enabled on the Databricks metastore
- Verify that the table is a supported type. Mirroring only supports UC managed and unmanaged tables. Views, streaming tables, and certain other object types are not supported
Hope this helps.
please accept the solution if this is helpful.
Thanks 
v-menakakotaCommunity Support
Hi trentglover ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
As nilendraFabric mentioned,go through the steps provided by him it may resolve your query.If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Regards,
Menaka.- v-menakakota
Hi trentglover ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.Thank you.
- v-menakakota
Hi trentglover ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.