Estimated reading time: 13 minutes

ThoughtSpot version 4.5.1 is now available.

For a complete list of issues that we fixed in recent releases, see Fixed issues.

Supported Upgrade Paths

If you are running the following version, you can upgrade to the 4.5.1.x release directly:

  • 4.4.1.3 to 4.5.1.x

If you are running 4.4.1.2 or earlier, you must do a multiple pass upgrade:

  1. Upgrade your cluster to 4.4.1.3.
  2. Upgrade from 4.4.1.3 to 4.5.1.x.

4.5.1 New Features and Functionality

These are the new and enhanced features in this release. For a complete list of issues that we fixed in this release, see 4.5.1 Fixed issues.

Added the ability to add custom Help links

When users click the help icon, they see a list of links. You can now add your own links to this list. This allows you to include documentation specific to your company, such as information about the data available in ThoughtSpot, where to get support internally, or company-specific training.

You can also edit existing links, change icons, or remove items from the help listing altogether.

Admin chart color palettes auto update based on primary colors

In the Admin Style Customization "Chart Color Palettes", secondary color gradients are now based off of the primary colors selected. When a different primary color is chosen, the associated secondary color gradients below it automatically update.

Custom color palettes are reflected in users chart color picker

Color palette changes made by the Admin in Style Customization, are now reflected in users' chart configuration color palettes (not just in the auto-generated chart colors, as in previous releases).

Admins can enable or disable auto color rotation in Style Customization Chart Color Palettes

When there is a single color on a chart (no legend), ThoughtSpot auto-rotates through primary colors to render the chart for visual variety. If an Admin does not want this behavior, they can disable it by choosing Disable Color Rotation on the "Chart Color Palettes", in which case ThoughtSpot will always use the default color on single-color charts.

Localized Date Format Supported in Search Filters

The search bar now accepts dates in the format used by the user browser's locale setting. For example, European locales accept dates using formats like DD-MM-YYYY. The US locale accepts dates using formats like MM-DD-YYYY.

4.5 New Features and Functionality

These are the new and enhanced features in this release. For a complete list of issues that we fixed in this release, see 4.5 Fixed issues.

UI Reports query cancellation

Beginning in this release, ThoughtSpot reports queries which exceed system resource:

Query cancelled due to memory limits being exceeded (OOM).

Data type information available on hover

The data type information is now available when a user hovers over a column in the left panel.

Improved session security

New improvements in security reduce the amount of information made available by the UI during a user session.

Improved memory management logs

This release includes improvements to how the system logs memory situations. The logs now record when a situation begins and ends plus information about which request triggered the situation. The system also now keeps a tally of how many distinct clients experienced a rejection.

Improvements in upgrade

This release includes significant improvements in the performance of upgrades particularly those installations with large objects.

Multiple data/time formatted columns in data import

Your imported data can now include columns with different date/time formats.

New commands to install R packages

This release includes the `tscli rpackage` command. This command allows users to manage R packages for use with SpotIQ.

Setting user feedback email

Users in ThoughtSpot may be asked for feedback for new or BETA features in the system. By default, feedback goes directly to ThoughtSpot support. Alternatively, you can send feedback to someone in your company. See the tscli commands reference for details.

SpotIQ profile preferences

In this release, you can configure your SpotIQ preferences in your user profile. These preferences control notifications and allows you to exclude nulls or zero measures from your analysis.

Flying our new colors

In this release, we are changing our primary navigation bar from black to light gray. Screen captures in the documentation may show the older color scheme. Expect them to update over all.

Expand RLS configuration to include all underlying tables

By default, worksheet queries only take into account RLS rules on tables whose columns appear in the query. Other related tables that may underly the worksheet are ignored. This means that not all RLS rules on underlying tables are applied when a user queries a worksheet.

You can configure a stricter application of RLS rules to take into account RLS rules from all the tables underlying the worksheet. This is recommended if you have key dimension tables that worksheets rely on but that are not necessarily regularly accessed through query. To do this, contact ThoughtSpot Customer Support.

Higher bulk filter limit

Users can now have up to 10K values in a bulk filter. Additionally, bulk filtering no longer requires validation of filtered values. Values in the bulk filter that do not exist in the data are allowed in the filter. This allows a filter to anticipate data that may be present in the future.

New home page

This release includes updates to the application home page. It now contains several new sections intended to encourage users to explore and learn about your company data:

  • All time popular/Recently trending answers and pinboards
  • Recently viewed answers and pinboards
  • Recent team activity Answers, pinboards, worksheets, and tables people in your company have created or edited recently.
  • Did you know? Auto analysis results from SpotIQ

The areas are restricted by privileges just as other areas. For example, if a user doesn't have the ability to use SpotIQ, that option does not appear.

Stricter column sharing feature

This release includes the ability to apply strict column level security. Under the standard column sharing, users without access to a specific table column can still see the column's data if subsequent worksheets relying on that data were shared with them. Now, you can for your installation, prevent this permissive sharing and prevent users from ever seeing the data. Speak with ThoughtSpot Customer Support for information on enabling this feature.

Grant Download/Upload to All

This release includes two APIs (v1/group/addprivilege or v1/group/removeprivilege) that allow you to add or remove the DATADOWNLOADING or USERDATAUPLOADING privilege to/from the system default ALL_GROUP group.

New date functions for formulas

This release includes several new date functions for formulas:

  • day_number_of_quarter
  • day_number_of_week
  • month_number_of_quarter
  • week_number_of_month
  • week_number_of_quarter
  • week_number_of_year

Metrics pipeline improvements

