Preview — 9.19 Release Notes¶

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.

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;