Preview — 9.1 Release Notes¶

Outbound private connectivity for Snowflake features¶

Outbound private connectivity lets you create private endpoints in Snowflake to access a cloud platform using the platform’s private connectivity solution rather than the Internet. This lets you access cloud platform services privately and securely from Snowflake.

External stages using Azure Private Link — General availability¶

You can configure an external stage and create a private endpoint so bulk loading from Azure storage occurs over Azure Private Link.

External volumes using Azure Private Link — General availability¶

You can configure an external volume and create a private endpoint so you can connect Snowflake to your external cloud storage for Apache Iceberg™ tables using Azure Private Link instead of the public Internet.

Snowpipe automation using Azure Private Link — General availability¶

You can configure an external stage and notification integration, and create a private endpoint, so that automatic Snowpipe data loads that are triggered by Microsoft Azure Event Grid use Azure Private Link instead of the public Internet.

External stages using AWS PrivateLink — General availability¶

You can configure an external stage and create a private endpoint so bulk loading from Amazon S3 storage occurs over AWS PrivateLink.

External volumes using AWS PrivateLink — General availability¶

You can configure an external volume and create a private endpoint so you can connect Snowflake to your external cloud storage for Apache Iceberg™ tables using AWS PrivateLink instead of the public Internet.

ARRAY_AGG function support for window frames — General availability¶

With this release, we are pleased to announce that the ARRAY_AGG window function now supports row-based and range-based window frames.

CREATE DYNAMIC TABLE command: New REQUIRE USER parameter added¶

With this release, we are pleased to announce support for the REQUIRE USER parameter, which enables users to ensure that a dynamic table cannot refresh unless a user is specified via COPY SESSION.

ALTER DYNAMIC TABLE command: New COPY SESSION parameter added¶

With this release, we are pleased to announce support for the COPY SESSION parameter, which enables you to run a refresh operation in a copy of the current session, using the same user and warehouse.

External stage and external volume support for Amazon S3 access points — General availability¶

With this release, we are pleased to announce support for using an Amazon S3 access point to connect Snowflake to Amazon S3 using an external stage or external volume.

Apache Iceberg™ tables: Automated refresh — General availability¶

With this release, we are pleased to announce general availability support for automated refreshes of Apache Iceberg™ tables that use an external catalog. With automated refreshes, Snowflake polls your external Iceberg catalog in a continuous and serverless fashion to synchronize the metadata with the most recent remote changes.

Data metric functions: Support for referential integrity checks¶

With the release, we are pleased to announce that a user-defined data metric function (DMF) can accept multiple tables as arguments, which simplifies referential integrity, matching and comparison, or conditional checking across different datasets.

Join policies — Preview¶

With this release, we are pleased to announce the preview of join policies.

A join policy is a means of protecting tables and views. When a join policy is applied to a table, queries either require or do not require a join. In addition, when joins are required, they can be restricted to certain joining columns.