7.1 Release Notes

ThoughtSpot version 7.1.1 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.

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

For the Analyst

TML for tables with row-level security

ThoughtSpot now supports the migration and editing of tables with row level security (RLS) using TML.

Pinboard schedule gating conditions

Gating conditions for scheduled pinboards are now GA. Refer to Schedule a pinboard job to learn more about scheduling pinboards for email delivery, and how to leverage gating conditions so that ThoughtSpot only sends the pinboards when certain conditions are true.

For the Business User

New answer experience Beta

This release redesigns the experience of creating and working with answers. The new answer experience contains multiple new features and feature enhancements. It is in Beta and off by default, but the option to turn it on or off individually is on by default. You can toggle it on or off individually from the Experience manager in your profile, or for the whole company by contacting ThoughtSpot Support.

The new answer experience contains the following features and enhancements:

  • Improved formula editor: The new formula editor has a larger editor window, allows new lines, and has a new layout with integrated help.

  • Filter improvements: Cleaner, more intuitive UI for the filter value selection modal.

  • Table column summaries: Conditional and number formatting for table column summaries is now available. Column summaries are aligned with their respective columns and are part of the table, although you can configure their number and conditional formatting separately.

  • Table column summary configuration for admins: You can now enable or disable column summaries for users on the new answer experience, from the Search & SpotIQ section of the admin console. By default, table column summaries are on.

  • Table configuration: Conditional formatting for attributes is now available for tables. Conditional formatting is now part of the Table configuration panel instead of being a separate modal. You can now set the content density, which allows you to see more table rows at once, and table theme (outline, row, or zebra) of your table, from the Table configuration > Settings menu.

  • Chart configuration: Conditional formatting for chart measures is now part of the Chart configuration panel instead of being a separate modal.

  • Scatter and bubble chart enhancements: You can now specify a minimum and maximum value for measures on the x-axis of scatter and bubble charts. For more information on how to add a minimum and maximum value to a chart axis, refer to Edit the axis.

  • Conditional formatting for pivot tables: You can now perform conditional formatting on measures in pivot tables.

  • SpotIQ analyze: Cleaner, more intuitive UI for SpotIQ analyze of Answer data points, surfacing the most useful workflows and allowing advanced customization.

The following features are not available with the new answer experience. The new answer experience is in Beta and off by default, but the option to turn it on or off individually is on by default. If it is on by default in your environment, and you would like your company to be able to use these de-supported features, you can turn the new answer experience off for your company by contacting ThoughtSpot Support. Alternatively, you can turn it on or off individually from your profile.

  • Multiple join path resolution within the formula editor or a search: when you try to search on columns with more than one possible join path, the system no longer allows you to define the join path within the search. Similarly, when you try to create a formula with columns with more than one possible join path, the system does not allow you to define the join path. Instead, the system now prompts you to resolve this issue and avoid confusion or incorrect data by creating a Worksheet with the correct join path.

  • Send feedback: The option to send product feedback, from the more options menu more options menu icon on an Answer or search.

  • Client-side summaries for tables: We consolidated column summaries and headlines into one summary, called a headline summary. To calculate these headline summaries, ThoughtSpot executes a query against the underlying database. If you are connecting to your data in an external database, ThoughtSpot executes one query for each summary. If you store your data in ThoughtSpot’s in-memory database, ThoughtSpot executes one query for all summaries in the search. These headline summaries are integrated with the table columns. You can pin them to Pinboards.

  • R integration: R integration is not available in the new answer experience at this time. We plan to add support for R in the new answer experience in a future release.

    ThoughtSpot continues to support R for all customers who currently include R charts in their solutions on the ThoughtSpot Software deployments; please continue to use the classic Answer experience.

    We support R only in Falcon deployments (data imported into ThoughtSpot), and R integration is disabled by default. It is not available when creating connections and linking to external databases in real time.

    Refer to New answer experience for more information on the behavior of these features.

For the Data Engineer

Custom calendar

Custom calendar is now available for Snowflake, Amazon Redshift, Google BigQuery, Microsoft Azure Synapse, and Databricks cloud data warehouses. See Custom calendar. This feature is disabled by default. To enable it, contact ThoughtSpot Support.

AWS Secrets Manager for Redshift connection passwords

Amazon Redshift connections now support AWS Secrets Manager for clusters deployed on an AWS EC2 instance. With this feature enabled, you no longer need to enter a password when you create a new Redshift connection. For details, see Amazon Secrets Manager. This feature is disabled by default. To enable it, contact ThoughtSpot Support.

For the IT Ops Engineer

Multiple Identity Providers for SAML login

You can now configure SAML SSO login for more than one Identity Provider (IDP). You may have multiple groups of users who need to log into ThoughtSpot but are managed by separate IDPs. To configure this, refer to Configure SAML using tscli.

Note that multiple IdP configuration is only possible through tscli, and not the Admin Console.

For the Developer

ThoughtSpot Software deployments now support ThoughtSpot Everywhere, which provides a low-code embedded analytics platform for developers and product owners. ThoughtSpot Everywhere users can now use the Visual Embed SDK to embed ThoughtSpot Search, pinboards, visualizations, and even the entire ThoughtSpot experience in their application, product, or web page.

This release also introduces the Developer portal for application developers and ThoughtSpot Everywhere users. The portal provides a Playground for developer users to explore the SDK APIs and embedding workflows. The portal also offers several features, such as style customization and custom actions, to customize and enhance the embedded content. To know more about ThoughtSpot Everywhere and learn how to embed ThoughtSpot content using Visual Embed SDK and REST APIs, go to Develop > Guides, or refer to the ThoughtSpot Everywhere documentation.

7.1.0.CU1 New Features and Functionality

VMware 6.7 certification

ThoughtSpot now certifies VMware version 6.7 on ThoughtSpot versions 7.1.0.CU1 and later. For more information on deploying ThoughtSpot with VMware, refer to VMware configuration overview.

7.1 New Features and Functionality

Self-service upgrade is not supported for upgrade to version 7.1.

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.

Security log collection

This release of ThoughtSpot Cloud enables your security team to collect security audit events based on user activity and ship them to your SIEM application in real-time. You can view logs for the following events:

  • Account logout

  • Answer creation

  • Answer deletion

  • Answer update

  • Failed login

  • Group creation

  • Group deletion

  • Group modification

  • Group principals update

  • Locked account

  • Object sharing

  • Password update

  • Pinboard creation

  • Pinboard deletion

  • Pinboard update

  • Privilege changes

  • Profile change

  • Row level security (RLS) rule creation

  • RLS rule deletion

  • RLS rule modification

  • Successful login

  • Table creation

  • User account creation

  • User account deletion

  • User group change

For further details, see Collect security logs.

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.1 release directly:

  • 6.3.x to 7.1.1

  • 7.0.x to 7.1.1

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