Preview — 9.13 Release Notes

Attention

Content in this page is available in advance of the completion of the 9.13 release, which is currently either pending or in progress.

The release is scheduled to complete on May 14 (subject to change).

Features, updates, or behavior changes described in this page might not become available in your account(s) until the completion of the release.

For updates to these release notes, see Release notes change log.

Security updates

Outbound private connectivity for AWS Government regions

You can use AWS PrivateLink for outbound network traffic originating from AWS Government regions.

SQL updates

Pipe operator

With this release, you can use the new pipe operator (->>) to chain SQL statements together. In the chain of SQL statements, the results of one statement can serve as the input to another statement. The pipe operator can simplify the execution of dependent SQL statements and improve the readability and flexibility of complex SQL operations.

Data loading/unloading updates

INFER_SCHEMA function: Support for Apache Iceberg™ data types

With this release, you can now automatically retrieve the column definitions for Apache Iceberg data types from a set of staged data files that contain semi-structured data. To retrieve these column definitions, set the new KIND argument for the INFER_SCHEMA function to ICEBERG.

With this new feature, you can use the CREATE ICEBERG TABLE … USING TEMPLATE variant syntax to create an Iceberg table with the column definitions derived from INFER_SCHEMA using the KIND=>’ICEBERG’ output.

Data lake updates

Cross-cloud/cross-region support for Snowflake-managed Apache Iceberg™ tables

With this release, Snowflake supports cross-cloud/cross-region writes (and reads) to Iceberg tables that use Snowflake as the catalog. In the DATA_TRANSFER_HISTORY view, the cross-region data transfer charges for these tables appear as a TRANSFER_TYPE of DATA_LAKE.

In addition, you can now convert a cross-cloud/cross-region Iceberg table that uses an external catalog to use Snowflake as the catalog.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

09-May-25