Included in this release are metrics pipelines that empower both our team and yours to enrich the ThoughtSpot product experience. The new metric pipelines enable:

  • Faster issue resolution: ThoughtSpot collects the diagnostic information from your system on an ongoing basis: there is no time needed to collect diagnostic information after a problem is reported. Our support team can begin working to remediate any issue with you at once.
  • Failure prevention: Metrics provides direct visibility to the ThoughtSpot team on your system's limits. Therefore, our Support team can proactively identify critical threshold issues and work to prevent failures. Metrics also help reduce SLA times as the team can debug much faster.
  • Improved Search: ThoughtSpot can tune search algorithms by studying search history and schema.
  • Improve Performance: ThoughtSpot analyzes expensive and complex query patterns to look for performance optimizations.
  • Improved Browser Performance: Finally, the metrics pipeline allows ThoughtSpot to identify application-use patterns that contribute to performance bottlenecks with specific browsers and help your team prevent or alleviate them.

Relative time filtering

This release includes support for filtering with relative time frame. The syntax for this filter is:

last [N] <period> for each <period>

For example, this filter presents results for the last two months for all the years available in the data.

last 2 months for each year

Gridlines for charts with x/y axis

Users can now enable the display of gridlines in charts that have an x and y axis.

Improvements to Growth-over-time queries

This release includes improvements with queries that use growth of queries with formats such as the following:

growth of <measure_column> by <date_column> <bucket> <period-over-period>

This table shows the possible buckets and the period-over keywords you can combine:

quarterly monthly weekly daily hourly
year-over-year year-over-year year-over-year year-over-year  
  quarter-over-quarter quarter-over-quarter quarter-over-quarter  
    month-over-month month-over-month  
      week-over-week  
        day-over-day

New period keywords

This release includes expansions to the time-series keywords. The quarter of year and day of month keywords were added.

Ability to set table load prioritization

You can now use tql to set table load priority. You can set priority values between 1-100. The default priority is 50. A lower number indicates a higher priority, with 1 being the highest priority. Tables set to a load priority of 1, load before tables set to higher numbers. The following illustrates examples of the new commands for setting and changing table load priority:

  alter table 't1' set load priority [value]
  alter table 't1' remove load priority

Customize headline display

Now, you can decide whether or not to display headlines in your table results. To customize headlines, choose Actions > Customize summaries.

Pinboard information

The Actions > Pinboard Info was added to the pinboards. This feature allows you to see who authored a pinboard, when it was created, and when it was last modified.

Improved call home functionality

"Call home" data is metadata and usage data from your ThoughtSpot cluster. ThoughtSpot's "call home" functionality intermittently sends a call home bundle of statistics to a ThoughtSpot S3 server via HTTPS. The data is encrypted at rest on the server.

Beginning with this release, callhome is enabled by default. Your ThoughtSpot Support personnel configures callhome for you during installation and upgrade.

Additional RLS abilities with privilege

Users in groups with this privilege (directly or via group inheritance) can now add/edit/delete existing RLS rules. They were are already permitted to:

  • Exempt from row-level security (RLS) rules.
  • Permitted to check or uncheck Bypass RLS on a worksheet.

New default snapshot policy

This release includes a new default snapshot policy. Three snapshots are taken over 4 hour intervals in the course of a day. And 4 daily snapshots are taken. This provides continuity over the long weekends in many countries by ensuring snapshots on Saturday, Sunday, Monday, and Tuesday.

Learn ThoughtSpot in GA

The Learn option from the main menu has moved from a BETA to a GA feature. Learn uses replay to teach users how to perform search with ThoughtSpot.

Filtered aggregation

You can now use a set of filtered aggregation functions in the Formula Editor rather than crafting a lengthy if then else formula to achieve that today. Filters are useful for queries where the results should reflect a new, filtered vale. For example, a query that compares total revenue with the cost of the west region. In this example, you filter the region column to values in the west only.

Disable footer in some embed situations

This release includes the ability to disable the footer in embed applications that involve an individual visualization.

Updates to the System Health pinboards

This release includes updates to counts in System Health for:

  • pinboard impressions
  • ad-hoc searches -new search done from search bar
  • user counts

New boards were added and some older boards were deprecated. An expanded monitoring section was added to the documentation as well.

Comparison with vs and all

Users can now do comparisons with the vs/versus keyword. You can also use the new all keyword in these comparison expressions.

New ts_username variable for RLS

A new ts_username variable was added for use in row level security (RLS) rules.

ts_username != 'mark'

Period-ago analysis feature "for each" and versus and more

This feature allows user to analyze and compare two time periods. For example, a user wants to compare monthly performance this year vs last year.

New languages and Canadian mapping

This release includes support for Canadian province and county maps.

Additionally, following languages are possible from the interface.

Locale Language BETA?
de-DE German  
en-CA Canadian English Yes
en-GB United Kingdom English  
en-US English (United States)  
es-US Spanish (United States) Yes
fr-CA French (Canada) Yes
fr-FR French (France) Yes
ja Japanese  
pt-BR Portuguese (Brazil) Yes
zh-CN Chinese (S)  

BETA languages are for testing purposes only. You should not rely on them for production clusters.

Improvements to pivot table visualizations

This release added the ability to show grand totals on pivot tables.

Pivot tables now support the tree layout for row headers:

From the header menu users can now change the type of total shown for an aggregated measure:

Finally, pivot tables no longer limit the number of rows displayed. Previously, rows over the limit showed as (Other) . Now, the system simply shows the rows as expected.

Ramdisk is preserved across cluster upgrades

A feature was added that preserves RAMDisk across cluster upgrades.

Present option on pinboard and visualization

The present operation is now available on both the pinboard and an individual visualization Action menu.