Connecting ThoughtSpot to Kaivo

A step-by-step guide on how to connect ThoughtSpot to your Kaivo-managed data warehouse

Written By Aapo Mannismäki

Last updated 6 days ago

How to Connect ThoughtSpot to Kaivo

Connecting ThoughtSpot to your Kaivo-managed BigQuery data warehouse allows you to run search-driven analytics and build liveboards using your data. This connection is established securely using Google Cloud Service Account credentials.

Prerequisites

Before you begin, make sure you have:

  • Administrative or connection-creation permissions in your ThoughtSpot instance.

  • Your Kaivo Project ID (found in your Kaivo workspace under Connect ThoughtSpot instructions) or in BigQuery’s UI.

Step 1: Open the Connection Wizard in ThoughtSpot

  1. Log into your ThoughtSpot account.

  2. In the top navigation bar, click on DATA.

  3. Locate the left sidebar and select + Create new → Connection.

Step 2: Choose Your Data Warehouse

  1. Under Name your connection, type a recognizable name to identify this database within ThoughtSpot (for example, Kaivo BigQuery).

  2. Under Choose your data warehouse, select Google BigQuery from the grid of available data sources.

  3. Click Continue at the top of the wizard.

Step 3: Authenticate Using Your Kaivo Service Account

  1. Set the Authentication type dropdown menu to Service account.

  2. In the Project id field, enter your unique Kaivo Project ID.

  3. To fill the Service account text area, you will need your key file:

    • Open your Kaivo dashboard in a separate tab and navigate to the Service Account settings page.

    • Generate/create a new service account, then copy the raw JSON key file contents directly to your clipboard.

    • Return to ThoughtSpot and paste the entire JSON string into the Service account field.

  4. Click Continue.

Step 4: Select Your Tables and Columns

  1. A schema browser will load on the left side of the screen displaying your Kaivo datasets.

  2. Locate the dataset and tables you wish to sync.

  3. Select an entire table by checking the uppermost box next to its name, or click on a table to select individual columns on the right-hand panel.

  4. Once you have selected all required data, click Create connection at the top of the screen.

Your Kaivo data is now connected and ready for search-driven analytics within ThoughtSpot!

Need assistance? If you run into any issues mapping your tables or authenticating your project, please use the live chat widget located in the bottom-right corner of Kaivo application.