January 22-February 13, 2025 — 9.2 Release Notes (with behavior changes)¶

Triggered Tasks now can operate as Serverless Tasks — General availability¶

Snowflake can now automatically manage the compute resources for Triggered Tasks to complete within a target interval that you specify. To convert an existing Triggered Task to a Serverless Task:

1. Suspend the task.

2. Remove the WAREHOUSE parameter and add the TARGET_COMPLETION_INTERVAL parameter.

3. Resume the task.

For more information, see Triggered Tasks and Serverless tasks.

Trust Center: Manage individual scanners¶

Trust Center scanners are scheduled background processes that check your account for security risks based on how you configured your account. With this release, you can manage individual scanners in a scanner package. When a scanner package is enabled, you can manage the scanners in the scanner package in the following ways:

• Enable or disable individual scanners

• Change the schedule of individual scanners

• Manually start individual scanners

For more information, see Managing scanners.

Outbound private connectivity for Microsoft Azure Government regions¶

You can use Azure Private Link for outbound network traffic originating from Microsoft Azure Government regions. This allows you to harden your security posture for Snowflake features like Snowpark Container Services and external volumes for Apache Iceberg™ tables.

For information about using Azure Private Link for outbound network traffic, see Private connectivity for outbound network traffic.

New SQL functions¶

The following function is now available with this release:

Additional CREATE OR ALTER commands — Preview¶

With this release, we are pleased to announce the preview of additional CREATE OR ALTER commands. These commands combine the functionality of the CREATE command and the ALTER command. A CREATE OR ALTER statement executes as a CREATE statement if the object doesn’t exist. If it does exist, it transforms the object according to the object definition in the statement.

CREATE OR ALTER TABLE provides a declarative and idempotent approach to defining your Snowflake objects. When used together with the Git integration, this enables an Infrastructure-as-Code (IaC) approach to database change management.

With this preview, the following additional objects are supported:

• CREATE OR ALTER AUTHENTICATION POLICY: Creates an authentication policy if it doesn’t exist or alters an existing authentication policy.

• CREATE OR ALTER FILE FORMAT: Creates a new named file format if it doesn’t exist or alters an existing file format.

• CREATE OR ALTER TAG: Creates a tag if it doesn’t exist or alters an existing tag.

For more information, see CREATE OR ALTER <object>.

Apache Iceberg™ tables: Support for writing Apache Iceberg metadata for Delta-based tables¶

With this release, we are pleased to announce support for writing metadata for Delta-based Iceberg tables to your external cloud storage.

For more information, see Changes to Apache Iceberg™ tables created from Delta files (Pending).

SELECT SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE('2025_01');