Forum Discussion
Helper IProblem detecting tables and views in Fabric warehouse
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.
Helper IHi tayloramy ,
There is one difference that I forgot to mention.
The tables that have been created for a long time and that I can see are in various schemas that were created for these tables some time ago.
The tables that I cannot see are in a different schema.
I did not mention this because I understood that in Fabric, you either have permission for the entire database or you do not, but you cannot have a user who can see some schemas and not others, as was the case in SQL Server on premise.
Could that be a clue?
Thank you!
Translated with DeepL.com (free version)
Super UserHi 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.
- AnHell
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 !