7.1 Release Notes

ThoughtSpot version 7.1 is now available as a limited availability release.

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.1.

7.1 New Features and Functionality

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.1 Software Release:

All documentation for software embedding is now available only on the ThoughtSpot Everywhere documentation site.

For the Analyst

Query filters

Aggregate formulas now support in-line query filters. See Query filters.

For the Business User


ThoughtSpot is dropping support for the following feature in the 7.1 release. This feature is not available in the 7.1 release:

For the Data Engineer


ThoughtSpot has renamed Embrace to Connections. To access your connections, navigate to the Data tab and click Connections. For more information, see Connections.


Connections now supports Databricks. For more information, see Databricks connections.


Connections now supports Starburst. For more information, see Starburst connections.


We added support for the following databases: Dremio, Google Sheets, and Vertica.

DataFlow now automatically selects the options based on source file format, but you can overwrite it. For details, see Files. When connecting to remote files, DataFlow now supports the XML and Avro file formats.

DataFlow Single Sign-On

DataFlow now supports Single Sign-On (SSO). You can configure the Single Sign-On settings based on the SSO service used in your organization. Once configured, the user login authentication in ThoughtSpot and ThoughtSpot DataFlow is routed through the SSO service, and you do not need to maintain separate user credentials for ThoughtSpot DataFlow. See Manage DataFlow users with SSO for details.

Case-sensitive table names

DataFlow now supports case-sensitive table names. You can now create multiple syncs using different tables with the same name from the same connection and the same database.

Sync mode advanced settings

For all DataFlow connections, the Sync mode available in the Sync properties tab now defaults to Append.

Salesforce drivers

In this release, the Salesforce cdata JDBC jar in agent/lib/jars/salesforce/xx/jdbc/cdata.jdbc.salesforce.jar upgraded with the latest drivers.

Cassandra drivers

The Cassandra JDBC jar in agent/lib/jars/cassandra/3.x Jar: cdata.jdbc.cassandra.jar location upgraded with the latest drivers.

Truncate table

We removed this functionality because it is no longer necessary.

User management

We removed user management from DataFlow; this function is now integrated with ThoughtSpot user management.

For the IT Ops Engineer

Manage advanced search and SpotIQ settings

You can now manage advanced search and SpotIQ settings from the Admin Console. You can configure column indexing and enable or disable SpotIQ Analyze and column summaries. Refer to Manage search and SpotIQ settings.

Manage email and onboarding settings

You can manage certain advanced settings for your organization from the Admin Console. You can customize welcome emails, scheduled emails, and the workflow that allows users to sign up for ThoughtSpot from the login page. Refer to Manage email and onboarding settings.

New admin privileges Beta

This release introduces new administrator privileges that separate the abilities of the administrator into 4 specific privileges. For example, you can allow certain users to create and manage users, while not allowing them to manage SAML integration or other advanced settings. These new administrator privileges do not provide access to all data in ThoughtSpot, unlike the Can administer ThoughtSpot privilege. Users with the new privileges can only see data that others share with them. The Can administer ThoughtSpot privilege, which encompasses all 4 new administrator privileges, still appears as an option by default. To remove it, contact ThoughtSpot Support. The 4 new privileges are:

  • Can manage users: Can create, delete, and edit users.

  • Can manage privileges: Can create, delete, and edit groups. This includes the group’s name, sharing visibility, and privileges.

  • Can operate application: Can configure local and SAML authentication. Can manage application settings: search, SpotIQ, and onboarding advanced settings, style and help customization. Can view scheduled maintenance.

  • Can see system information: Can view all default admin data, including system worksheets and pinboards.

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

RHEL ease of installation

You can now configure a specific admin username for the user who sets up the nodes when deploying on RHEL. Previously, you had to use the default admin username, the 1081 uid, and the 1081 gid.

SAML configuration

When configuring SAML authentication for ThoughtSpot, you can now optionally map the display name subject value in the IDP metadata file to displayName. This ensures that your users' display names in SAML match their display names in ThoughtSpot. For more information, refer to Configure SAML.

UI improvement for Admin Console

This release improves the UI and user experience of the NAS mount, Reverse SSH tunnel, SMTP, Snapshot, Upgrade, Scheduled maintenance, and SSL sections of the Admin Console.

Product Usage worksheet

This release introduces a new default worksheet for monitoring product usage. The Product Usage worksheet contains data on the following topics:

  • Specifies what existing worksheets, tables, and views users search on and create objects from, and what those objects are

  • Lists what actions users complete in the product

  • Lists the underlying data sources for any object

  • Lists any object’s dependents

You can search on this worksheet, or create pinboards based on it, to monitor your users' interaction with the product. To access this worksheet, search for Product Usage worksheet from the Data tab, or add it as a source while searching data.

This worksheet is the underlying source for the Object Usage pinboard.

Supported Upgrade Paths

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

  • 6.3.x to 7.1

  • 7.0.x to 7.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.3.x, or 7.0.x, and then to the 7.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.