ThoughtSpot Cloud Documentation

ThoughtSpot Cloud™ is our hosted and managed service offering. ThoughtSpot Cloud offers multiple advantages over deployment form factors that you have to manage and maintain within your own organization.

Find topics for the common types of ThoughtSpot users.

What’s new in ThoughtSpot Cloud

January 2023 8.10.0.cl

Features marked as Beta are off by default. To enable them, contact ThoughtSpot Support.

Schedule ThoughtSpot Sync

ThoughtSpot Sync schedules are now GA and on by default. When creating a sync from ThoughtSpot to an external business app (Google Sheets, Microsoft Teams, Slack), you can now schedule the sync to repeat on an hourly, daily, weekly, or monthly basis. To try it out, create a sync and select Schedule your sync.

Schedule sync

ThoughtSpot Sync Salesforce connection

ThoughtSpot Sync for Salesforce is now GA and on by default. You can now sync data directly from an Answer or custom SQL view to Salesforce. Using ThoughtSpot Sync, you can push insights directly to Salesforce, notify your teams, and view data in context. ThoughtSpot Sync automatically establishes a secure pipeline to the destination app and thus eliminates the need for building custom connectors.

Select app to sync pop-up

Other features and enhancements

Multi-tenancy with Orgs

This release introduces ThoughtSpot’s multi-tenancy feature. Partition your ThoughtSpot Cloud instance into multiple completely separate environments called Orgs. Creating Orgs keeps user and object information in different Orgs completely isolated. For more information, see Multi-tenancy with Orgs.

Admins can manage all Monitor alerts

Admins can view, edit or delete Monitor alerts even if they are not the creator or subscriber of those alerts. For more information, see permissions.

SpotApps

The DEI Workforce Diversity SpotApp is now available. Use this SpotApp to get invaluable insight into your workforce diversity data from your HR application. For more information, see DEI Workforce Diversity SpotApp.

DEI Workforce Diversity SpotApp Liveboard

ThoughtSpot now supports multiple AWS PrivateLinks in your environment. If you have data in multiple cloud data warehouses that need an additional layer of security and network reliability, you can set up an AWS PrivateLink between each CDW, for a maximum of five PrivateLinks. For more information, see Enabling an AWS PrivateLink between ThoughtSpot Cloud and your cloud data warehouse.

Delete tables from ThoughtSpot

Previously, when deleting tables from Connections, ThoughtSpot did not delete the table’s metadata completely. Starting in 8.10.0.cl, tables deleted through the ThoughtSpot UI disappear completely from your cluster.

ThoughtSpot Everywhere

For new features and enhancements introduced in this release of ThoughtSpot Everywhere, see ThoughtSpot Developer Documentation.







What’s coming in the next release

February 2023 9.0.0.cl

Features marked as Beta are off by default. To enable them, contact ThoughtSpot Support.

ThoughtSpot Sync

You can now use ThoughtSpot Sync to sync data directly from an Answer or custom SQL view to the following apps:

  • ServiceNow

  • HubSpot

sync hubspot

Parameters Beta

Create Worksheet parameters to optimize your data inquiries. Use parameters to run different scenarios with adjustable values, without creating or modifying the constants in formulas for each new value. For example, easily adjust the attribute in an Answer to view your revenue by commit date or order date, as in the following gif.

Parameter gif example

Mandatory Liveboard filters

Mark certain filters in your Liveboard as mandatory. If you add mandatory filters to a Liveboard, the visualizations will only load after Liveboard viewers select values for the mandatory filters. Use mandatory filters for Liveboards that contain data that may not be relevant for everyone who must view and consume the Liveboard. Mandatory filters also lower query and performance costs. This feature must be enabled by your administrator.

Creation of a mandatory filter and an image of a Liveboard with the mandatory filter

Show measures in pivot table rows

By default, ThoughtSpot displays measures in columns in pivot tables. With this release, choose whether to display measures in rows or columns in your pivot tables.

