topic Re: [UC_NOT_ENABLED] Unity Catalog is not enabled on this cluster in Data Governance

[UC_NOT_ENABLED] Unity Catalog is not enabled on this cluster

h_aloha — Mon, 03 Apr 2023 09:27:03 GMT

Hi,

I got error [UC_NOT_ENABLED] Unity Catalog is not enabled on this cluster, when run in the notebook to create a catalog.

Looks like I followed all the steps to set up workspace, metastore and compute. The steps are:

create workspace from UI -> Quick Start (Recommanded)
Update the metastore bucket policy and trust relationship, by following doc: https://docs.databricks.com/data-governance/unity-catalog/get-started.html#cloud-tenant-setup-aws
Create metastore in the same region as workspace, assign it to workspace
Restart compute (set up and auto start in step 1) by edit its config, make sure it's single user, single mode, and its instance profile is the IAM role to access dataset bucket that has been set up in step 1. DBR is 11.3
In notebook 6.1. of data-engineer-learning-path-v1.1.1-notebooks.dbc

Run: CREATE CATALOG IF NOT EXISTS ${DA.my_new_catalog}, it returns the error

Seems It still use workspace local hive_metastore

Noticed in UI - Update workspace, there is a toggle to enable Unit Catalog, and a drop down to choose the metastore, but if I toggle it on and select the metastore from drop down, and save. It disappears if I click "Update workspace" to open the config again.

However, assign a metastore to workspace has already been done from account -> data -> metastores -> Assign to workspace.

Appreciate for any hints. Thanks

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

Ajay-Pandey — Mon, 03 Apr 2023 11:12:47 GMT

Hi @Helen Morgen ,

Have you enabled the unity catalog on your workspace??

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

h_aloha — Mon, 03 Apr 2023 22:07:06 GMT

Hi ajaypanday678,

I enabled it in the console, by

clicking "Update Workspace", toggle the "Enable Unity Catalog"
Metastore drop down, choose the corresponding metastore that has assigned to this workspace
Click "Update"

The wield is when I click "Update Workspace" again, it's reset to disabled. Is this a console bug?

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

h_aloha — Mon, 03 Apr 2023 22:08:31 GMT

And I the error message: Unity Catalog is not enabled on this cluster

What does the "cluster" it refer to? the workspace cluster? or the compute cluster of this workspace?

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

h_aloha — Mon, 03 Apr 2023 22:22:45 GMT

"I followed the steps outlined in the documentation (https://docs.databricks.com/data-governance/unity-catalog/enable-workspaces.html#enable-your-workspace-for-unity-catalog) to assign the metastore to my workspace.

I verified that the workspace appears in the Workspaces tab of the metastore, and that the metastore appears in the Configuration tab of the workspace. However, as mentioned in my previous post, the "Enable Unity Catalog" toggle in the "Update Workspace" section always resets to "not enabled" regardless of the verification steps I completed."

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

Anonymous — Tue, 04 Apr 2023 05:11:04 GMT

Hi @Helen Morgen

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

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

h_aloha — Tue, 04 Apr 2023 08:07:19 GMT

Hi Vidula,

Thanks for looking into it.

Unfortunately, it's not resolved. I checked every place that could have been missed, and everything looks okay.

I would appreciate any hints you can provide.

Thanks

h_aloha

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

FerArribas — Tue, 04 Apr 2023 20:25:22 GMT

Hi @Helen Morgen,

Is it possible that you have enabled unity catalog after creating the cluster? You can try to create a new cluster as single user and runtime 12.x for example.

Regards,

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

FerArribas — Tue, 04 Apr 2023 20:26:08 GMT

Hi @Helen Morgen,

Is it possible that you have enabled unity catalog after creating the cluster? You can try to create a new cluster as single user and runtime 12.x for example.

Regards,

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

Sanjay_AMP — Wed, 10 May 2023 18:11:39 GMT

I had faced the same problem

I recreated the cluster (after enabling Unity Catalog) and it is working now

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

Meghana_Vasavad — Fri, 23 Aug 2024 18:47:57 GMT

Hi @h_aloha ,

I have an Azure subscription and I have a Databricks resource created. However, I need help to create a Unity Catalog. I cannot enable as it is not created, and I get errors while running DB notebooks with suggested creating clusters on DB Academy. Your help is appreciated. Thanks !

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

Meghana_Vasavad — Fri, 23 Aug 2024 18:51:09 GMT

Hi Ajay,

I'm currently having an azure subscription and I use Azure Databricks, However for some labs in Databricks Academy I'm unable to run notebooks 'Classroom setup' scripts, as It returns error 'UC not enabled in Workspace'. Could you walk me through creating UC and enabling. Appreciate your response.

Thanks,

Meghana

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

Meghana_Vasavad — Fri, 23 Aug 2024 18:53:31 GMT

Hi Sanjay,

Thanks,

Meghana

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

RiyazAliM — Mon, 02 Dec 2024 16:54:19 GMT

Hi @Meghana_Vasavad - I followed these steps below to solve the similar issue I faced today.

Evidently, your workspace is not UC enabled. Please find the MS Learn link below to follow the step-by-step instructions to enable UC via account console.

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