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.

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:

workbookTaggedAtTimestamp that indicates when a workbook was tagged with the given version tag.
sourceWorkbookVersionVersion number that identifies which version of the workbook was tagged with the given version tag. The number corresponds to the version number available in the workbook's version history.

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:

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:

Column nameMetadata description
DOCUMENT_HAS_VERSION_TAGTrue or False
DOCUMENT_VERSION_TAGVersion tag name
VERSION_TAG_SOURCE_DOCUMENT_UUIDSource workbook ID

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.

Example waterfall chart

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.

Pivot table demonstrating the use of 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.

Example use of text area 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.

Example use of ceckbox control element

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.

API

Folder and document favoriting endpoints

Manage favorite documents and folders for a user:

  • GET /v2/favorites/member/{memberId} lists documents and folders favorited by a user.
  • POST /v2/favorites favorites a document or folder for a user.
  • DELETE /v2/favorites/member/{memberId}/file/{inodeId} unfavorites a document or folder for a user.

Workbook template endpoints

Manage workbook templates:

  • POST /v2/templates/{templateId}/swapSources swaps the data sources of a template.
  • POST /v2/workbooks/{workbookId}/saveTemplate saves an existing workbook as a template.

Embeds

Self-service embed usage analytics

Use a third-party tool (like Pendo) to track inbound and outbound events implemented in your embedded analytics.

By tracking iframe events, you can gain a better understanding of how customers are using your embedded data. For more information, see Implement inbound and outbound events in embeds.

Workbook elements

Control element naming updates

For consistency and clarity, the control elements formerly labeled Text control and Number are now labeled Text input and Number input.

Workbook features

Zip file option for attachments in exports

Compress export attachments into a single zip file.

If you export files that are too large to send by email, choose Send as zip file to compress the attachments and ensure your reports are delivered as expected. For more information, see Compress attachments to a zip file.

Combined file option for PDF attachments in exports

Combine multiple PDF attachments when configuring ad hoc and scheduled exports.

The Combine attachments option expands the previous ability to merge Excel attachments into one file. For more information, see Merge PDF or Excel files.

Enhanced color formatting for workbook themes

Edit your workbook color settings directly from the Color section of the Workbook settings panel. You can also see a real-time preview of your workbook colors that automatically updates as you adjust the settings.

The color picker also features a new eyedropper tool that allows you to pick a color from the same workbook or a different browser window.

For more information, see Workbook settings overview.

Workbook features

Explain visualizations with AI (Beta)

Instantly generate a description of any chart with the AI Explain visualization feature. Details can include key insights, observations, data distribution summaries, and other context that can enhance your understanding of the visualized data and help drive informed decisions.

For more information, see Explain a visualization with AI.

Admin

OAuth write access (Beta)

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.

Embeds

Inbound event for bookmark update in embeds

Use the workbook:bookmark:update inbound event to communicate and interact between embedded content and the host application.

For more information, see Implement inbound and outbound events in embeds.

Workbook features

Default version tags

Users with Can edit workbook permission can now designate a tag as the default tag for a workbook. As a result, any user who does not have access to the Published workbook will see the default tagged version. Applying default tags to workbooks with multiple tags results in a more consistent viewing experience.

For more information, see Set a default tag for a workbook.

Bug fixes

  • A user’s Sigma access token now expires when the OAuth access token expires, ensuring the user is logged out when the OAuth session has ended.

  • Updates to filters and sorting in tagged workbook versions are now reflected in exports and no longer trigger errors.