9.0.1.sw Release Notes

ThoughtSpot version 9.0.1.sw is now available.

These release notes include information about new and enhanced features.

To see our feature deprecation plans, please see Deprecation announcements.

For a complete list of issues that we fixed in this release, see Fixed issues.

9.0.1.sw New Features and Functionality

Early Access

In this release, we introduce Early Access features. Administrators can selectively enable or disable Early Access features for all users. For more about Early Access features, see ThoughtSpot Software release life cycle.

For best performance loading Liveboards, we recommend that you have no more than 40 visualizations in a single tab of a Liveboard.

For the Analyst

Show measures in pivot table rows

By default, ThoughtSpot displays measures in columns in pivot tables. With this release, choose whether to display measures in rows or columns in your pivot tables. For more information, see Reorder your pivot table.

Delete joins and RLS rules through TML

When you edit and import table TML files, ThoughtSpot now supports deletion of joins at the table level and RLS rules. Refer to ThoughtSpot Modeling Language.

Export FQNs when exporting TML files

To reduce ambiguity when exporting TML files, export the fully qualified names (FQNs) for the objects' data sources. If you select this option, the TML file contains FQNs for the underlying tables and connections.

For more information, see ThoughtSpot Modeling Language.

Visualization GUID support in TML files

Liveboard ThoughtSpot Modeling Language (TML) files now contain distinct GUIDs for each visualization in the Liveboard by default. This ensures that the GUID for the visualization stays the same after you import or export it. See the TML viz_guid parameter.

Upload custom geo maps Early Access

Upload your own custom maps and visualize data on geo charts with regions that are specific to you and your organization. This feature must be enabled by your administrator. For more information, see Upload custom geo maps.

Parameters Beta

Create Worksheet parameters to optimize your data inquiries. Use parameters to run different scenarios with adjustable values, without creating or modifying the constants in formulas for each new value. For more information, refer to Create parameters and Using parameters.

This feature is in beta and off by default. To enable it, contact ThoughtSpot Support.

Data labels on a dark background Early Access

Labels that appear on a dark background can be displayed in a lighter text color, making them easier to read. This feature must be enabled by your administrator. For more information about data labels on a dark background, see Show data labels.

Apply multiple changes at once Early Access

When a user drags and drops the fields in the chart configuration panel, the chart reloads. When a user has multiple fields, they need to rearrange a lot of them to reach a desired chart. Now users can make multiple configurations, and apply them all at once, rather than waiting in between each configuration. This feature must be enabled by your administrator. For more information, see Reorder labels on the axis or legend.

Group aggregate enhancements: filters Beta

Previously, when using group_aggregate formulas, users could use query_filters to include filters entered in the search bar in the formula’s value, but it was difficult to write a formula that accepted filters from only a single column. Starting with this release, you can specify column names within the ‘filters’ section of a group_aggregate formula, and any filter in your search bar referencing that column will be added to the formula. Filters entered in the search bar that are not on columns specified in the third argument of the group_aggregate formula will be ignored.

For example: Say that you search for group formula color= ‘blue’ ship mode != ‘car’, where group formula = group_aggregate (sum(Revenue), {ship mode}, {color, quantity}). In this case, the formula will adopt the color = blue filter but ignore the ship mode filter, evaluating to group_aggregate(sum(Revenue), {ship mode}, {color = ‘blue’}). For details, see Group aggregation filters.

For the Business User

Delete tables from ThoughtSpot

Previously, when deleting tables from Connections, ThoughtSpot did not delete the table’s metadata completely. Now, tables deleted through the ThoughtSpot UI disappear completely from your cluster.

Edit your display name

You can now edit your display name by clicking the profile icon in the upper-right corner of the screen. For more information, see Edit your display name.

Chinese (Traditional) or 中文 (繁體) localization

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. To try it out, navigate to your profile, and edit your system language. For more information, see 中文 (繁體) keyword reference and Change language and data format settings.

Delete or make a copy of objects from the details page

Delete or make a copy of Worksheets and Views from an object’s details page. To try it out, open any Worksheet or View, and select the more menu more menu icon image. For more information, see Edit or rename Worksheet and SQL based Views.

Rename Liveboards and visualizations without entering edit mode

Change the name or description of a Liveboard or visualization without entering Edit mode. The more more menu icon menu for Liveboards and Liveboard visualizations now includes a Rename option, where you can edit the object name and description. For more information, see Other Liveboard edits.

Improvements to French keywords

This release improves the translated French keywords. See Français (France) keyword reference.

Mandatory Liveboard filters Early Access

Mark certain filters in your Liveboard as mandatory. If you add mandatory filters to a Liveboard, the visualizations will only load after Liveboard viewers select values for the mandatory filters. Use mandatory filters for Liveboards that contain data that may not be relevant for everyone who must view and consume the Liveboard. Mandatory filters also lower query and performance costs. This feature must be enabled by your administrator. For more information, see Mandatory Liveboard filters.

For the Data Engineer

PostgreSQL connection

You can now create connections from ThoughtSpot to PostgreSQL. For details, see PostgreSQL.

dbt metadata tags for table and Worksheet column properties and joins

Manage your ThoughtSpot table and Worksheet column properties and table joins in dbt by using metadata tags to define column properties and joins within your dbt model schema. dbt stays the source of truth, and you don’t have to manually update the columns in ThoughtSpot when you make changes to your dbt model. For more information, see Metadata tags for dbt.

Sharing connections

You can now share connections with other users or groups. Once granted access to a connection, users can add, remove, and modify tables in that connection. For more information, see Share a connection.

Tag enhancements

This release includes the following updates to the tags feature in the Data workspace:

  • Add tags to multiple objects at a time

  • Administrators can create new tags from the Edit tags modal

For more information, see Apply a tag and Create a tag.

For the IT Ops Engineer

Python 3.9 upgrade

Python 3.9 is now the default Python version for all ThoughtSpot Software clusters, regardless of deployment type. ThoughtSpot does not support any other Python release for clusters on ThoughtSpot release 9.0.0.sw and later.

Deploy ThoughtSpot on RHEL, OEL, or Amazon Linux 2 using your LDAP or AD service account

When deploying ThoughtSpot on RHEL, OEL, or Amazon Linux 2, you can use your LDAP or Active Directory service account for installation, instead of using a local user. See customer-os-ansible-configure.adoc#remote_user_management.

For the Developer

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

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

For information about ThoughtSpot Everywhere, refer to ThoughtSpot Everywhere Documentation.

Supported Upgrade Paths

If you are running one of the following versions, you can upgrade to the 9.0.1.sw release directly:

  • 8.4.x to 9.0.1.sw

  • 8.8.x to 9.0.1.sw

This includes any hotfixes or customer patches on these branches.

If you are running a different version, you must do a multiple pass upgrade.

First, upgrade to version 8.4.x or 8.8.x, and then to the 9.0.1.sw release.

To successfully upgrade your ThoughtSpot cluster, all user profiles must include a valid email address. Without valid email addresses, the upgrade is blocked.

Was this page helpful?