This article describes how to use ThoughtSpot with a Databricks cluster or a Databricks SQL warehouse (formerly Databricks SQL endpoint).
For a general overview and demonstration of ThoughtSpot, watch the following YouTube video (4 minutes).
To connect your Databricks workspace to Thoughtspot using Partner Connect, see Connect to a BI and visualization partner using Partner Connect.
Partner Connect only supports SQL warehouses for ThoughtSpot. To connect a cluster to Thoughtspot, connect manually.
In this section, you connect an existing Databricks SQL warehouse or cluster in your Databricks workspace to ThoughtSpot.
For SQL warehouses, you can use Partner Connect to simplify the connection process.
Before you connect to ThoughtSpot manually, you need the following:
A cluster or SQL warehouse in your Databricks workspace.
The connection details for your cluster or SQL warehouse, specifically the Server Hostname, Port, and HTTP Path values.
A Databricks personal access token. See Generate a personal access token.
As a security best practice, when authenticating with automated tools, systems, scripts, and apps, Databricks recommends you use access tokens belonging to service principals instead of workspace users. To create access tokens for service principals, see Manage access tokens for a service principal.
To connect to ThoughtSpot manually, do the following:
Sign in to ThoughtSpot.
Click Data > Connections > Add connection.
On the Choose your data warehouse page, for Name your connection, enter a name for this connection.
Click Databricks and click Continue.
On the Databricks connection details page, enter the following information:
For Host, enter the Server Hostname value from the requirements.
For HTTP Path, enter the HTTP Path value from the requirements.
For User, enter the word
For Password, enter the personal access token from the requirements.
On the Select tables page, click the database tables that you want to use.
To continue using ThoughtSpot, see the following resources on the ThoughtSpot website: