Create Dataset from ThoughtSpot

This article details how to create a Dataset populated with data sourced from ThoughtSpot.

It assumes that you have already established connectivity with your ThoughtSpot server via the respective plugin connection profile.

1. Access New > Dataset > Create New

2. Dataset Editor > Info tab

Define the basics:

  1. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen
  3. Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains
  4. Description: optionally, provide any additional information about your Dataset
  5. Category: specify the Category where you Dataset will be placed

Move to the Data tab to define the source of data and how often it should be updated.

3. Define the Settings for Data Collection

  1. Data Source: select the connection profile you have created for ThoughtSpot
  2. Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
  3. Visualization: select a ThoughtSpot Object that should serve as a basis of your Dataset
  4. Input an MIQL Plugin Command listing all data that needs to be fetched from ThoughtSpot
  5. Validate your query

[6.3.1] Datasets can be moved between the available Data Storage locations. The screen below shows Tableau, but the functionality is essentially the same for all Plugins.

Click the Edit icon next to the Data Storage on Data tab and follow the prompts to complete the operation.

4. Plugin command will be validated and data collected on Save

  1. If the command is validated successfully, the Dataset columns and Data Preview are going to be shown below.
  2. At the upper right corner of the screen, click Enable & View.

5. Dataset will be displayed in Viewer

In the Dataset Viewer:

  1. You can refine your data with Dataset's internal filtering options by applying Rules and Grouping:
  2. Use the corresponding button to apply changes