> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# What's new in Sigma

> Sigma release notes for Sep 13, 2024: Authenticate Databricks connections with OAuth, ArrayIntersection function, and more.

## 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)](https://help.sigmacomputing.com/docs/configure-oauth-with-databricks).

## 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](https://help.sigmacomputing.com/docs/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](https://help.sigmacomputing.com/docs/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."