cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Change the default_catalog_name for a Unity Metastore assignment

113266
New Contributor II

Is there anyway to do this? From looking through the docs it seems like it can be set programmatically via CLI/Terraform but requires the assignment to removed first.

The reason I need this is because the default is currently hive_metastore and when that happens SHOW DATABASES only shows "default". This is causing Looker (and other JDBC connections) problems as they can't introspect the schemas/catalogs.

4 REPLIES 4

karthik_p
Esteemed Contributor

@Rob Myers​ Just curious to know, have you migrated all your data into new metastore from hive_metastore. because hive_metastore that you are seeing is just not a part of unity catalog meta store, it is just mounted, and we won't be benefited with all security features that unity catalog provides until you upgrade your tables from legacy hive. coming to your question to change default catalog please try to use below config and see spark.databricks.sql.initial.catalog.name hive_metastore

113266
New Contributor II

Not migrated - this is a new instance scratch.

I can't set that parameter for SQL warehouses.

karthik_p
Esteemed Contributor

@Rob Myers​ please login to SQL --> SQL Admin Console --> SQL Warehouse Settings (SQL Config parameters and try ) , if not use any warehouse and open sql editor and set below query

%sql

SET spark.databricks.sql.initial.catalog.name = hive_metastore;

113266
New Contributor II

Unfortunately neither of those work, dont think that parameter has been allowed for setting in SQL warehouses.

Also on a general purpose cluster is denied as it is a static configuration which needs to be done at start up.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!