ThoughtSpot

You can use ThoughtSpot to search directly against your data in Dremio for live analytics and actionable insights.

Supported Versions

Dremio supports ThoughtSpot cloud 8.3 and ThoughtSpot software 7.2.1.

Supported Authentication Methods

You can use your Dremio username and password.

Creating a Connection

note

While you're using the connection, the data fields that you create, modify, and delete in Dremio are reflected as table columns in ThoughtSpot. To account for new or outdated fields, you will need to go back into the data connection to check or uncheck the columns that you want added or removed on the Select Tables page.

1. Log into ThoughtSpot.

2. Go to Data > Connections > Add Connection.

3. On the Choose Your Data Warehouse page, specify your data connection details:

   a. In the Name your connection field, enter a name.

   b. (Optional) In the Describe your connection field, enter a brief description.

   c. For the Choose your data warehouse field, select Dremio.

4. Click Continue.

5. On the Dremio Connection Details page, specify your account credentials:

   a. To provide your Dremio username and password for authentication, select Use Service Account.

   b. In the Host field, enter the IP address for one of the coordinator nodes in your cluster.

   c. In the Port field, enter 31010.

   d. In the User field, enter your username.

   e. In the Password field, enter your password.

6. Click Continue.

7. On the Select Tables page, you can see all the data tables and views from Dremio. To select tables and columns from that list, select a table and check the boxes next to the columns for that table.

8. Click Create Connection.

9. In the Create Connection dialog, click Confirm.