What's new in Sigma
September 13th, 2024
Admin
Authenticate Databricks connections with OAuth (Beta)
You can now connect to Databricks using OAuth and inherit all security policies from Databricks. Databricks connections authenticated with OAuth allow your users to read data and use write-back features like input tables, warehouse views, materializations, and CSV uploads with their own individual credentials instead of a service account.
See Configure OAuth with Databricks (Beta).
Functions and calculations
ArrayIntersection function
The ArrayIntersection function compares two arrays and returns an array of all overlapping elements, without duplicates. The function is now supported for BigQuery, Snowflake, and PostgreSQL.
See ArrayIntersection.
SHA256 function
The SHA256 function transforms text input into a 256-bit hash value. The function is supported for all databases except for PostgreSQL.
See SHA256.
Bug fixes
- Insert row action (beta) now prohibits row insertion into tables with protected columns.
- Modifying the permissions for a nested folder that inherited its permissions from the parent folder no longer affects the parent folder permissions.
- Tagging a workbook after removing a version tag no longer results in an error indicating "Failed to tag workbook, $workbookname$ is archived."