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

[HakanNordgren]

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.

[HakanNordgren]

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

[HakanNordgren]

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

[MichTalebzadeh]

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