What's new in Sigma

Admin

Audit log support for GCP KSA region

Sigma now supports audit log events for organizations hosted in the GCP KSA (ME Central 2) region. For a list of all supported regions, see Enable or disable audit logging.

API

New export API rate limits

The following endpoints now have rate limits:

The Export data from a workbook (POST v2/workbooks/{workbookId}/export) endpoint is rate limited to 100 requests per minute.
The Export a workbook (POST v2/workbooks/{workbookId}/send) endpoint is rate limited to 100 requests per minute.

For all rate limits, see Get started with the Sigma REST API.

Data apps

PostgreSQL input table support (GA)

Input table support on PostgreSQL connections is now generally available.

Input tables enable structured data entry, allowing you to add new data points, update existing inputs, and supplement existing data from your data platform.

For more information about input tables and how to use them, see the following documentation:

Input table editing for workbook viewers (Beta)

Data entry permission on input tables now includes a new option: Editable in published version - all users. When this option is selected, any user with the Edit input tables permission enabled on their account type and access to the workbook—including those granted Can view access—can edit input table data.

For more information, see Change the data entry permission on input tables.

Edit input tables account type permission (Beta)

The ability to edit input table data is now enabled through the new Edit input tables account type permission. By removing it from the Basic explore permission, Sigma allows admins to provision input table editing separately from explore capabilities like viewing unaggregated underlying data, using drill paths, filtering columns, etc.

For more information, see Account type permission availability matrix.

📘
The Edit input tables permission is automatically enabled for all existing account types with the Basic explore permission enabled. For information about managing these permissions, see Create and manage account types.

Data modeling

Validate content in a data model (Beta)

When you make changes to a data model, those changes affect users of workbooks that use the data model as a source. You can now validate content to prevent breaking changes to those workbooks. Instead of manually replacing and updating deleted or changed columns and elements in affected documents, you can validate content in the data model and prevent these errors.

For details, see Validate content in a data model (Beta) and Sync a draft with the latest published version.

CSV upload number parsing (Beta)

When a column in an uploaded CSV file contains numbers with separators (commas, periods, spaces, etc.), Sigma parses the data as text strings by default. To parse the data as numbers, you can choose one of the following options:

Auto-detect: Sigma automatically detects the format pattern and parses the data as numbers accordingly. Sigma can currently detect US standard number format and European number format.
Custom format: Specify the number format pattern for Sigma to parse.

For more information, see Parse numbers with separators.

Workbook elements

Run Python code (Beta)

Add a Python element to any workbook or data model to write and run Python code. Support for Python code is now available for organizations with a connection to Snowflake. See Set up a Snowflake connection for Python (Beta).

You can write Python code that performs complex tasks like data transformation, data analysis, forecasting, prediction, or retrieve and send data to third-party API endpoints. When writing Python in Sigma, you can also:

Reference data elements like tables, pivot tables, and input tables as DataFrames.
Incorporate user input into your code by referencing control values.
Build tables and charts with the output from your Python code.
Use autocomplete to reference data sources available in your connection.
Import libraries, including custom libraries, configured when you set up the connection.

Run Python code directly on the Python element, or trigger the code to run from an action. Workbooks with a Python element can be exported and embedded. For more details, see Write and run Python code in Sigma.

Create sparklines in a table (GA)

The ability to create sparklines in a table is now generally available. You can now also configure sparkline tooltips and endpoint labels.

See Create sparklines in a table.

Vertical alignment options for controls

All control types (except the legend control) now have vertical alignment options, allowing you to change the position of the control within the element boundaries to the top, center, or bottom.

Bug fix

The Ask Sigma usage dashboard was unavailable to some organizations.