topic Re: databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace in Get Started Discussions

databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace

HakanNordgren — Wed, 13 Mar 2024 12:41:12 GMT

databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace. The UI lists `hive_metastore`. It would be better if these two were consistent.

Re: databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace

HakanNordgren — Tue, 19 Mar 2024 17:36:48 GMT

@Retired_mod : Could I convince you to add the above as a bug to the backlog?

Re: databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace

HakanNordgren — Wed, 20 Mar 2024 13:19:11 GMT

Also, @Retired_mod : Is it possible to have both a `hive_metastore` catalog and a `spark_catalog` catalog.

Re: databricks-jdbc lists `spark_catalog` among catalogs for Standard tier Azure workspace

MichTalebzadeh — Wed, 20 Mar 2024 21:25:39 GMT

short answer is no

Databricks uses a single catalog -> Unity Catalog for managing tables created with Hive or Spark SQL, simplifying things. In spark sql you can do

spark-sql (default)> show catalogs; spark_catalog

HTH