Create worksheets in Setup
To model your use case in analyst onboarding, create a worksheet.
| 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. |
To simplify data modeling, ThoughtSpot supports automated worksheet creation during Setup. When creating a worksheet through the Setup tab, you can view suggested joins, and take advantage of data modeling best practices, making your data easier to search.
About worksheets
Users are often unfamiliar with tables and how they relate to one another. A worksheet groups multiple related tables together in a logical way. Using worksheets 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 worksheet in Setup
To generate a worksheet through the Setup tab, follow these steps:
-
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.
-
Complete Step 1 of Setup, setting up your connection.
-
Select Step 2, Model data and create a Worksheet.
-
Select Create Worksheet in the lower-left corner. A list of the available fact tables from your connection appears.
-
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 worksheet and click Next.
After the worksheet is created, you will have the option to add more fact tables to its schema. -
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.
-
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. -
Select Next. The columns view of your worksheet 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).
-
[Optional] Select My Worksheet to change the name of your worksheet.
-
[Optional] Select the column titles to change the names of your searchable columns. You can also select the blue check-box next to a column name to remove it from your worksheet.
-
[Optional] Select the data type under Type to change the recorded data type. For example, you can change a data type like Zipcode from ‘Measure’ to ‘Attribute’.
-
Select Save worksheet. Your worksheet is now available to search and share.
Joins created in the setup of a worksheet are inherited at the table level. To remake your auto-generated worksheet through the Setup tab, you must first delete the worksheet, then delete the joins at the table level.
Next steps
Proceed to Search and visualize to complete Setup.
