Jun 09-11, 2025 — 9.15 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.

Security updates¶

Malicious IP Protection¶

Malicious IP Protection service automatically protects all types of Snowflake accounts by blocking network access and login attempts that originate from known, malicious IP addresses. It is enabled by default and does not require any configuration by administrators.

For more information, see Malicious IP Protection.

SQL updates¶

UNION BY NAME operator¶

This release introduces the UNION BY NAME operator. You can use this operator to combine rows by name instead of by position. When rows are combined with UNION BY NAME, and a column exists in one input but not the other, it is filled with NULL values in the combined result set for each row where it’s missing.

For more information, see Set operators.

Data pipeline updates¶

Support for streams on unmanaged Apache Iceberg™ tables with row-level deletes¶

You can now create streams on unmanaged Iceberg tables with row-level deletes.

For more information, see Insert-only streams.

Release notes change log¶

Announcement	Update	Date
Release notes	Initial publication (preview)	06-Jun-25
Snowflake Scripting output (OUT) arguments — General availability	Removed from SQL Updates section	10-Jun-25
Support for streams on unmanaged Apache Iceberg™ tables with row-level deletes	Added to Data pipeline updates section	11-Jun-25