What's new in Sigma

API

New API endpoints to manage audit logging for an organization

The following endpoints are now available to manage audit logging for an organization in Sigma:

New API endpoints to manage CSV upload settings

The following endpoints are now available to manage CSV upload settings for an organization in Sigma:

New option for the List datasets endpoint

The List datasets (GET /v2/datasets) endpoint includes a new option to list datasets owned by a specific user by ownerId.

Represent CSV tables in the code representation of a data model

You can represent tables that use a CSV as a date source when reading and updating the code representation of a data model.

For limitations, see Manage data models as code. For an example, see the CSV table example in the data model representation example library.

Admin

Additional account languages available

The following new languages are now available to set as your organization’s Account language in the Administration portal:

  • Chinese (Simplified)
  • Chinese (Traditional)
  • Dutch
  • French
  • French (Canada)
  • German
  • Italian
  • Japanese
  • Korean
  • Polish
  • Portuguese
  • Portuguese (Brazil)
  • Russian
  • Spanish
  • Spanish (Mexico)
  • Swedish
  • Thai
  • Turkish

The account language controls the language of Sigma UI text for users in your organization and consumers of embedded analytics. Previously, only English variants were supported.

For the full list of account languages, as well as how to set one for your organization, see Set organization language and formatting region.

Restrict Can contribute access to specific version tags

When you share a workspace or folder and grant Can contribute access, you can now limit the versions that users and teams can explore to specific version tags. Previously, Can explore access to all documents and versions in the workspace or folder was granted to users and teams with Can contribute access.

The version restriction applies to documents that other users create. Users with Can contribute access retain full access to the documents they create themselves.

For more information, see Restrict access to a folder using a version tag.

Select Microsoft integration permission levels (Beta)

When setting up a Microsoft integration, you can now select between write only and read/write access levels.

See Permission levels (Beta) in Manage Microsoft integration.

Data modeling

When you migrate a dataset to a data model, you can choose which related datasets to combine into a single data model instead of migrating all linked, joined, or referenced datasets together. Datasets you do not select remain available to migrate later.

For more information, see Migrate a dataset to a data model.

Functions and calculations

Match on null values when performing a lookup (LookupMatchNulls function)

When performing a lookup, you can now select Match null values to match rows where the join keys on both sides are null.

You can also create lookups that match null values using the LookupMatchNulls function when writing a formula.

For more information, see Add columns through lookup.

TextJoin function (GA)

You can use the textjoin function to join multiple strings of text data using a common delimiter. For more information, see Textjoin.

Reports

Export reports in PowerPoint format (Beta)

You can now export and download reports as PowerPoint (.pptx) files.

See Share and export reports.

Export specific report pages

You can now select one or more specific report pages to export.

See Send or schedule report exports.

Workbook features

Drawers (GA)

Use drawers to create a side panel that slides in to overlay the workbook page temporarily, allowing you to display new content and information at specific points in a workflow without disrupting other content.

For more information, see Use drawers to manage complex workflows.

Bug fixes and improvements

  • The Update a data model from a code representation endpoint now checks whether the documentVersion field matches the most recent document version before updating the data model.

  • Users assigned an account type with the Manage users permission enabled can now invite users as guest users.

  • When deploying documents that rely on team or user attribute assignments to enforce column-level security (CLS) rules, if the teams or user attributes exist on the tenant organization with the same name, the documents deploy and the CLS rules are enforced. If the teams or user attributes do not exist on the tenant organization, the documents fail to deploy to that tenant with an informative error message.