topic Re: Unable to query Unity Catalog tables from notebooks. in Data Governance

Unable to query Unity Catalog tables from notebooks.

animadurkar — Wed, 31 May 2023 01:00:41 GMT

In my workspace, I'm able to see the unity catalogs my team has created. I'm able to see the schemas and even query data in there and create views using the SQL Editor.

When I go to write the same sql queries from a notebook using spark.sql or %sql I get this error:

AnalysisException: [UC_NOT_ENABLED] Unity Catalog is not enabled on this cluster.

I reviewed my cluster and it is a:

Databricks ML 13.0 Runtime
Access Mode is Single User
Personal Compute Policy

I'm unsure why this is the case, especially if I can access it normally outside of the notebook. Does anyone have ways to fix this?

Re: Unable to query Unity Catalog tables from notebooks.

animadurkar — Wed, 31 May 2023 16:04:28 GMT

Figured it out. Had to just delete my personal cluster (which was created before the unity metastore was set up) and recreate it. Then if you run "USE CATALOG my_catalog;" before your queries in your notebook, it works great.

Re: Unable to query Unity Catalog tables from notebooks.

Ajay-Pandey — Wed, 31 May 2023 16:05:26 GMT

Hi @Ani Madurkar ,

It's required that the cluster you are using should have unity catalog enabled then you will be able to query your catalog.

#DAIS2023

Re: Unable to query Unity Catalog tables from notebooks.

Rajeev_Basu — Fri, 02 Jun 2023 11:09:36 GMT

had a similar issue earlier.. thanks for the solution..

Re: Unable to query Unity Catalog tables from notebooks.

youssefmrini — Fri, 02 Jun 2023 13:29:00 GMT

You need to make sure that in the cluster you are using you have the Unity Catalog tag. Then in the notebook add the use catalog ..... after this you will be able to query your table if you have the permission.

Re: Unable to query Unity Catalog tables from notebooks.

Anonymous — Wed, 07 Jun 2023 10:03:51 GMT

Hi @Ani Madurkar

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!

Re: Unable to query Unity Catalog tables from notebooks.

animadurkar — Thu, 08 Jun 2023 14:24:05 GMT

Thanks! just did

Re: Unable to query Unity Catalog tables from notebooks.

KIRKQUINBAR — Mon, 06 Jan 2025 20:09:27 GMT

i know this is an old topic, but i have the same issue with querying data using the sql editor and a sql warehouse. my sql warehouse does have unity catalog enabled. not sure why it wouldnt be working.