Databricks autocomplete uses hive_metastore catalog although we have other default catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ04-09-2024 12:24 AM
Databricks autocomplete is checking the hive_metastore catalog when I enter the schema_name and table_name in the notebook although we have other default catalog set at the workspace level. How to make Databricks autocomplete use that catalog when entering table name without specifying catalog_name?
- Labels:
-
Unity Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ04-10-2024 12:28 AM
Hi @Retired_mod ! Thanks for your answer. I forgot to mention that we already have this set up at the cluster level (using spark.databricks.sql.initial.catalog.name variable) besides setting this on the workspace level in the workspace settings but none of these things helped. Autocomplete always looks at the hive_metastore catalog if we don't specify the name of the catalog. However, if I use 'USE CATALOG' command first in the notebook then autocomplete works fine, but I was hoping it should work without that.

