9.35 Release Notes: Nov 03, 2025-Nov 07, 2025¶

Interval data types (Preview)¶

Interval data types store values that represent a duration of time. You can calculate an interval as the difference between two dates or times. An interval only defines a duration, so it doesn’t have a start or end point in time. For example, you might define an interval as three years and seven months.

This release adds support for several new interval data types, including INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND.

For more information, see Interval data types.

Replicate Snowflake-managed Apache Iceberg™ tables (Preview)¶

You can now replicate Snowflake-managed Apache Iceberg™ tables from a source account to one or more target accounts in the same organization. This replication is integrated seamlessly with Snowflake replication and failover groups to provide point-in-time consistency for the objects on the target account.

For more information, see Configure replication for Snowflake-managed Apache Iceberg™ tables.