โ02-09-2023 02:07 AM
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
โ04-19-2023 03:25 PM
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
โ10-12-2023 07:21 AM
Use a version 13.3 cluster - 11.3 isn't Unity-Catalog-aware
-=A=-
โ10-19-2023 12:35 PM
@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
โ10-19-2023 12:56 PM
Cluster Access mode should be Shared/Single user or use SQL warehouse as your cluster
โ06-24-2024 02:22 AM
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?
โ06-24-2024 02:44 AM
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.
โ06-24-2024 02:50 AM
Thanks for this hint, but Unity Catalog is enabled already...
โ06-24-2024 04:36 AM - edited โ06-24-2024 04:37 AM
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.
โ06-26-2024 12:49 AM
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.
โ06-26-2024 12:56 AM
It should also work with a Shared Access Mode cluster.
โ07-09-2024 12:37 AM
Thanks @aboer this works for me now after choosing the respective catalog under catalog section.
โ06-26-2024 03:28 AM
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!
โ08-17-2024 08:30 PM
great conversation,
โ09-17-2024 02:03 PM
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.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group