Databricks Connection to Redash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2024 11:02 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 01:51 PM
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.