ThoughtSpot Software Documentation

January 2023 8.8.1.sw

The new Answer experience is now GA and on by default. It contains new features and enhancements, including an in-product undo, redo, and reset button, HTML for answer titles and descriptions, and improvements to conditional formatting for charts, tables, and pivot tables.

To try it out, navigate to any answer. For more information, see New Answer experience.

This release includes several enhancements to all geo charts:

The new SpotIQ experience is now GA and on by default. SpotIQ has a new reorganized and more intuitive UI. The functionality remains the same.

To try it out, navigate to your profile, scroll down to Experience, select Edit, and toggle the SpotIQ experience to New experience. This feature is dependent on the new answer experience; to use the new SpotIQ experience, you must first enable the new answer experience. For more information, see SpotIQ.

The new Liveboard experience is GA and on by default. It contains new features and enhancements, including Liveboard tabs, custom visualization sizes, Edit mode, HTML in Liveboard titles and descriptions, and improved filtering. It is on by default. For more information, see New Liveboard experience.

Set your ThoughtSpot locale to Chinese (Traditional), or 中文 (繁體). ThoughtSpot changes your data format settings, such as currency and number formatting, and translates keywords, ThoughtSpot menu and navigation items, operators, and error messages. For more information, see 中文 (繁體) keyword reference and Change language and data format settings.

Customize the colors used for heatmap and treemap charts. Select any color in your color palette. For more information, see Heatmap charts and Treemap charts.

The formula editor assistant now contains a search bar for formula functions. Use it to search for specific functions to include in your formula. For more information, see Add a formula to a search.

We changed the default behavior for table aggregation summaries when the search contains a formulas that contain both a conditional clause (if…​ then…​ else) and a group_aggregate expression. When a user searches with a formula containing both a conditional clause and a group_aggregate expression, then ThoughtSpot detects the aggregation type on the first non-constant output clause and uses it in the headline summary. In this context, a non-constant output clause means any base column reference (for example, Revenue), or formula (for example, sum(revenue)).

For example, in the formula group_aggregate(sum(if (Color = 'blue') then 0 else group_unique_count(Discount))), the headline summary would use COUNT_DISTINCT, since the first non-constant output clause within the if…​ then…​ else clause is group_unique_count and has an aggregation type of COUNT_DISTINCT.

For more information, see Results that are tables.

We have made the following improvements to the Show underlying data feature:

The new year_name formula function returns the year in string format for a given date. This improves the behavior of formulas involving years when using a custom calendar with year values that are not in integer format. For more information, see the Formula function reference.

This release improves the translated German keywords. For more information, see Deutsch keyword reference.

ThoughtSpot now supports multiple contains, begins_with, and ends_with phrases in vs queries. For example, you can now have a versus query such as state name begins_with 'a' state name begins_with 'c' vs state name begins_with 'd'. For more information, see the Keyword reference.

You can no longer select more than 100 data sources to search on when searching data. This maximum of 100 sources improves performance and limits timeouts due to the selection of too many sources. For more information, see Choose a data source.

This release introduces support for custom R analysis in the new answer experience. R integration is disabled by default. To try it out, contact ThoughtSpot Support. For more information, see Custom R analysis.

Import TML files that contain certain errors. During the import process, ThoughtSpot removes the part of the object that contains errors, and allows you to import the rest of the object. For more information, see Migrate an object.

Edit tags for tables, worksheets, views, and SQL views from the Data workspace home page. Simply click on the checkbox next to any object in the Data workspace object list, and select Edit tags. For more information, see Use tags to organize.

Denodo is a new connection type, which supports OAuth. See Denodo, and Denodo OAuth.

Starburst connections now support OAuth. For details, see Configure OAuth for a Starburst connection.

This release brings improvements in how ThoughtSpot handles user tokens for Snowflake connections configured with Snowflake OAuth. If a user’s refresh token becomes invalid, the administrator or author of the connection can now run the Invalidate Tokens command to allow the user to re-authenticate and regain access to the insights provided by the connection, and the connection itself. Also, in this release the Role field has been added to the Snowflake OAuth connection details page, allowing a role to be added when the connection is created and changed when a connection is edited. See Invalidating refresh tokens of a Snowflake connection.

Use Okta as your authorization server for external OAuth. For details, see Configure Okta OAuth for a Snowflake connection.

ThoughtSpot now securely stores your consumption data in a searchable Snowflake data store. For more information, see Consumption data storage.

This release includes the following improvements to the dbt integration:

For more information, see Integrate with dbt.

Delete a join from the ThoughtSpot UI even if the join has dependents. This allows you to delete a join and create it again in the other direction, without invalidating or deleting any dependent objects. For more information, see Delete a relationship.

With query banding, Teradata connections now support the trust SQL feature in Teradata. This provides additional permissions to a ThoughtSpot user for accessing specific tables in Teradata to execute queries. The user must be configured as an application proxy user in Teradata. Query banding also allows tracking of statistics for queries executed by a user. Refer to Add a Teradata connection.

ThoughtSpot supports customer-managed deployment of ThoughtSpot on RHEL 8 with Microsoft Azure. For more information, see RHEL and OEL deployment.

ThoughtSpot supports customer-managed deployment of ThoughtSpot on RHEL 8.6 and 8.7, in addition to the RHEL versions supported in previous releases. ThoughtSpot certifies RHEL 8.6 and 8.7 for AWS, Microsoft Azure, and VMware. For more information, see RHEL and OEL deployment.

If you install your ThoughtSpot cluster on RHEL, you can now manage privilege escalation through an external tool that integrates with Ansible. For more information, see Manage RHEL cluster operations on Ansible.

Customers licensed to embed ThoughtSpot can use ThoughtSpot Everywhere features and the Visual Embed SDK.

To enable ThoughtSpot Everywhere on your cluster, contact ThoughtSpot Support.

For new features and enhancements introduced in this release for ThoughtSpot Everywhere, see ThoughtSpot Developer Documentation.