Spotfire Analyst: How to connect to Databricks Unity catalog databases.

Keywords: Databricks Unity catalog, database, connector

Note that this is available out of the box in Spotfire Analyst 14.0 and higher.

For versions before 14 you can use the custom SQL below.

If you are using the Spotfire Databricks connector you cannot list the databases in the Databricks Unity catalog, you can only list the Hive_metastore tables.

A workaround to this is to directly connect to a specific Unity catalog database by using custom SQL similar to this:

 select <columns> from <unity catalog>.<db>.<table>

There is also custom connector that is available through the TIBCommunity that can handle Databricks unity catalog data:
https://community.spotfire.com/s/exchange/aCv4z0000008Oc1CAE/custom-connector-for-tibco-spotfire-to-connect-to-azure-databricks