search

databricks / sqltools-databricks-driver

SQLTools driver for Databricks SQL
Other
10 stars 3 forks source link

Default Catalog Option Not Respected #37

Closed mokane-db closed 1 year ago

mokane-db commented 1 year ago

I created the table mokane.test_schema.test_table. When the connection is configured to use the catalog mokane by default the table is not accessible by its two-part identifier:

image

When fully qualified for the same connection + settings the query succeeds:

image

Queries to the hive_metastore catalog by two-part identifier appear to always work, and the connection's Table browser always shows the contents of the hive_metastore catalog.

fjakobs commented 1 year ago

I've made a small fix and improved the error reporting. For this to work you have to make sure that your SQL warehouse has UC support enabled.