Forum Discussion
Problem detecting tables and views in Fabric warehouse
- 10 months ago
Hi AnHell,
Are you connecting to the warehouse using a SQL endpoint, or directly through OneLake with a Warehouse connection type?
The SQL Endpoints can take some time to sync.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi AnHell,
Actually in Fabric databases, you can have granular item level permissions - it's not just an all or nothing access.
See SQL Granular Permissions - Microsoft Fabric | Microsoft Learn
and Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Thank you very much!
When I was reviewing how to grant permissions in tables or schemas, I think I was fixated on doing it by schemas (as I had always done) and the answer was that it couldn't be done.
I'm going to take a good look at these links, but at first glance they already look very promising.
Thanks again tayloramy !