Error : No metastore assigned for the current workspace
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2023 12:53 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 09:00 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 09:35 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2023 04:16 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-11-2023 01:49 PM
Hi @Geir Iversen , Thanks for your confirmation.

