topic Re: Unity Catalog - Error getting sample data in data explorer in Data Governance

Unity Catalog - Error getting sample data in data explorer

Daithi — Thu, 09 Feb 2023 10:07:27 GMT

I get an error message saying I Error getting sample data, when I try to view sample data from a table in a schema I created in a Unity Catalog. I dropped the schema and table and got a collague to recreate and still the same message. We are both Unity Catlog Admins and he is not recieving this error and can see the sample data. Even when we drop and recreate in his name its the same issues...............I can see the data if I actual query it within the sql section. I believe it may be a permissions issue.........but it appears that we have identical permissions. Any help would be greatful.

I have added a screen shot of the error

Re: Unity Catalog - Error getting sample data in data explorer

YSF — Wed, 19 Apr 2023 22:25:39 GMT

I'm also getting this error for catalogs/schemas/tables I create. I get this when I click sample data. But I am able to otherwise query it from a notebook using SQL

Re: Unity Catalog - Error getting sample data in data explorer

abhaigh — Thu, 12 Oct 2023 14:21:48 GMT

Use a version 13.3 cluster - 11.3 isn't Unity-Catalog-aware

-=A=-

Re: Unity Catalog - Error getting sample data in data explorer

karthik_p — Thu, 19 Oct 2023 19:35:42 GMT

@Daithi can you please see if you have all previlage on catalog, look catalog/ table level permission, you can check under permissions tab on each level and update please

Re: Unity Catalog - Error getting sample data in data explorer

Krishnamatta — Thu, 19 Oct 2023 19:56:23 GMT

Cluster Access mode should be Shared/Single user or use SQL warehouse as your cluster

Re: Unity Catalog - Error getting sample data in data explorer

aboer — Mon, 24 Jun 2024 09:22:36 GMT

I have the same problem, unfortunately. I have all privileges on the schema & catalog and the cluster is a shared one with runtime version 14.3. Any solutions how to solve this?

Re: Unity Catalog - Error getting sample data in data explorer

Karlo_Kotarac — Mon, 24 Jun 2024 09:44:06 GMT

I had a similar issue recently. The problem was that the cluster used was not UC-compatible. Can you check if you can see this under cluster details?

If not use another cluster that is UC-compatibile.

Re: Unity Catalog - Error getting sample data in data explorer

aboer — Mon, 24 Jun 2024 09:50:06 GMT

Thanks for this hint, but Unity Catalog is enabled already...

Re: Unity Catalog - Error getting sample data in data explorer

jacovangelder — Mon, 24 Jun 2024 11:37:44 GMT

Is it the exact same error as in the starting post? Do you have SELECT permissions on at least the table and USE CATALOG permissions on the catalog? The only reason why you won't be able to see sample data is either a wrong cluster (ruled that one out) or a permissions mismatch on catalog and/or object (schema/table) level.

Re: Unity Catalog - Error getting sample data in data explorer

aboer — Wed, 26 Jun 2024 07:49:42 GMT

I got it now. I needed to select a serverless cluster in the top left corner of the unity catalog. Without this being chosen the sample data cannot be shown.

Re: Unity Catalog - Error getting sample data in data explorer

jacovangelder — Wed, 26 Jun 2024 07:56:05 GMT

It should also work with a Shared Access Mode cluster.

Re: Unity Catalog - Error getting sample data in data explorer

emmalily — Wed, 26 Jun 2024 10:28:01 GMT

It sounds like a permissions issue. Even though both of you are Unity Catalog Admins, there might be some hidden discrepancies. Since you can query the data but can't view sample data, it could be a UI bug. Double-check the permissions at the schema and table levels, and if the issue persists, reach out to Unity Catalog support. Hopefully, they'll resolve it quickly!

Re: Unity Catalog - Error getting sample data in data explorer

rakiuday — Tue, 09 Jul 2024 07:37:18 GMT

Thanks @aboer this works for me now after choosing the respective catalog under catalog section.

Re: Unity Catalog - Error getting sample data in data explorer

billieo — Sun, 18 Aug 2024 03:30:16 GMT

great conversation,

Re: Unity Catalog - Error getting sample data in data explorer

michalama — Tue, 17 Sep 2024 21:03:55 GMT

The cluster access mode can be set to either Shared or Single User, depending on your needs, or you can opt to use an SQL Warehouse for cluster management.

Re: Unity Catalog - Error getting sample data in data explorer

AlexRose1122 — Fri, 17 Jan 2025 16:58:20 GMT

It’s likely a permissions or session issue; try checking table-level ACLs, refreshing your session, or verifying role inheritance.

Re: Unity Catalog - Error getting sample data in data explorer

AnnexPetal — Wed, 22 Jan 2025 03:36:33 GMT

It sounds like a common issue with access control that can arise in database management systems or applications with user permissions. Checking table-level ACLs (Access Control Lists) is a great first step, as it ensures that the user has the proper permissions to access or modify the data. Refreshing your session can also help if there have been recent changes to permissions or roles that haven't been applied yet. Lastly, verifying role inheritance is crucial, as it determines if a user is properly inheriting permissions from their assigned roles. Addressing these areas should help resolve the access issue effectively!

Re: Unity Catalog - Error getting sample data in data explorer

bentennyysonn — Mon, 31 Mar 2025 11:37:39 GMT

Check your table level ACLs, refresh your session, and verify role inheritance. Even if permissions look the same, there might be a small difference causing the issue. Try comparing your access settings with your colleague’s to spot any discrepancies.