An Apache Spark-based analytics platform optimized for Azure.
The issue is fix now.
Unity Catalog Metastore Setup Fix
Initial problem: Account-level Databricks CLI commands (databricks account metastores ...) kept failing with Error: Not Found, and the account console's Catalog section also returned "Not Found."
Root cause discovered: The AccountAdmin CLI profile was pointing to the wrong host. Running databricks auth login --host <workspace-url> earlier without a --profile flag had overwritten the AccountAdmin profile's host with the workspace URL instead of the account console URL (https://accounts.azuredatabricks.net). Every account-level API call was silently hitting the wrong endpoint as a result.
Complication along the way: While troubleshooting, an existing (auto-provisioned) Access Connector for Azure Databricks was deleted, which broke the storage credential tied to the workspace's original metastore — leaving the workspace's Catalog page showing "Metastore does not exist."
Steps taken to fix it**:**
Fixed the CLI profile — edited the local Databricks config file directly to correct the AccountAdmin profile's host to the account console URL, and added a separate profile pointing to the actual workspace URL. Re-authenticated both.
Confirmed account-level access worked — listing metastores now returned real results instead of errors.
Discovered the old metastore no longer existed at the account level, so it couldn't be deleted or repaired directly.
Created a new metastore pointing to the correct cloud storage location.
Reassigned the workspace to the new metastore using the assignment "create" command (which overwrites any existing assignment).
Recreated the Access Connector for Azure Databricks, and granted it the correct storage access role on the storage account.
Recreated the storage credential, correcting a JSON formatting issue along the way (fields needed to be at the top level of the request body, not nested under an extra wrapper key).
Verified — the Catalog page in the workspace UI cleared, and the new metastore showed up correctly in the account console.
End result: a fully working Unity Catalog metastore, correctly authenticated and assigned to the workspace.
CLI Commands Used to Fix the Issue
1. Check authentication profiles
bash
databricks
2. Fix the account-level profile (edit config file directly)
bash
nano
Corrected the AccountAdmin block to use the account console host, and added a separate profile block for the workspace host.
3. Re-authenticate both profiles
bash
databricks
4. Verify account-level access now works
bash
databricks
5. Check the broken/stale metastore assignment
bash
databricks
6. Create a new metastore
bash
databricks
7. Reassign the workspace to the new metastore (overwrites old assignment)
bash
databricks
8. Verify the new assignment
bash
databricks
9. Create the storage credential (fields at top level, no wrapper key)
bash
databricks
That's the full sequence, generalized with placeholders in place of your actual IDs/names.