topic Re: Unable to access data from catalog. in Data Governance

Unable to access data from catalog.

Aman_Pundhir — Tue, 24 Jun 2025 07:20:28 GMT

I have all the necessary permissions like USE CATALOG on Catalog, USE SCHEMA on Schema and SELECT,TABLE on Table. But still when I try to access the table from catalog I get the error : Insufficient privileges: User does not have USE CATALOG on Catalog <Catalog_Name>. SQLSTATE: 42501. Also I am able to access the Table when I am using a SQL serverless compute but want to perform some ML functions using the 15.4 ML LTS compute.

Re: Unable to access data from catalog.

Pawan_1 — Tue, 24 Jun 2025 11:03:34 GMT

Could you please specify which cluster access modes you are using?

Re: Unable to access data from catalog.

SP_6721 — Tue, 24 Jun 2025 11:31:51 GMT

Hi @Aman_Pundhir ,

Could you please confirm if you are using a cluster with dedicated access mode and whether you are the owner of the table/streaming table you are trying to access?
Also, please review: https://docs.databricks.com/aws/en/dlt/dbsql/streaming#requirements

Re: Unable to access data from catalog.

Aman_Pundhir — Fri, 27 Jun 2025 05:11:45 GMT

Hi, @SP_6721 and @Pawan_1 ,

Thanks for your concerns. I was able to find the problem. So the problem was the cluster was assigned to groups and for the permissions were given to individual users. When the permissions were given to the group, we were able to access the data. Not sure why it was happening as even in the groups, individual users were there so according to me this shouldn't have happened. But anyways the issue is solved. If any of you guys know why did it not work even when individual user had the permissions but still it shows permission error please enlighten me as even in the databricks documentations, was not able to find anything.