Thoughtspot

Integrating your Thoughtspot in Catalog

Requirements

For all ThoughtSpot clients:

• ThoughtSpot admin credentials

You must create a user into your ThoughtSpot instance that has "Can administer ThoughtSpot" privilege.

If needed, whitelist Catalog IP

Here is our fixed IP: 35.246.176.138

Catalog managed

You can upload your credentials directly in the App when creating your ThoughtSpot integration.

We need:

{
    "base_url": "https://*****.thoughtspot.cloud",
    "username": "Catalog",
    "password": "*****"
}

For your first sync, it will take up to 48h and we will let you know when it is complete ✅

If you are not comfortable giving us access to your credentials, please continue to Client managed 👇

Client managed

Doing a one shot extract

For your trial, you can simply give us a one shot view of your BI tool's

To get things working quickly, here's a Google Colab to run swiftly our package.

Running the Extration package

Install the PyPi package

pip install castor-extractor[thoughtspot]

For further details: link

Running the PyPi package

Once the package has been installed, you should be able to run the following command in your terminal:

pip install castor-extractor[thoughtspot]

After installing the package, run the following command to begin the extraction:

castor-extract-thoughtspot [arguments]

castor-extract-thoughtspot -b "https://*****.thoughtspot.cloud" -u "Catalog" -p "*****" -o "/output/directory"

Credentials

• user and password

  • -u, --username: ThoughtSpot username

  • -p, --password: ThoughtSpot password

Other arguments

• -b, --server-url: ThoughtSpot base url, your api endpoint, usually your thoughtSpot URL homepage, an example: https://*****.thoughtspot.cloud

• -o, --output: target folder to store the extracted files

You can also get help with argument --help

Scheduling and Push to Catalog

When moving out of trial, you'll want to refresh your Tableau content in Catalog. Here is how to do it:

• Your source id provided by Catalog, referred as source_id in the code examples

• Your Catalog Token given by Catalog

We recommend using the castor-upload command:

castor-upload [arguments]

The Catalog team will provide you with

1. Catalog Identifier (an id for us to match your Thoughtspot files with your Catalog instance)

2. Catalog Token An API Token

You can then use the castor-upload command:

castor-upload [arguments]

Arguments

• -k, --token: Token provided by Catalog

• -s, --source_id: source id provided by Catalog

• -t, --file_type: source type to upload, here {VIZ}

Target files

To specify the target files, provide one of the following:

• -f, --file_path: to push a single file

or

• -d, --directory_path: to push several files at once (*)

(*) The tool will upload all files included in the given directory.

Make sure it contains only the extracted files before pushing.

Then you'll have to schedule the script run and the push to Catalog, use your preferred scheduler to create this job

You're done!