7.0 Release Notes
ThoughtSpot version 7.0.1 CU1 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.
|Self-service upgrade is not supported for upgrade to version 7.0.1 CU1.|
For a complete list of issues that we fixed in this release, see Fixed issues.
Here are the most significant new features and improvements in the 7.0.1 Software Release:
- Search Assist Coach
Search Assist Coach enables Analysts, or anyone who has edit access to a Worksheet, to create Search Assist sample queries based on their company’s data. This gives all users the opportunity to experience onboarding and training on data that is relevant to their work, and specific to their line of business.
- Search Assist
Search Assist introduces new users to ThoughtSpot’s Search experience by walking them through simple search scenarios on your company’s data. It demonstrates how anyone can get answers to their data questions by typing in the Search bar. Worksheet owners can use Search Assist Coach to create these sample search queries on your company’s data.
- Search on enter experience
The default search experience is now Search on enter. This means that you can add new tokens to the search bar, or remove them, without altering your existing search, until you press the Enter key on your keyboard, or select Go to the right of the search bar.
You may need to press Enter or Go to ensure that ThoughtSpot updates your search with any new items in the search bar.
Embrace now supports Databricks Beta. Because this feature is in Beta, it is disabled by default. To enable Databricks, contact ThoughtSpot Support.
- SAML configuration
When configuring SAML authentication for ThoughtSpot, it is now mandatory to map the
Here are the most significant new features and improvements in the 7.0.0 Software Release:
- Scriptability enhancements
There are several enhancements to the Scriptability feature:
- Export custom SpotApps
You can now export your own custom SpotApps, or collections of Scriptable ThoughtSpot Answers, Pinboards, SpotIQ results, Views, tables, and Worksheets, packaged together as a zip file. Simply navigate to Data > SpotApps and choose the objects you would like to include in a custom SpotApp. Refer to SpotApps.
- Add tables and columns to an Embrace connection
ThoughtSpot now allows you to use TML to edit tables created through Embrace, and add columns and tables that already exist in the external database to the connection. Refer to ThoughtSpot Modeling Language and specify the connection information when adding tables or table columns to an Embrace connection.
- GUID handling
ThoughtSpot now recognizes pre-existing GUIDs on import, and asks if you would like to update the existing object or create a new one. Refer to Scriptability.
- Improvements to generic join functionality Beta
The expanded functionality for generic joins in TML files allows the following elements:
- Comparison operators:
<=(less than or equal), and
>=(greater than or equal)
- Boolean operators:;
This feature is on by default.
- Joins at the table level
You can now create and edit joins at the table level using TML, including range and generic joins. You must edit these joins from the source table, not the destination table. Refer to ThoughtSpot Modeling Language
- Support for selective and linked filters
- Join creation interface
We improved the join workflows to support adding and updating joins on tables, worksheets, and views. See Join a worksheet to another data source and Join a table, View, or Worksheet to another data source.
- Show underlying data for chasm traps
ThoughtSpot supports showing underlying data for searches based on schemas with chasm traps by default. If you do not want to show underlying data for schemas with chasm traps, contact ThoughtSpot Support.
- Geo map support
We added support for states and state abbreviations, and also postal codes, for Mexico. See Geo Map reference.
- Passthrough functions
Embrace passthrough functions are available for all Embrace connections. Passthrough functions allow you to send custom SQL expressions directly to your cloud data warehouse without being interpreted by ThoughtSpot. For more information, see Passthrough functions for Embrace and Passthrough function reference.
- SAP HANA Update
Support for SAP HANA in Embrace is now GA. For more information, see SAP HANA.
- Security passthrough Beta
Embrace now supports security passthrough for Google BigQuery connections, using OAuth for authentication and authorization. This feature is disabled by default. To enable it, contact ThoughtSpot Support.
- Oracle Autonomous Database New
Support for Oracle Autonomous Database (ADW) is now GA. For more information, see Oracle Autonomous Data Warehouse.
- Exadata database New
- Greenplum database New
- Memsql database New
- Splunk file system New
- Remote files Update
When connecting to remote files, DataFlow now supports the ORC and JSON file formats. See Flat file connections in DataFlow.
Connections for remote files support several new file formats; in addition to Delimited, we have support for Parquet, JSON New, LDJSON Beta, and ORC New.
DataFlow includes support for utilities to configure SSL, so you can securely connect to the following source systems: SQLServer, Databricks Data Lake, PostgreSQL,IBM Db2, Greenplum, Oracle, and Teradata.
- Home page
The DataFlow Home dashboard now shows both the historical and upcoming syncing information. It also supports search by table name. See DataFlow home.
- Custom SQL
All DataFlow database connections (as listed in DataFlow for database sources) support retrieving data through a custom SQL expression.
The new DataFlow Tips section explains how to:
- Truncate a table
Truncates the tables during syncs, instead of deleting.
- Epoch date and timestamp options
Use epoch format in pre- and post-sync TQL scripts (
CurrentDateEpochAdd` and `CurrentTimestampEpochAddparameters).
- Track the last sync start time
$$LastSyncStartTimeparameter in custom formulas.
- Oracle Enterprise Linux (OEL) support
This release of ThoughtSpot introduces deployment support for Oracle Enterprise Linux. This decouples the OS and application files we shipped together in previous releases, and gives you the flexibility to run ThoughtSpot on an OEL image that your organization manages internally.
ThoughtSpot certifies OEL version 7.9 on AWS, GCP, and VMware. To deploy ThoughtSpot on OEL, you must have the Ansible tarball; you can obtain the tarball through your ThoughtSpot contact. For more information, see the RHEL and OEL Deployment guide.
- New security logs
This release of ThoughtSpot enables your security team to collect security audit events based on user activity. You can view logs for the following events: Successful login, Failed login, Locked account, Profile change, Group creation, Group deletion, User group change, Group modification, Privilege change, User account creation, User account deletion, Password change, Object creation (Pinboard or Answer), Object deletion (Pinboard or Answer), Object modification (Pinboard or Answer), and Object sharing.
To view these logs, run the tscli logs collect command.
- New cloud VM instance types
- AWS New
The new AWS instance types are
- Azure New
The new Azure instance type is
- Azure Disk Encryption
ThoughtSpot now supports Azure Disk Encryption (ADE) for clusters running on an RHEL image in Azure. Azure Disk Encryption provides volume encryption for both the OS and data disks of Azure virtual machines (VMs).
To configure Azure Disk Encryption for your cluster(s), contact ThoughtSpot Support.
If you are running one of the following versions, you can upgrade to the 7.0.1 CU1 release directly:
6.2.x to 7.0.1 CU1
6.3.x to 7.0.1 CU1
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.2.x, or 6.3.x, and then to the 7.0.1 CU1 release.
|To successfully upgrade your ThoughtSpot cluster, all user profiles must include a valid email address. Without valid email addresses, the upgrade is blocked.|