You can connect to Cube from Thoughtspot (opens in a new tab) using the Cube SQL API.

Enable Cube SQL API

Cube Cloud

Click How to connect your BI tool link on the Overview page, navigate to the SQL API tab and enable it. Once enabled, you should see the screen like the one below with your connection credentials:

Self-hosted Cube

You need to set the following environment variables to enable the Cube SQL API. These credentials will be required to connect to Cube from Thoughtspot later.


Connecting from Thoughtspot

Thoughtspot connects to Cube as a Postgres database.

In Thoughtspot, go to the Setup tab, then click Connect now to add a new data source:

Enter a name for the data source, choose Postgres as the data warehouse and click Continue in the header.

Enter credentials from the previous step and click Continue:

Select columns from the desired cubes and click Create Connection on the next screen:

Querying data

Your cubes will be exposed as tables, where both your measures and dimensions are columns.