6.2 Release Notes

ThoughtSpot version 6.2.1 is now available. These release notes include information about new and enhanced features.

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

6.2.1 New Features and Functionality

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

For the Analyst

The ‘not in’ keyword

The not in keyword phrase enables you to find the relative complement of two sets: results that satisfy the outer query that are not in the inner query. Contrast this with in, which returns results that are an intersection of the outer and inner query, or 'query within a query'.

For the IT Ops Engineer

Granular access to Pinboards

Starting with this release, you can control user’s permissions to create or update Pinboards, essentially limiting them to 'read only' access. These users can view and explore Pinboards. However, they cannot edit, copy, download, or share Pinboards and Answers.

This must be enabled on the cluster.

Style customization

You can now customize the ThoughtSpot application from the Admin Console. With style customization, you can change the fonts, chart color palettes, footer text, application logo, and background colors in your embedded ThoughtSpot instance.

6.2 New Features and Functionality

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

For the Analyst

Geo maps

ThoughtSpot now supports Geo Map visualizations for these new locales:

  • India: State, District, Postcode

  • Portugal: District, Municipality, Postcode

  • Italy: Improved regional name support

    Geo maps overview

Table configuration

This release introduces a more intuitive way to configure your tables, including these new features:

High cardinality

In this release, ThoughtSpot supports charts and tables with a very large number of data values, and shows how much of the data your chart or table displays.

  • Your search in table form can now have more than 1000 rows.

  • Your charts now come with a horizontal scroll bar, to support up to 35,000 data points.

  • You can have up to 250 distinct legend items on a chart.

    High cardinality overview

New search keywords and changed behavior
  • The nested ‘top’ keyword
    The new keyword phrase, top n measure1 by attribute | measure2, enables you to search the top n results by an attribute or a secondary measure.

  • Change in behavior for the ‘in’ keyword

    The in keyword returns results that are an intersection of the outer and inner query, or 'query within a query'. Starting in 6.2, searches with the in keyword do not include {null} values. To include these {null} values, create a formula for the relevant attribute in your search, to convert {null} values to 'unknown,' or some similar word.

    Search keywords overview

Monitor Beta
  • Subscribe others: To drive adoption of Pinboards, analysts can now subscribe business users to receive daily email notification for the relevant metrics. See Subscribe others.

  • UI enhancements: We made several improvements to the Monitor and Follow features, optimizing the workflow.

  • Insights: Insights no longer appear on Home page and Pinboard by default, unless that feature is turned on for the cluster. See Finding your way around, Insights.


This release introduces expanded support for exporting and importing ThoughtSpot objects. You can now export and import the following scriptable objects:

Aggregate formulas as Worksheet filters

You can now use an aggregate formula as a Worksheet filter. See Use aggregate formulas as Worksheet filters.

Formula Parser Improvements

ThoughtSpot 6.2 includes improvements to the latency of the formula parser. Complex formulas that took over 45 seconds to parse are now parsed in 150 milliseconds — a 300x improvement. Latency no longer increases exponentially with the depth of the formula nesting, no matter how complex the formula is.

For the Business User

Growth: Sharing

Updates to sharing in 6.2 make the feature more intuitive, and remove moments of friction that can occur when sharing, or trying to access objects for which you have limited permissions.

Answer Explorer v2

Updates to Answer Explorer in 6.2 introduce a cleaner user interface and allow users to add their own filters, comparisons, measures, and attributes to a visualization while in Explore mode. See Answer Explorer for more information.

Answer Explorer overview

Mobile for Android

In time for this release, you can download ThoughtSpot app for Android OS from the PlayStore. See ThoughtSpot Mobile release notes and ThoughtSpot Mobile overview.

For the Data Engineer


DataFlow is a new graphical, code-free, analyst-friendly approach for easily loading data into ThoughtSpot’s in-memory engine.

DataFlow overview


In this release, Embrace supports two new data warehouses and includes new features.

New data warehouses:

  • Teradata

    Teradata Vantage version 16.20 or later is required.

    For more information, see Teradata overview.

  • SAP HANA Beta

    SAP HANA version 2.0 or later is required.

    This feature is disabled by default. To enable it, contact ThoughtSpot Support.

    For more information, see SAP HANA overview.

New features:

  • Ability to remove columns from a connection.

  • Actual SQL is displayed in the query visualizer. This allows analysts to check the actual external database query so they can easily validate the output.

  • A summary of connected tables/columns is displayed in the add/edit connection workflow.

  • Improved performance when creating or editing a connection.

tsload connector

This release introduces a new option for loading data in bulk, called tsload connector. It is a collection of APIs that allow you to directly, and more quickly load your data into the ThoughtSpot Falcon database. For more information, see Use the tsload connector to load data.

For the IT Ops Engineer

Amazon Linux 2 Deployment

This release of ThoughtSpot introduces deployment support for Amazon Linux 2. This decouples the OS and application files we shipped together in previous releases, and gives you the flexibility to run ThoughtSpot on an Amazon Linux 2 image that your organization manages internally. ThoughtSpot certifies Amazon Linux 2 on the AWS platform. To deploy ThoughtSpot on Amazon Linux 2, you must have the Ansible tarball; you can obtain the tarball through your ThoughtSpot contact. For more information, see the Amazon Linux 2 Deployment Overview.

Admin Console

This release of ThoughtSpot introduces the Admin Console, providing you with an intuitive, user-friendly interface to accomplish most of the necessary tasks for administering ThoughtSpot. You can accomplish the following tasks from the Admin Console:

In-memory data compression

ThoughtSpot release 6.2 includes improvements to in-memory data compression. These improvements lower your RAM requirements and reduce the number of VMs you need for in-memory data, when deploying on a cloud platform. In release 6.2, ThoughtSpot added two new compression algorithms to the Dictionary compression that ThoughtSpot already supports. ThoughtSpot now supports LZ4, for INT, BIGINT, DOUBLE, and FLOAT data types, and RLE, for strings. See In-memory data compression for more information.

Falcon monitoring Pinboards

In ThoughtSpot release 6.2, there are 4 new Pinboards, based on Falcon metrics, that are available to system administrators. Use the Falcon monitoring system Pinboards for an overview of Falcon, ThoughtSpot’s in-memory database, and its health, based on query, data load, and varz metrics. You can use these Pinboards for proactive monitoring, or, with help from ThoughtSpot Support, for debugging. See Falcon monitoring Pinboards for more information.

In-app acceptance of ThoughtSpot’s use agreement

You can now sign ThoughtSpot’s end-user use agreement from the application itself. Even if you previously signed a paper copy of the use agreement, an admin must sign the agreement in the application, within 30 days of your upgrade to release 6.2. See ThoughtSpot use agreement for more information.

Beta Programs

If you are interested in seeing some of our newest features, we want to add you to our testing group. ThoughtSpot is looking for people with all levels of experience: end-users, analysts, administrators, configurators, and so on. We like to have a diversity of experience and perspective, and want to hear from you. Because we strive for excellence, we will partner with you to adjust the final details of our offerings based on your feedback.


Please contact us if you are interested in participating in the Monitor Beta Program, for monitoring selected metrics over time.


Please contact us if you are interested in participating in the Scriptability Beta Program, for migrating and updating Answers and Pinboards in a flat-file format.

Supported Upgrade Paths

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

  • 6.0.x to 6.2.1

  • 6.1.x to 6.2.1

  • 6.2 to 6.2.1

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 6.0.x, 6.1.x, or 6.2, and then to the 6.2.1 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?