https://community.databricks.com/t5/data-engineering/databricks-connection-to-redash/m-p/66305#M33079 <P>Hello,</P><P>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.</P><P>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.</P><P>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.</P><P>Any tips on how to handle this would be much appreciated!</P><P>Thank you!</P> Tue, 16 Apr 2024 06:02:05 GMT Karene 2024-04-16T06:02:05Z https://community.databricks.com/t5/data-engineering/databricks-connection-to-redash/m-p/66305#M33079 <P>Hello,</P><P>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.</P><P>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.</P><P>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.</P><P>Any tips on how to handle this would be much appreciated!</P><P>Thank you!</P> Tue, 16 Apr 2024 06:02:05 GMT https://community.databricks.com/t5/data-engineering/databricks-connection-to-redash/m-p/66305#M33079 Karene 2024-04-16T06:02:05Z https://community.databricks.com/t5/data-engineering/databricks-connection-to-redash/m-p/68631#M33710 <P>it looks like the <A href="https://github.com/getredash/redash/blob/master/redash/query_runner/databricks.py" target="_self">Redash connector for Databricks</A> 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 &lt;catalog_name&gt;` for each of those, and compose a list of catalog/schema combinations.</P> Wed, 08 May 2024 20:51:06 GMT https://community.databricks.com/t5/data-engineering/databricks-connection-to-redash/m-p/68631#M33710 JameDavi_51481 2024-05-08T20:51:06Z