Pivot table with measures displayed in rows

Upload custom geo maps

Upload your own custom maps and visualize data on geo charts with regions that are specific to you and your organization. This feature must be enabled by your administrator.

Custom geo map being added

Data labels on a dark background

Labels that appear on a dark background can be displayed in a lighter text color, making them easier to read. This feature must be enabled by your administrator.

A chart with data labels that are clearly visible on a dark background

Chinese (Traditional) or 中文 (繁體) localization

Set your ThoughtSpot locale to Chinese (Traditional), or 中文 (繁體). ThoughtSpot changes your data format settings, such as currency and number formatting, and translates keywords, ThoughtSpot menu and navigation items, operators, and error messages. To try it out, navigate to your profile, and edit your system language.

ThoughtSpot application with the Chinese Traditional locale set

Rename Liveboards and visualizations in view mode

Change the name or description of a Liveboard or visualization from view mode. The more more menu icon menu for Liveboards and Liveboard visualizations now includes a Rename option, where you can edit the object name and description.

More menu for a Liveboard visualization

Apply multiple chart changes at once

When a user drags and drops the fields in the chart configuration panel, the chart reloads. When a user has multiple fields, they need to rearrange a lot of them to reach a desired chart. Now users can make multiple configurations, and apply them all at once, rather than waiting in between each configuration. This feature must be enabled by your administrator.

Group aggregation enhancements: filters Beta

Previously, when using group_aggregate formulas, users could use query_filters to include filters entered in the search bar in the formula’s value, but it was difficult to write a formula that accepted filters from only a single column.

Starting with this release, you can specify column names within the ‘filters’ section of a group_aggregate formula, and any filter in your search bar referencing that column will be added to the formula. Filters entered in the search bar that are not on columns specified in the third argument of the group_aggregate formula will be ignored.


Other features and enhancements

Snowflake CSV upload

Snowflake CSV upload is GA in this release. Now you have a quick and easy way to complete one-time data loads of small files that are not present in your cloud data warehouse. You can now upload a CSV file to the database of your Snowflake connection that can be joined to other tables or Worksheets in your connection. Once your administrator enables this feature, go to Data > Utilities, and click Upload CSV.

CSV upload

PostgreSQL connection

You can now create connections from ThoughtSpot to PostgreSQL.

Sharing connections

You can now share connections with other users or groups. Once granted access to a connection, users can add, remove, and modify tables in that connection. To try it out, go to Data > Connections and click the Share connection button.

share connection

dbt metadata tags for tables and Worksheets

Manage your ThoughtSpot table and Worksheet column properties and table joins in dbt by using metadata tags to define column properties and joins within your dbt model schema. Your dbt models contain all the necessary information, and you don’t have to manually update the columns in ThoughtSpot when you make changes to your dbt model.

Redshift Partner Connect and Free trial integration

Redshift Partner Connect allows you to try out ThoughtSpot connected to Redshift for free.

TML for Monitor alerts Beta

Export, edit, and import KPI Monitor alerts programmatically, using ThoughtSpot Modeling Language.

Include FQNs when exporting TML files

To reduce ambiguity when exporting TML files, you can export the fully qualified names (FQNs) for the objects' data sources. If you select this option, the TML file contains FQNs for the underlying tables and connections.

Choose what to export modal with the export fqn option highlighted

Delete joins and RLS rules through TML

When you edit and import table TML files, ThoughtSpot now supports deletion of joins at the table level and row-level security (RLS) rules.

Delete or make a copy of objects from the details page

Delete or make a copy of Worksheets and Views from an object’s details page. To try it out, open any Worksheet or View, and select the more menu more menu icon image.

Early Access features

Administrators can see the available Early Access features and selectively enable or disable them for all users by going to the Admin tab and selecting Early Access features. Early Access features are new in this release, and are disabled by default.

ThoughtSpot Everywhere

For new features and enhancements introduced in this release of ThoughtSpot Everywhere, see ThoughtSpot Developer Documentation.