Error Code: METASTORE_DOES_NOT_EXIST when using Databricks API

[Frantz]

Hello, 

I'm attempting to use the databricks API to list the catalogs in the metastore. When I send the GET request to `/api/2.1/unity-catalog/catalogs` , I get this error 

I have checked multiple times and yes, we do have a metastore associated with this workspace. The issue is hindering other developments we would like to do using the databricks API (under unity catalog) Would anybody know what is going on?

[Kaniz]

Hi @Frantz, The error METASTORE_DOES_NOT_EXIST typically indicates that the Databricks API is unable to find a m....

Here are a few things you could check:

1. Directory Path: Ensure that the directory path you provided for the Metastore exists and is accessib...².
2. Credentials: Check if the credentials you provided have the necessary permissions to access the dire...².
3. Databricks Provider Configuration: If you’re using Terraform, the error might indicate an issue with...³.
4. Cluster Security Mode: If you’re encountering this error while trying to list a directory with dbutils, it could be related to the cluster security mode. It has been observed that setting "data_security_mode": "LEGACY_SINGLE_USER_STANDARD" in the JSON of...⁴.

If none of these solutions work, you might want to consider setting up an external Hive metastore⁵.

If you continue to face issues, I recommend reaching out for further assistance.

Hope this helps! 😊

[Frantz · Accepted solution]

Turns out I was using the wrong databricks host url when querying from postman. I was using my Azure instance instead of my AWS instance.