Databricks Connection to Redash

Karene
New Contributor

Hello,

I am trying to connect my Redash account with Databricks so that my organization can run queries on the data in Unity Catalog from Redash.

I followed through the steps in the documentation and managed to connect successfully. However, I am only able to access hive_metastore tables - none of the tables or schemas from Unity Catalog show up in redash.

I am guessing this is more a Databricks issue than a Redash one, as the connection with the Databricks SQL Warehouse has been established and is working. For some reason, the SQL Warehouse is only picking up the hive_metastore data and not Unity Catalog data. The SQL Warehouse is already Unity Catalog enabled.

Any tips on how to handle this would be much appreciated!

Thank you!

JameDavi_51481
Contributor

it looks like the Redash connector for Databricks is hard-coded to run `SHOW DATABASES`, which only shows `hive_metastore` by default. This probably needs to be updated to run `SHOW CATALOGS` and then `SHOW SCHEMAS in <catalog_name>` for each of those, and compose a list of catalog/schema combinations.