Preview — 9.19 Release Notes

Attention

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

The release is scheduled to complete on July 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.

SQL updates

Data types: Structured types support for standard Snowflake tables — General Availability

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

Note

Structured types aren’t supported for dynamic, hybrid, or external tables.

Data loading / unloading updates

Optimize data ingestion with pre-clustering for Snowpipe Streaming - high-performance architecture

With this release, we are pleased to announce a new feature for Snowpipe Streaming with high-performance architecture (Preview) that enables pre-clustering of your data directly during ingestion. This helps to significantly improve query performance on your target tables by ensuring data is sorted before it’s committed.

To use this feature, your target table must be configured with clustering keys defined. You can then enable this behavior within your Snowpipe Streaming definition using the new CLUSTER_AT_INGEST_TIME option in your COPY INTO statement, as the following example shows.

CREATE OR REPLACE PIPE TEST_PRECLUSTERED_PIPE
AS
    COPY INTO TEST_PRECLUSTERED_TABLE (num) FROM (
            SELECT $1:num::number as num FROM TABLE(
                DATA_SOURCE(
                    TYPE => 'STREAMING')
        ))
        CLUSTER_AT_INGEST_TIME=TRUE;
Copy

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

09-Jul-25