What's new in Sigma

AI apps

Input table audit history

Input table audit history records versioned snapshots of input table row and schema changes over time. For each input table, Sigma automatically creates a warehouse-native view in your data platform that can help you understand the following:

Row-level history: What changed in a specific row, who made the change, and when the change occurred.
Schema history: When a column was created, renamed, or changed to a different data type, along with who made the change and when the change occurred.

For information, see View input table audit history.

API

New API endpoint to list columns for a warehouse table

The following endpoint to list column names, types, and other details for a table in a data warehouse connection is now available:

List columns for a warehouse table (GET v2/connections/tables/{tableId}/columns)

Admin

Support for Azure customer-owned cloud storage integration (GA)

Admins can add an Azure Blob storage integration to use a customer-owned blob container with the following features:

CSV upload
File upload column in input tables
Export to cloud storage

This adds Azure to the existing AWS and GCP storage options that give your organization control over where your files live, who can access them, how long they’re retained, and how they’re encrypted.

For more information, see Configure an external storage integration with Azure Blob Storage.

Embeds

New embed URL parameter

The :hide_save_as embed URL parameter is now available to hide the Save as option in an embed.

For more details, see Embed URL parameters.

Functions and calculations

Databricks variant data type (GA)

Databricks connections support the variant data type, allowing you to handle arrays and JSON data using functions like Variant, JSON, and Array, as well as functions that use the variant data type like ArrayCompact.

For more information on functions and features that are supported on the Databricks connection type, see Supported regions, data platforms, and features.

Workbook elements

Add a control from a column

You can now add a control by right-clicking on a column name and selecting Add control.

See Create and manage a control element for more information.

Workbook features

Option to increase CSV upload limit to 1GB

By default, Sigma limits CSV uploads to 200MB to avoid timeouts and failures that can be common with large files. If your organization's users regularly work with larger files, you can increase the file size limit to 1GB. When this option is enabled, Sigma uses an upload architecture that supports larger files with improved performance and reliability.

For more information, see Configure CSV upload and storage options.

Bug fixes

Requests made to the Create a connection endpoint failed when creating a Databricks connection using OAuth because it expected a service account to exist.
Requests made to the List documents for a deployment policy API endpoint ignored the value specified for the pageSize parameter.
Tagging and swapping the source of a data model version that contained a #raw directive in a custom SQL statement failed with a placeholder error.
When swapping sources as part of a deployment policy, swapping sources to or from connection types that required only two levels (SCHEMA.TABLE) failed with a path length error.