topic Re: Problem in enabling unity catalog in Data Governance

Problem in enabling unity catalog

munjal_prerna — Fri, 24 Mar 2023 09:47:10 GMT

I have databricks premium and I want to enable unity catalog on it, I am not able to do so. I followed the following steps which are attached in the attachments. I am also attaching the screenshot of my cluster configuration.

When I run this command: SHOW GRANTS ON SCHEMA main.default

I get this error: Error in SQL statement: SparkException: Unity catalog is not enabled on this cluster.

Re: Problem in enabling unity catalog

Anonymous — Fri, 24 Mar 2023 16:50:43 GMT

@Prerna Munjal Can you share the Data explorer UI or show the results SHOW CATALOGS command?. Have you set up the UC metastore first in the Databricks account console if not follow the below document and set up the metastore first. If it's already created, can you test it using shared access mode?

https://docs.databricks.com/data-governance/unity-catalog/create-metastore.html

Re: Problem in enabling unity catalog

Hemant — Sun, 26 Mar 2023 19:47:51 GMT

It seems your workspace is not attached to the unity catalog metastore, for a detail process to enable unity catalog on your current workspace, please follow the below link.

https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/get-started

Re: Problem in enabling unity catalog

Anonymous — Thu, 30 Mar 2023 04:32:31 GMT

Hi @Prerna Munjal

Help us build a vibrant and resourceful community by recognizing and highlighting insightful contributions. Mark the best answers and show your appreciation!

Regards