topic Re: Error : No metastore assigned for the current workspace in Data Governance

Error : No metastore assigned for the current workspace

164079 — Sun, 15 Jan 2023 08:53:42 GMT

Hi team,

Is anyone encounter this error?

AnalysisException: [RequestId=d065497e-b88c-4687-9687-d7180663e7ba ErrorClass=METASTORE_DOES_NOT_EXIST] No metastore assigned for the current workspace

We are using Databricks on AWS

Thanks!

Re: Error : No metastore assigned for the current workspace

grazie — Mon, 16 Jan 2023 17:00:53 GMT

We see the same error, and can trigger it by trying to list a directory with dbutils.

dbutils.fs.ls("some_abfss_path") 
-->
[RequestId=74f37535-0483-4822-bd76-83951839b63b ErrorClass=METASTORE_DOES_NOT_EXIST] No metastore assigned for the current workspace.

Running Azure Databricks

Re: Error : No metastore assigned for the current workspace

grazie — Tue, 17 Jan 2023 12:16:40 GMT

I did test with different access modes and found that it indeed works with "data_security_mode": "LEGACY_SINGLE_USER_STANDARD". I also found clusters with no entry for "data_security_mode" which worked as expected.

Re: Error : No metastore assigned for the current workspace

Debayan — Tue, 17 Jan 2023 05:35:22 GMT

Hi, Could you please confirm which cluster security mode has been used? Please check the JSON of the cluster. It needs to be as below:

"data_security_mode": "LEGACY_SINGLE_USER_STANDARD"

Please let us know if this helps.

Re: Error : No metastore assigned for the current workspace

Debayan — Thu, 11 May 2023 20:49:07 GMT

Hi @Geir Iversen , Thanks for your confirmation.