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 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.
See Granular access to Pinboards, and Cannot create or update Pinboards privilege.
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.

Refer to Style customization.

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

Geomaps
ThoughtSpot now supports GeoMap visualizations for these new locales:
  • India: State, District, Postcode
  • Portugal: District, Municipality, Postcode
  • Italy: Improved regional name support
Geomaps overview
 
Table configuration
This release introduces a more intuitive way to configure your tables, including these new features:
  • Drag and drop chips allow you to easily rearrange the order of the columns in your table
  • Clip or wrap text for the entire table from the Edit table: Settings menu, or by column from the column's more options menu
  • Number formatting for any table column based on a measure, allowing you to change the category (number, percentage, or currency), units (auto, none, thousand, million, billion, or trillion), or method of writing negative values (-1234, 1234-, or (1234))
  • Enable or disable the table footer from the Edit table: Settings menu
  • Enable or disable column summaries from the Edit table: Settings menu
Table configuration overview
 

For more information, see Results that are tables.
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
 

See Charts and tables with a very large number of data values.
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.
  • The ‘not in’ keyword
    Another keyword phrase, not in, 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 that returns results that are an intersection of the outer and inner query, or 'query within a query'.
  • 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.
Scriptability
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
DataFlow is a new graphical, code-free, analyst-friendly approach for easily loading data into ThoughtSpot’s in-memory engine.
In this release, DataFlow supports a large number of databases (Amazon Aurora, Amazon Redshift), Azure Synapse, Cassandra, Google BigQuery, Hive, IBM Db2, MariaDB, MongoDB, MySQL, Netezza, Oracle, PostgreSQL, Presto, SAP Adaptive Server Enterprise, SAP HANA, SAP SQL Anywhere, SQL Server, Snowflake, Splice Machine, and Teradata), file systems (Amazon S3, Azure Blob Storage, Flat Files, Google Cloud Storage, HDFS), and one application, Salesforce.
DataFlow overview
 
Embrace
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. 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:
Admin Console overview
 
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.

Monitor

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

Scriptability

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.