Skip to main content

How to set up ThoughtSpot

Updated today

Setup takes about 10 minutes.

Introduction

Connecting ThoughtSpot to Foundational allows Foundational to read metadata from your ThoughtSpot instance.

To make the connection, you need to:

  • Assign permissions in ThoughtSpot
    ​

  • Retrieve the ThoughtSpot secret key
    ​

  • Connect Foundational to ThoughtSpot

Prerequisites

Ensure you have:

Access permissions

The permissions you assign to Foundational enable it to read metadata.
​

ThoughtSpot has different permissions depending on whether Role-Based Access Control (RBAC) is enabled or not.

Access method

Required permissions

Enabled

Assign the permissions:
​Has Developer Privilege and Can share with all users.

Disabled (default)

Assign the role:
​Can administer ThoughtSpot.

RBAC is disabled by default. To enable it, contact ThoughtSpot support. Once enabled, you cannot disable it.

For both methods, ensure the user has access to the liveboards, answers, and connections you want Foundational to scan.

Assign permissions in ThoughtSpot

You assign the permissions in one of two ways.

Option A: RBAC disabled (default)

Add the Can administer ThoughtSpot privilege to the group the user belongs to.

  1. In ThoughtSpot, go to Admin settings.
    ​

  2. Click Groups.
    ​

  3. Select the group the user belongs to.
    ​

  4. Scroll down to the Privileges tab.
    ​

  5. Select the Can administer ThoughtSpot privilege.
    ​

  6. Save the settings.
    ​

Option B: RBAC enabled

Follow the ThoughtSpot RBAC documentation to assign the Has Developer Privilege and Can share with all users permissions to the group the user belongs to.

Retrieve the ThoughtSpot secret key

  1. In ThoughtSpot, select the user profile for the connection.
    ​

  2. From the side navigation, go to the Develop tab (#1) and click Security settings (#2).
    ​

  3. In Authentication and access, click Edit.
    ​

  4. In Authentication and access, enable the Trusted authentication toggle. (#1).
    ​

  5. Copy the secret key and save it. You'll need it to make the connection.
    ​

  6. Click Save Changes.

Connect Foundational to ThoughtSpot

  1. In Foundational, open the Connectors & Integrations page.
    ​

  2. In BI & Analytics, select the ThoughtSpot card and click Connect.
    ​

  3. Click Add Account.
    ​


    ​

  4. The initial setup screen opens. Click Start Setup.
    ​


    ​

  5. The Set Up New Connection screen opens.
    ​


    Enter the details:
    ​

    • Base URL: Your ThoughtSpot instance URL (e.g., https://your-org.thoughtspot.cloud).
      ​

    • Username: Use the email address of the ThoughtSpot user.
      ​

    • Secret Key: The trusted authentication secret key retrieved from ThoughtSpot.
      ​

  6. Click Next.​

  7. The final setup screen opens. To complete the connection, click Save.
    ​

That's it. Foundational is now connected to ThoughtSpot.

Related Articles
How to Set up Looker
How to set up Sisense
How to set up GitLab
How to Set up Salesforce
How to set up Spotfire
Did this answer your question?