May 23-28, 2025 — 9.14 Release Notes

Attention

The release has completed. For differences between the in-advance and final versions of these release notes, see Release notes change log.

New features

Trust Center: In-app notifications — Preview

With this release, you receive Trust Center notifications in Snowsight about accounts that haven’t enrolled in multi-factor authentication (MFA).

SQL updates

Search optimization: Support for Apache Iceberg™ tables

With this release, search optimization can improve the performance of queries on Iceberg tables. To configure search optimization for an Iceberg table, use ALTER ICEBERG TABLE … ADD SEARCH OPTIMIZATION.

For more information, see Support for Apache Iceberg™ tables in the search optimization documentation.

Query Acceleration Service: Support for Apache Iceberg™ tables

With this release, we are pleased to announce support for the Query Acceleration Service (QAS) for Iceberg tables. The QAS accelerates scan performance and inserts on Iceberg tables. When you use a QAS-enabled warehouse to query an Iceberg table, QAS accelerates the query if it’s eligible for acceleration.

As a result of this change, QAS might incur additional credits.

For more information, see Using the Query Acceleration Service.

Data types: Structured types support for standard Snowflake tables — Preview

With this release, you can define a structured type column in a standard Snowflake table.

Note

Structured types are generally available for Apache Iceberg™ tables. Structured types aren’t supported for dynamic, hybrid, or external tables.

For more information, see Structured data types

Data pipeline updates

Triggered tasks: Support for streams hosted on directory tables and data shares

With this release, you can now use Triggered Tasks to call stored procedures whenever there are changes in a stream hosted on a directory table or data share.

If the directory table is configured to auto-refresh, the triggered task runs automatically. Otherwise, in order to trigger the task, you must also refresh the directory table metadata manually, for example: ALTER STAGE my_stage REFRESH.

For more information, see Triggered tasks.

Data lake updates

Apache Iceberg™ tables: Row-level deletes for externally managed tables — General availability

With this release, we are pleased to announce general availability of row-level deletes support with positional delete files when external engines perform update, delete, and merge operations on externally managed Iceberg tables in Snowflake.

For more information, see Use row-level deletes.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

27-May-25

Trust Center: In-app notifications — Preview

Added to New features section

28-May-25