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

What’s new in ThoughtSpot Cloud

October 2022 8.8.0.cl

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

Schedule ThoughtSpot Sync Beta

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. For more information, see ThoughtSpot Sync.

Schedule sync

Custom sizes for visualizations in Liveboards Beta

This release introduces custom tile sizes for visualizations within Liveboards. In addition to the 5 predetermined visualization sizes, you can now customize your Liveboard visualizations to be any size. For more information, see Edit the layout of a Liveboard.

liveboard tile sizes gif

Explain change for KPI charts Beta

You can now use SpotIQ analysis to directly identify the key drivers for recent change in your KPIs. KPI change analysis allows you to drill down into the causes of change in your KPIs and customize the insights generated by SpotIQ.

For more information on change analysis, see Comparative analysis.

kpi explain change

Formula function search bar

The formula editor assistant now contains a search bar for formula functions. Use it to search for specific functions to include in your formula. For more information, see Add a formula to a search.

Formula assistant search

Apply tags in home page

You can now apply and edit tags on Liveboards and answers directly from the Home page, as well as from the Answers and Liveboards tabs. To try it out, select the checkbox next to the name(s) of the answer(s) or Liveboard(s) you would like to tag. For more information, see Home page.

apply tags

Show underlying data improvements

We have made the following improvements to the Show underlying data feature:

  • When you right-click a table and select Show underlying data, ThoughtSpot displays only the columns visualized in your query.

  • You can now open the Show underlying data pop-up and click Edit columns to add or remove columns from your query.

  • When you open the Edit columns pop-up, you can now search for column names using the search bar.

  • The Show underlying data pop-up no longer disables columns by default. To disable columns from your query, click Edit columns and deselect the column name(s).

show underlying

year_name function

The new year_name formula function returns the year in string format for a given date. This improves the behavior of formulas involving years when using a custom calendar with year values that are not in integer format. For more information, see the Formula function reference.

Headline summaries for discontinuous group aggregate formulas

We changed the default behavior for table aggregation summaries when the search contains a formulas that contain both a conditional clause (if…​ then…​ else) and a group_aggregate expression. When a user searches with a formula containing both a conditional clause and a group_aggregate expression, then ThoughtSpot detects the aggregation type on the first non-constant output clause and uses it in the headline summary. In this context, a non-constant output clause means any base column reference (for example, Revenue), or formula (for example, sum(revenue)).

For example, in the formula group_aggregate(sum(if (Color = 'blue') then 0 else group_unique_count(Discount))), the headline summary would use COUNT_DISTINCT, since the first non-constant output clause within the if…​ then…​ else clause is group_unique_count and has an aggregation type of COUNT_DISTINCT.

For more information, see Table aggregate summary.

Improvements to German keywords

This release improves the translated German keywords. For more information, see Deutsch keyword reference.


Other features and enhancements

Starburst OAuth with Azure AD

Starburst connections now support Azure AD OAuth. For details, see Azure AD OAuth for Starburst.

New connections

  • Presto is a new connection type. see Presto.

  • Trino is a new connection type. see Trino.

Delete joins that have dependents

You can now delete a join from the ThoughtSpot UI even if the join has dependents. This allows you to delete a join and create it again in the other direction, without invalidating or deleting any dependent objects. For more information, see Delete a relationship.

Join deletion gif

SpotApps

The following SpotApps are now available:

  • Facebook Ads: Use this SpotApp to measure ad performance across platforms to grow reach, engagement, & sales. For more information, see Facebook Ads.

  • Salesforce Pipeline Analysis: Use this SpotApp to track how prospects progress closer to closed deals. For more information, see Salesforce Pipeline Analysis.

Integration with dbt for Amazon Redshift and Google BigQuery

This release supports integration with dbt for the following 2 new cloud data warehouses:

  • Amazon Redshift

  • Google BigQuery

For more information, see dbt integration.

IPSec VPN support for cloud data warehouse connections

ThoughtSpot now supports secure access from ThoughtSpot Cloud to your data in ThoughtSpot’s supported cloud data warehouses, through your IPSec VPN server. For more information, see Configure IPSec VPN for your cloud data warehouse connection.

Storage of session-based consumption in Snowflake

ThoughtSpot now securely stores your consumption data in a searchable Snowflake data store. For more information, see Consumption data storage.

ThoughtSpot Everywhere

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