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:
- 184.108.40.206 to 4.5.1.x
If you are running 220.127.116.11 or earlier, you must do a multiple pass upgrade:
- Upgrade your cluster to 18.104.22.168.
- Upgrade from 22.214.171.124 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.
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.
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.
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).
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.
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.
Beginning in this release, ThoughtSpot reports queries which exceed system resource:
Query cancelled due to memory limits being exceeded (OOM).
The data type information is now available when a user hovers over a column in the left panel.
New improvements in security reduce the amount of information made available by the UI during a user session.
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.
This release includes significant improvements in the performance of upgrades particularly those installations with large objects.
Your imported data can now include columns with different date/time formats.
This release includes the `tscli rpackage` command. This command allows users to manage R packages for use with SpotIQ.
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.
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.
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.
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.
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.
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.
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.
This release includes two APIs (
v1/group/removeprivilege) that allow you to add or remove the
USERDATAUPLOADING privilege to/from the system default
This release includes several new date functions for formulas:
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.
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
Users can now enable the display of gridlines in charts that have an x and y axis.
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:
This release includes expansions to the time-series keywords. The
quarter of year and
day of month keywords were added.
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: