Admin

Updated and new permissions for exports

Export permissions are now more granular. The Download or Send Now permission is now two permissions, Download and Export to email. The functionality managed by these permissions has not changed, and existing account types have been migrated to use the new permissions.

In addition, the ability to have an export run as the recipient is managed by a new permission, Run exports as recipient.

For more details, see License and account type overview.

Workbook elements

Improved pivot table performance

Pivot tables are no longer limited to 100,000 points of data. In addition, pivot table rows support infinite scroll.

Workbook features

Export any supported format to Google Drive

You can now export one or more workbook elements, workbook pages, or an entire workbook to a new folder in Google Drive. Additional file format types are now supported, such as PDF and PNG.

See Send or schedule workbook exports for details on supported file types.

API

New API rate limit

The v2/auth/token endpoint is now rate limited to one request per second.

See Get started with the Sigma REST API.

Functions and calculations

Create time series forecasts (Beta)

In a Sigma workbook, you can use historical time series data to predict and visualize future values and trends. This feature enables Sigma users to leverage Snowflake’s forecasting ML function without requiring prior SQL knowledge.

See Create time series forecasts (Beta).

Bug fixes

  • When a workbook action is configured to set a control value on click in a visualization element, clicking on the white space outside the chart now clears the control value as expected.
  • Workbook actions triggered from interactions with tables which have columns that either do not have a type or an error type now run as expected.
  • When users send a request to their admins for a tag to be applied to their workbook, the resulting email notifications now use custom branding settings configured for the organization.

Admin

Team provisioning for SAML SSO

Team provisioning for SAML SSO is now supported. Team assignments for a SAML user are synced when logging into Sigma. See Single sign-on with SAML.

Search and discovery

Send bug reports from error messages

For select errors, you can now send a bug report from a link in the error message.

Workbook elements

Customize element styles in a workbook layout (Beta)

You can now customize the styling of data elements such as tables, input tables, visualizations, and UI elements. Add or remove padding, change the corner style, add a border, and change the text alignment for text elements.

Set default styles in an organization theme, customize styles for an entire workbook in the workbook settings, or style individual elements.

See Customize element background and styles and Workbook settings overview.

Copy pivot table contents

You can now copy cells, rows, and columns in pivot tables to your clipboard.

Highlight the selected row for the pivot table

When you select a cell in a pivot table, the corresponding pivot row is highlighted.

Updated Geography map visualization

The Geography map visualization now uses Mapbox. The Point and Region map visualizations already use Mapbox.

As part of this change, the default zoom of your map might be different. Use the Pin viewport option on a map to persist the desired zoom level.

Workbook features

Make actions conditional (Beta)

When you define an action for a workbook element, you can now define an optional condition for that action. Customize the trigger behavior of your action based on the value of a control element or using a custom formula.

GIF showing a visualization of Total sales by country over time and a control with two values, Individual trend and Comparison. In the animation, a user clicks each of the two values, demonstrating that the chart visualization switches between a trellis view of each country and a combined view in a stacked bar chart.

See Make an action conditional (Beta).

New version of plugins available

Enhancements include:

  • Plugins can now trigger actions in other workbook elements.
  • User-defined functions can now be called in plugins through workbook actions.
  • Paginated data fetching, allowing you to fetch more than 25,000 data points.
  • Warning messages if configuration items are passed into functions/hooks before they are registered.

Developers can access detailed installation and usage guides on GitHub.

Admin

Self-serve audit logging features (GA)

The Administration portal now includes an Account > General Settings > Audit Logging section that supports the following self-serve features:

  • Sigma Audit Logs: Enable audit logging by activating the Sigma Audit Logs connection.
  • Create, update, or delete an Audit Logs Storage Integration: Add, update, or delete a cloud storage integration specifically for exporting audit log data to AWS, Azure, or GCP

Audit logs functionality also has improved SLIs for data freshness and delivery. Fresh event data is available within an hour 99.9% of the time, and new audit log events are available at least once 99.9% of the time.

For more information, see Enable audit logging and Create, update, and delete an audit logs storage integration.

API

New workbook bookmarks API endpoints

The following endpoints to work with bookmarks in workbooks, including version tagged workbooks, are now available:

The same endpoints are available for tagged workbooks:

New response output for List templates shared with your organization endpoint

The entries array includes one additional property in the response for the List templates shared with your organization (GET /v2/shared_templates/shared_with_you) endpoint:

  • createdAt: When the template was shared with your organization

New endpoint for workbook version history

The following endpoint for retrieving the version history of a workbook is now available:

Embeds

Embed SDK for React (Beta)

The Embed SDK for React offers a developer-friendly interface that simplifies integration into applications. Developers can access detailed installation and usage guides on Github.

See Embed SDK for React (Beta) or follow this QuickStart for an in-depth guide to using the SDK.

Functions and calculations

Write, correct, and explain formulas using the AI formula assistant (Beta)

