topic Re: Cant make Unity Catalog work on Azure in Data Governance

Cant make Unity Catalog work on Azure

Gustavo_Az — Mon, 06 Feb 2023 12:04:30 GMT

Hello

I have created the metastore, linked it to the worskpace, my account is admin in Azure and Databricks, followed these instructions:

But when I try to create a table (granting privileges to use catalog, create schemas and create tables) I get this error:

Trying two another things, read from that metastore container, and from another container in the same storage account, I got an error for the first and a success for the second:

I dont know what I am missing to make it work. There is a complete guide to set up Unity Catalog?

Thank you.

Re: Cant make Unity Catalog work on Azure

Gustavo_Az — Mon, 06 Feb 2023 15:47:27 GMT

I also created an external location for trying to create tables in the container where I succeded to do an LS. I got an error while creating the external location, but the UI let me force it and it was created.

Then I test the connection to the external location and I get this other error (I think its the same when creating without forcing the external location.):

Re: Cant make Unity Catalog work on Azure

Cami — Mon, 06 Feb 2023 17:09:56 GMT

how did you configure access to storage ( metastore) in the UC ? It was managed identity or service principal.?

Re: Cant make Unity Catalog work on Azure

Gustavo_Az — Mon, 06 Feb 2023 18:38:28 GMT

With managed identity.

Re: Cant make Unity Catalog work on Azure

Gustavo_Az — Mon, 13 Feb 2023 14:53:32 GMT

I finally made it work.

It seems that although after configuring the metastore to work with a manged identity, the metastore must be upgraded with this guide.