We are happy to inform you that the latest version of ThoughtSpot, Release 4.4, is now available.
These are the new and enhanced features in this release. For a complete list of issues that we fixed in this release, see Fixed issues.
Learn ThoughtSpot in BETA
The Learn option from the main menu is a BETA feature that uses replay to teach you more about ThoughtSpot.
Support for UK and Canadian Languages
Support for UK English (en-GB) and Canadian English (en-CA) was added. Users can set these locale’s via their profile
Show regression line option
Users have a new option to Show Regression Line on line, column, bubble, and scatter charts.
New Has administration privileges
If you add the privilege Has administration privileges to a group, note that all users in that group will be able to see all the data in ThoughtSpot. Administrators can see all data sources, and row-level security (RLS) does not apply to them. If you want to enable users to bypass row-level security, add them to a group with Can Administer RLS privileges.
Check cluster command added
The tscli cluster check command was added to check the status of all or specific nodes in a cluster.
Service logs stored to disk
Service logs are now stored to disk. This ensures better protection against service logs from exceeding the SSD on a node and impacting a node.
The tscli nas mount-cifs command requires a password
Now the tscli nas mount-cifs command prompts for a password if you do not supply one.
Sankey Chart
A new type of chart, the Sankey diagram, is now available. This chart displays a flow diagram that illustrates transfers of flows within a system.
New improved icons
In this release, the search ? (question mark) icon was replaced with an i (letter “i”). The team has redesigned the caret-down and x (clear-all) icon. Finally, the wand icon is removed from keywords in the Search dropdown. Instead, the identifier keyword appears beneath each keyword.
What am I looking at? Redesign!
The What am I looking at information panel is improved in this release with an I rather than the previous ? (question mark). The new design is intended to clarify the information in the panel and make it easier to use.
Configurable maximum job time
You can set the maximum amount of time in milliseconds a task is allowed to stay in “In progress” state. If the task exceeds this time, it is aborted.
Administer row level security privilege
Users with the Can Administer RLS privilege can bypass row-level security (RLS) rules. By default this privilege is enabled. You can configure your installation to disable it.
Reverse of boolean to filter conversion
ThoughtSpot introduced a feature in 3.4 which implicitly converted boolean columns to filters when a user searched. For example, product isRed = true became product isRed. This behavior meant that the product column was not added to the table or chart result.
Users were confused by this implicit behavior. This feature was reverted 4.3. Now, boolean columns are treated like any other columns in the query. Meaning they remain product isRed = true and are not converted. The column also appears in the search results.
When you upgrade a 3.4 through 4.2 installation to 4.3 or newer, tables or charts created in the 3.4 through 4.2, that contained these booleans are upgraded using product isRed = true so that users are not surprised by additional columns suddenly appearing in their saved answers.
Improvements in RAMDisk recovery
This release includes improvements in the speed and performance of RAMDisk recovery.
Fan trap situations are supported for new installations
ThoughtSpot now supports fan traps in new installations. This feature is enabled by default in new installations.
For existing customers upgrading to 4.4 this feature is disabled. You must work with ThoughtSpot Support and Customer support to dentify answers and pinboards that are impacted should this feature be enabled. Your ThoughtSpot customer service representative or ThoughtSpot Support can help you to identify, mitigate, and resolve any impacted data. Once these impacts are resolved, they can enable the feature for you.
Improvements to concat function
The concat function now allows users to concatenate multiple strings rather than single strings.
Primary key drops check dependencies
Dropping a primary key can impact downstream objects such as worksheets and pinboards. When dropping a primary key, TQL now checks for dependencies and issues a warning. Users must override with the --allow_unsafe flag.
Tooltip functionality in the Schema Visualizer
A tooltip function was introduced into the Table list for the Schema Visualizer. This tooltip shows information about the underlying table.
Color picker improvements
This release includes new vibrant chart colors. It also includes the ability to add your own HEX values.
tspublic session/login and session/logout APIs
This release includes two new public APIs. You can use these APIs to log users in and out of a ThoughtSpot session. See the documentation for details about the calls.
Reduce search suggestion tokens
This release improves the search experience by reducing the number of tokens in search results. Users found the number of suggestions confusing. Instead, the search greatly reduces the number of suggestions.
Query processing improvements
This release includes improvements to the underlying processing of complex schema, object, and formula variations. Users should see improved ability to work with:
- Schema various such as chasm, fan, nested chasm, and chain of chasm traps,
- Object variations such as aggregated worksheet, join of aggregated worksheet and base tables.
- Formula variation such as aggregate and non-aggregate functions, windowing functions, and pinned measures.
These changes include optimization for generating queries that involve row level security(RLS).
Filter by creator
Users have the ability to filter pinboards and answers by creator.
Improvement in pinboard layout of small table
Tables with fewer rows appeared distorted with whitespace when pinned in a pinboard. This release includes improvements for display of tables in pinboards. See the documentation for more information about editing a pinboard.
Formula performance improvements
This release includes improvements in backend indexing formats that result in formula performance improvements.
Ability to define a join between a worksheet and a table
Users can join a worksheet to one or more tables. The direction of the join can be from the worksheet to the table or the reverse. When you join a worksheet to a table, you bring any tables connected to the joined table into a search.
This feature has limitations. It is not possible to join multiple tables in the worksheet and a single table in a single relationship. Nor is it possible to join between a formula column in a worksheet and another table.
Getting a cluster configuration
When using tscli cluster get-config to get cluster information, the system can run into situations where it cannot make a connection across the network. When this happens, the command returns an error but continues to work.
ODBC extract/transform/load improvements
By default, ThoughtSpot takes a permissive approach to datatype compatibility
between source and target in ODBC. As much as possible ThoughtSpot automatically
converts incoming “compatible” input data to the desired ThoughtSpot target
datatype. Flags were added that allow you to tune this behavior and make it stricter. At installation time, your customer support engineer can assist you in
configuring a stricter load behavior.
Users with data access can drill down
If you own the pinboard you can drill down to the data beneath. New in this release, users you share the pinboard with can also drill down provide they also
have access to the data on which the board was based.
Description included when adding columns to worksheets
When adding a column from an existing data table or worksheet, the Description of the column is also copied into the new worksheet.
Ability to change a pinboard headline
Users can edit the pinboard headline. To edit a headline, activate the headline edit button at the corner of a headline and click it.
API to transfer ownership of objects
The new POST /tspublic/v1/user/transfer/ownership API was added. It allows the transfer ownership of all objects from one user to another. You must transfer all of a user’s objects. This mehtod takes two query parameters of type String.
fromUserNameName of a user from whom the ownership needs to be transferred.toUserNameName of a user to whom the ownership needs to be transferred.
It returns a 200 status if ownership of all objects are successfully transferred. It returns a status of 400 if either the fromName and toName is invalid or for given username there is no user present.