ThoughtSpot version 6.2 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 New Features and Functionality
For a complete list of issues that we fixed in this release, see 6.2 Fixed issues.
For the Analyst
- 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
- New search keywords
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'.
- The nested ‘top’ keyword
- 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 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.
- Share a specific visualization within a Pinboard so that the email link opens up to that visualization in Explore mode
- Copy a direct link to the Pinboard, Answer, or visualization within a Pinboard that you are sharing, so you can separately send that link to users after you share the object with them
- Request access within a Pinboard or Answer if you need edit or underlying data access to the Pinboard or Answer
- Share underlying data access within the sharing modal if the user does not have data access
- 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.
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
- In this release, Embrace supports two new data warehouses and includes new features.
New data warehouses:
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.
- 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 Portal
- This release of ThoughtSpot introduces the Administration Portal, 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 Administration Portal:
- Manage ThoughtSpot users
- Manage ThoughtSpot groups
- Manage local authentication
- Configure SAML authentication
- Configure LDAP authentication through Active Directory
- Configure SSL
- Configure a reverse SSH tunnel for Support
- Set the relay host for SMTP (email)
- Customize ThoughtSpot help
- Customize Answer actions menu
- View System Overview Pinboard
- View System Cluster Pinboard
- View System Alerts Pinboard
- Monitor available cluster updates
- Admin Portal 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
FLOATdata 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.
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 release directly:
- 6.0.x to 6.2
- 6.1.x to 6.2
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 5.3.x, or version 6.0.x, and then to the 6.2 release.