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.

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.

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.

Admin

New connection type: Starburst Galaxy

Sigma now supports connecting to your Snowflake, Databricks, BigQuery, or PostgreSQL cloud data warehouse through Starburst Galaxy, a SaaS distribution of Trino. For more information, see Connect to Starburst.

API

Pagination required for List endpoints (breaking change)

List endpoints that did not already require pagination will start requiring pagination on September 4, 2024.

• List members (GET /v2/members)
• List teams (GET /v2/teams)
• List workspaces (GET /v2/workspaces)
• List materialization schedules for a workbook (GET /v2/workbooks/{workbookId}/materialization-schedules)
• List scheduled exports for a workbook (GET /v2/workbooks/{workbookId}/schedules)

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

New file type for List files and List member files endpoints

The typeFilter query parameter for the List files and List member files endpoints now includes a symlink option that you can use to filter shortcuts in your request. Shortcuts are also included in the response of requests that do not include a typeFilter.

New option for Update an inode endpoint

The Update an inode endpoint (PATCH /v2/files/{inodeId}) now includes the restore option. Include the restore option in your request to restore previously deleted files.

Search and discovery

Add shortcuts to documents (Beta)

If you want to save links to documents in more than one location, you can add a shortcut. Use shortcuts to make specific data sources easier to find in the source picker, or to organize documents to make key workbooks and data models easier to access.

See Add shortcuts to documents for more details.

Workbook features

Custom workbook page width

Set a custom page width for a workbook. Specify a pixel width to constrain the elements on workbook pages to a maximum width. See Workbook settings overview.

If you export workbook pages to PDF, use this setting to approximate the layout size of a PDF page. See Format PDF page export layout.

API

New response output for List workbooks for a tag and Get a workbook endpoints

The tags array includes two additional properties in the response for the List workbooks for a tag and Get a workbook endpoints:

Workbook features

Export to webhook

Webhook exports are now generally available (GA). Use a webhook to send workbook data to your own webhook endpoints or other applications.

For more information, see Export to webhook.

API

Additional workbooks and shared templates endpoints

The following workbooks and shared templates endpoints are now available:

• Share a workbook or template with another organization: POST /v2/workbooks/{workbookId}/shareCrossOrg

• List templates shared with your organization : GET /v2/shared_templates/shared_with_you

• Accept a pending template share: POST /v2/shared_templates/accept

New option for Create a connection endpoint

The Create a connection endpoint (POST /v2/connections) now includes the option to connect to MySQL.

New query parameter for List connections endpoint

The List connections endpoint (GET /v2/connections) now includes the includeArchived query parameter to return archived and inactive connections. If your request doesn't use this parameter, the response output is unchanged.

Embeds

Enhanced underlying data exploration

Embedded workbooks now support the enhanced Underlying Data modal, accessible from individual data points in visualization elements.

Right- or left-click a data point and select Show underlying data, then explore the underlying data by modifying filters, adding and removing columns, and interacting directly with the chart and data table.

Workbook elements

Trellis formatting for combo charts

Combo charts now support trellis formatting. Add a column as a trellis row or column to split a combo chart into a trellis.

Bug fixes

• The Administration > Authentication > Authentication Settings and Options section now correctly allows an admin to edit the Company Domain Signup field regardless of the configured authentication method.

• Conditional formatting for pivot tables now applies to cells containing “Total” labels. For more information, see Apply conditional formatting.

Functions and calculations

Function index

Use the function index to browse our entire functions catalog or use Ctrl+f to search for a specific function—all in a single page.

Sigma supports over 200 functions that enable you to perform simple and complex calculations, transformations, and extractions to get the most out of your data. The function index lists these by category (Aggregate, Date, System, Window, etc.), provides a brief description of each, and links to the individual function pages.

Workbook elements

Row ID column in input tables

Add an input table column containing system-generated row IDs to expose unique identifiers that support data management and referential integrity.

For more information, see Add row ID.

Workbook features

Show or hide columns with names matching control values

Use the Modify element action to show or hide table columns with names that match selected control values.

For more information, see Show columns with names matching control values and Hide columns with names matching control values.

Admin

New version tag metadata in audit log (Beta)

The AUDIT_LOG > SIGMA_SHARED > DOCUMENTS dimension table now contains the following columns:

This metadata enables you to obtain information related to both the source workbook and the tagged version when referencing audit log entries for events like exports and downloads.

Functions and calculations

Sequence function

The Sequence function returns an arithmetic sequence as an array of integers based on a specified range and increment.

For more information, see Sequence.

Workbook features

Support for emailing exports to organization users and teams

When configuring an email export, the Recipients field now features an autocomplete dropdown that helps you search for and select an organization team or user. You can also continue to input specific email addresses for non-organization members with authorized domains.

For more information about emailing workbook content , see Export to email.

Bug fix

• The Administration > Account Types > New Account Type page now correctly shows the Create, edit, and publish workbooks permission as auto-enabled (checkbox selected) when the Apply tags permission is enabled.

Admin

OAuth write access

OAuth with write access is now generally available (GA). No changes were made since the Beta release in May.

Configure an OAuth connection with write access to leverage the benefits of OAuth permission management with Sigma’s write-access features, including input tables, warehouse views, workbook materializations, and CSV uploads.

For more information, see Configure OAuth with write access.

API

Connection sync endpoint

Sync the connection to a specific database, schema, or table to update the data in Sigma.

For more information, see POST /v2/connections/{connectionId}/sync.

Embeds

Additional language support for workbook localization

You can now localize workbook text into Simplified Chinese, Korean, and Swedish.

For more information, see Manage workbook localization.

Workbook elements

Waterfall chart (Beta)

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.

Repeat row labels in pivot tables

In pivot tables with multiple pivot rows, you can format your table to repeat row labels.

For more information, see Working with pivot tables.

Text area control element

Use the Text area control element to enable multi-line text input.

With customizable input field height and vertical scrolling to view text overflow, the Text area control element is ideal for forms and more effectively supports larger amounts of text than the Text input control element.

Checkbox control element

Use the Checkbox control element to allow users to select or deselect a single option.

Like the Switch control element, the Checkbox control represents a binary state (true/false, on/off, etc.), but it offers a more suitable UI for presenting a list of multiple form options that users can select or deselect.

The screenshot demonstrates the use of multiple elements to create a multi-checkbox selection form. Each element supports a single checkbox field that can be selected independently of the others.

Functions and calculations

ArrayJoin function

The ArrayJoin function joins elements of an array into a single text string.

For more information, see ArrayJoin.

Workbook elements

Placeholder text in control elements

Customize placeholder text for any input-based control element (List values, Text input, Number input, Date, and Date range) to provide context about the expected input.

Go to Element format > General and update the Placeholder field. Placeholder text displays directly in the control’s input field and clears when the field contains user input.