February 2023 release notes
These new and enhanced features of ThoughtSpot Cloud were released in February 2023.
ThoughtSpot Cloud 9.0.0.cl
For the Analyst
- 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 more information, refer to Create parameters and Using parameters.
This feature is in Beta and off by default. To enable it, contact ThoughtSpot Support.
- Upload custom geo maps Early Access
-
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.
For more information about custom geo maps, see Upload custom geo maps.
- Data labels on a dark background Early Access
-
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.
For more information about data labels on a dark background, see Show data labels.
- 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. For more information, see Reorder your pivot table.
- Apply multiple changes at once Early Access
-
Every time when a user drag and drop 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 rather than waiting in between each configuration.
For more information, see Reorder labels on the axis or legend.
- TML for Monitor alerts Beta
-
Export, edit, and import KPI Monitor alerts programmatically, using ThoughtSpot Modeling Language. For more information, see Syntax of the Monitor alert TML file.
This feature is in Beta and off by default. To enable it, contact ThoughtSpot Support.
- 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 RLS rules. Refer to ThoughtSpot Modeling Language.
- Export FQNs when exporting TML files
-
To reduce ambiguity when exporting TML files, 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.
For more information, see ThoughtSpot Modeling Language.
- Group aggregation enhancement: 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.
For example: Say that you search for
group formula
color= ‘blue’
ship mode != ‘car’
, wheregroup formula = group_aggregate (sum(Revenue), {ship mode}, {color, quantity})
. In this case, the formula will adopt the color = blue filter but ignore the ship mode filter, evaluating togroup_aggregate(sum(Revenue), {ship mode}, {color = ‘blue’})
. For details, see Group aggregation filters.
For the Business User
- Mandatory Liveboard filters Early Access
-
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.
For more information about mandatory filters, see Mandatory Liveboard filters.
- ThoughtSpot Sync
-
You can now sync data directly from an Answer or custom SQL view to the following apps:
Using ThoughtSpot Sync, you can push insights directly to your selected app, 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.
- Rename Liveboards and visualizations without entering edit mode
-
Change the name or description of a Liveboard or visualization without entering Edit mode. The more
menu for Liveboards and Liveboard visualizations now includes a Rename option, where you can edit the object name and description. For more information, see Other Liveboard edits.
For the Data Engineer
- 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. See Configure CSV upload for your Snowflake connection.
- PostgreSQL connection
-
You can now create connections from ThoughtSpot to PostgreSQL. For details, see PostgreSQL.
- Redshift Partner Connect
-
Redshift Partner Connect allows you to try out ThoughtSpot connected to Redshift for free. For details, see ThoughtSpot in Redshift Partner Connect.
- dbt metadata tags for table and Worksheet column properties and table joins
-
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. dbt stays the source of truth, and you don’t have to manually update the columns in ThoughtSpot when you make changes to your dbt model. For more information, see Metadata tags for dbt.
For the IT/Ops Engineer
- Early Access features
-
In this release, administrators can selectively enable or disable Early Access features for all users, using the Admin Console. For more information, see Early Access features. Early Access features are new in this release. For more information about them, see ThoughtSpot Cloud release life cycle.
For the Developer
For information about the new features and enhancements introduced in this release, refer to ThoughtSpot Developer Documentation.