Sigma’s formula assistant uses AI to write new formulas, correct formula errors, and explain existing formulas applied to elements in workbooks and data models. These AI capabilities can help enhance productivity and accuracy, ensuring you get the most out of custom calculations and available functions.

For more information, see Use AI with formulas (Beta).

Workbook elements

Format segmented control alignment

You can now format the alignment of a segmented control. Align the control to the left or right, or stretch the control to the full width of the control element.

For more details, see Create and configure a segmented control.

Expanded text formatting options for conditional formatting

When you apply conditional formatting to a table or pivot table, you can format the style of the text. Conditionally apply underline, italics, or a specific text color to text.

Workbook features

Updated workbook theme colors and settings

The colors used for organization and workbook themes have been updated, and there are new settings to override the canvas color or element background color for a workbook theme.

Workbooks using existing themes have been migrated to the new colors. As a result, existing theme colors might have an override canvas color or override element background color already set. If your workbook does not look as expected, review the following known issues and workarounds:

  • If your background is no longer white or black, set override colors for both the Canvas and Element.
  • If your workbook is oddly pastel and bright, adjust the Surface color. Open the color picker and drag the color picker to the bottom of the color field.
  • If your workbook has a tinted color instead of gray, adjust the Surface color. Open the color picker and drag the color picker all the way to the left of the color field.
  • If your theme was originally based on a preset theme, reapply the preset and adjust the Primary color.
    If the colors in your workbook appear overly saturated, adjust the Theme colors to use less saturated colors.

See Theme settings for more details. For further assistance, contact Sigma Support.

Specify color palette with hex codes

To more precisely specify the visualization color palette for your workbook, you can specify a custom color palette with hex codes.

See Workbook settings overview.

Custom sort null values in pivot tables

Specify the sort order of null values in a pivot row or pivot column using custom sort. Choose from the default option, which mimics your data warehouse sort order for null values, listing all null values first, or listing all null values last.

For more details, see Customize the sort order of data elements.

Bug fix

  • When tagging a version of a workbook that contains only input tables, you can now swap data sources successfully.

Admin

Authenticate Databricks connections with OAuth (Beta)

You can now connect to Databricks using OAuth and inherit all security policies from Databricks. Databricks connections authenticated with OAuth allow your users to read data and use write-back features like input tables, warehouse views, materializations, and CSV uploads with their own individual credentials instead of a service account.

See Configure OAuth with Databricks (Beta).

Functions and calculations

ArrayIntersection function

The ArrayIntersection function compares two arrays and returns an array of all overlapping elements, without duplicates. The function is now supported for BigQuery, Snowflake, and PostgreSQL.

See ArrayIntersection.

SHA256 function

The SHA256 function transforms text input into a 256-bit hash value. The function is supported for all databases except for PostgreSQL.

See SHA256.

Bug fixes

  • Insert row action (beta) now prohibits row insertion into tables with protected columns.
  • Modifying the permissions for a nested folder that inherited its permissions from the parent folder no longer affects the parent folder permissions.
  • Tagging a workbook after removing a version tag no longer results in an error indicating "Failed to tag workbook, $workbookname$ is archived."

Admin

Manage upgrade requests in the Administration portal (Beta)

Admins can now view and respond to account upgrade requests in the Administration portal. When a user requests an upgrade to their account type to explore or create workbooks, an admin can review the request in the Administration portal. Admins still receive emails about these requests.

See Respond to account upgrade requests (Beta).

Update or delete audit log storage integrations (Beta)

You can now update or delete your audit log storage integration without assistance from Support. Use the Administration portal to change or delete the integration destination.

See Create, update or delete an audit logs storage integration (Beta).

API

Pagination required for list endpoints (breaking change)

List endpoints that did not already require pagination now require pagination as of September 4, 2024.

If you use these endpoints, update your API requests to include the limit query parameter to return a paginated response. Requests without the limit parameter now return a paginated response of the default page size (50).

Reorganized API endpoint documentation

The API endpoint documentation is now organized in logical subsections to make endpoints easier to find and use.

Embeds

Configure shareable links for secure embeds

You can now create shareable links with your own domain name that enable your embed users to share embeds of entire workbooks with other users. In addition, you can use the new workbook:sharinglink:update JavaScript event to make the link available though the embed menu, embed footer, and scheduled export email notifications.

See Configure a shareable link for an embed.

Workbook elements

Organize workbook layouts with containers (Beta)

You can add containers to your workbook pages to organize elements on the canvas and visually group elements together. With containers, you can more easily manage layouts and style elements as a group.

Gif showing a workbook layout before and after containers are applied

See Organize workbook layouts with containers (Beta).

Expanded options to hide or show totals in pivot tables

You can hide or show totals in a pivot table using the Element format menu, or by right-clicking the column totals that you want to hide and de-selecting Show totals in the menu.

See Pivot table totals and subtotals.

Bug fixes

  • Copying and pasting an input table element no longer results in the error β€œUnfortunately, something went wrong. Pasting failed.”

API

New option for Swap workbook datasources endpoint

The Swap workbook datasources endpoint (POST /v2/workbooks/{workbookId}/swapSources) now includes the swapTables and paths options.

  • Set the swapTables option to true in your request to change all tables in the workbook to use the new connection.
  • Use the paths option to specify connection paths to map from the original connection to the new connection. For example, to swap a workbook connection from DB1.ExampleSchema to DB2.SampleSchema, use this option.

New query parameter for List workbooks endpoint

The List workbooks endpoint (GET /v2/workbooks) now includes the excludeTags query parameter. Set excludeTags to true to improve query performance in cases where you do not need version tag information in the response.

Workbook features

New option for Export to email workbook action

By default, the Export to email workbook action now runs as the user who performs the action instead of as the recipient of the email. You can optionally select to run as recipient instead.

See Create actions that download and export data for more details.

Admin

Import data from an image (Beta)

If you have an OpenAI integration configured, you can now import data from an image of a table or a simple chart. The data is parsed and uploaded to a connection with writeback support, then you can start exploring the data in a workbook.

For more information and recommendations, see Import data from an image (Beta).

Embeds

Authenticate secure embeds using JSON Web Tokens (JWTs) (Beta)

Sigma supports authenticating secure embeds using JSON Web Tokens (JWTs). JWTs are compact, URL-safe tokens that can be digitally signed, ensuring that the data they contain is tamper-proof. Using JWT-signed URLs for your embeds offers several advantages, including offering a secure way to embed content that can be accessed by both external users and internal users.

For more information, see Create an embed API with JSON web tokens (Beta).

Workbook elements

Paste 2,000 rows in input tables on Snowflake connections

When populating data in input tables on a Snowflake connection, you can now paste up to 50,000 cells at once (2,000 rows and 25 columns).

For more information, see Intro to input tables.

Waterfall chart (GA)

Waterfall charts are now generally available (GA). Build a waterfall chart to show changes in data over a period of time. Waterfall charts are perfect for financial analytics use cases where you track revenue and spend for a project, department, or an entire organization, and other use cases. You can format the shape, start, and end values of a waterfall chart as well.

For more information, see Build a waterfall chart.

Bug fixes

  • Sorting pivot columns in a pivot table with more than 25,000 cells of data now works as expected.

API

New response output for Get embeds for a workbook endpoint

The entries array includes three additional properties in the response for the Get embeds for a workbook (GET /v2/workbooks/{workbookId}/embeds) endpoint:

  • sourceType: Whether the source of the embed is a workbook, page or element.
  • sourceId: The ID of the workbook, page, or element that is the source of the embed.
  • sourceName: The name of the workbook, page, or element that is the source of the embed.

Workbook features

Use actions to insert rows into input tables (Beta)

Use the Insert row action to insert a row into an input table based on a user’s interaction with another workbook element. For more information about actions in Sigma, see Intro to actions .

Admin

New permission for AI features

Manage access to new AI features in Sigma with the Use AI features permission. Users must have a Pro license to be granted this permission.

See License and account type overview.

Data modeling

Version tagging support for data models (Beta)

Version tag data models to support version tagged workbooks and manage access to specific versions of a data model. You can also swap sources between different tagged data model versions.

A tagged version of a workbook that uses a data model as the source stays in sync with the latest published version of the data model. If you want the tagged version of a workbook to use a specific version of a data model, tag that data model version and use it as the source for the tagged workbook version.

For more details, see Create and manage version tags and Add version tags to workbooks and data models.

View parameters referenced by a custom SQL element in a data model

Custom SQL elements in a data model that reference a control as a parameter in the SQL syntax are now visible from the Targets section of the Element properties for the control.

Screenshot showing the Element properties panel for a control with the Targets tab open, showing "Custom SQL" in the "Currently referenced by" list.

Workbook elements

CSV input tables (GA)

Pre-populate a new input table with uploaded CSV data you can edit at the cell level.

Like empty input tables, CSV input tables support data entry independent of existing data, enabling you to add editable rows and columns to construct the table as you see fit.

For more information, see Intro to input tables and Create new input tables.

Stacking support for waterfall charts (Beta)

Waterfall charts now support stacking. With stacked waterfall charts, you can plot multiple data series as cumulative waterfall segments and compare subcategory contributions to each category’s total sum value.

Waterfall chart showing total sales quantity for each year, plotted as the difference from the prior year, with 2024 showing as a sharp decrease because the year is only half over.

See Build a waterfall chart (Beta).

Updated file names for Google Sheet and Google Drive exports

The default file name used for Google Sheet and Google Drive exports has been updated from:

date time - workbook name

to

workbookName_elementName_timestamp

This change makes these export naming conventions consistent with Sigma's other export file name patterns.

For example, for a workbook with the name workbookName, exported on August 2nd, the file name changes from 2024-08-02 10:07 - workbookName to workbookName_elementName_20240802T1007.

Bug fixes

  • When a specific version of a workspace has been shared with a user or team using both a direct grant and an inherited grant, Sigma no longer lists the same version tag multiple times in the Share Folder modal.