LLMs.txt directory

Create Models in Setup

Worksheets are now referred to as Models.

To model your use case in analyst onboarding, create a Model.

To simplify data modeling, ThoughtSpot supports automated Model creation during Setup. When creating a Model through the Setup tab, you can view suggested joins, and take advantage of data modeling best practices, making your data easier to search.

This feature is specific to clusters based on connections to external data warehouses, not imported data (Falcon). To enable this feature for your cluster, contact ThoughtSpot support.

About Models

Users are often unfamiliar with tables and how they relate to one another. A Model groups multiple related tables together in a logical way. Using Models has the following advantages:

  • Pre-join multiple tables together.

  • Give a user or group access to only part of the underlying data.

  • Include a derived column using a formula.

  • Rename columns to make the data easier to search.

  • Build in a specific filter or aggregation.

  • Give users a filtered set of data to search.

Create a Model in Setup

To generate a Model through the Setup tab, follow these steps:

  1. Enter Setup by logging in for the first time, or by selecting Profile from the user icon at the upper right of the page and clicking Revisit under Preferences.

  2. Complete Step 1 of Setup, setting up your connection.

  3. Select Step 2, Model data and create a Model.

  4. Select Create Model in the lower-left corner. A list of the available fact tables from your connection appears.

  5. By default, ThoughtSpot suggests the fact table with the largest number of rows. Select the box next to the fact table from which you would like to create your Model and click Next.

    After the Model is created, you will have the option to add more fact tables to its schema.
  6. A list of the available dimension tables from your connection appears. Choose the dimension table(s) to join to your fact table and select Next. You can choose up to four dimension tables.

  7. The joins interface appears, showing a join based on a column of data both tables contain. You can proceed with the suggested join, or select the column names to change the join.

    The default join type is Inner, which will yield all search results with matching values from the fact table and the dimension table. You can select the Venn diagram icon to change the join type.
  8. Select Next. The columns view of your Model appears. You may notice that the column names have been changed to make them more easily searchable (for example, underscores may be replaced with spaces).

  9. [Optional] Select My Model to change the name of your Model.

  10. [Optional] Select the column titles to change the names of your searchable columns. You can also select the blue checkbox next to a column name to remove it from your Model.

  11. [Optional] Select the data type under Type to change the recorded data type. For example, you can change a data type like Zip code from ‘Measure’ to ‘Attribute’.

  12. Select Save Model. Your Model is now available to search and share.

    Joins created in the setup of a Model are inherited at the table level. To remake your auto-generated Model through the Setup tab, you must first delete the Model, then delete the joins at the table level.

Next steps

Proceed to search and visualize to complete Setup.