10.25 Release Notes: Jul 17, 2026 - Jul 22, 2026¶

SQL updates¶

Session variable size limit increased to 16KB¶

The maximum size for string and binary session variables has been increased from 256 bytes to 16KB. This allows you to store larger string values in session variables without workarounds such as chunking or storing values in temporary tables.

For more information, see SQL variables.

Object definition size limit increased to 1MB¶

The maximum size for object definitions has been increased from 95KB to 1MB. This applies to tables, views, UDFs, and stored procedures.

For more information, see CREATE VIEW.

VARIANT and structured types: Support for UUID and DECFLOAT values¶

You can now store UUID and DECFLOAT values in semi-structured data (VARIANT) and in structured types (ARRAY, OBJECT, and MAP). You can also explicitly cast these values to and from VARIANT using TO_VARIANT, TO_UUID, and TO_DECFLOAT. Storing UUID and DECFLOAT values in Apache Iceberg™ VARIANT (v3) columns isn’t supported.

For more information, see UUID data type and Numeric data types.

New function: FORMAT_STRING_TEMPLATE¶

The FORMAT_STRING_TEMPLATE function formats a string by substituting placeholders with values, providing type-aware string interpolation. Placeholders use curly braces {} with optional format specifications for number precision, padding, and alignment.

For more information, see FORMAT_STRING_TEMPLATE.

Data lake updates¶

Apache Iceberg™ tables: Support for the UNKNOWN data type (Preview)¶

Snowflake now supports the UNKNOWN primitive data type defined by the Apache Iceberg™ v3 specification. Use it to define an Iceberg column or field whose type isn’t known yet. An UNKNOWN column has no physical storage and always reads as NULL.

For more information, see UNKNOWN data type.

Snowpark updates¶

Java 21 support for Snowpark (Preview)¶

The Snowpark API for Java and Scala now supports Java 21 in addition to Java 11 and Java 17.

For more information, see Prerequisites for Snowpark Java and Prerequisites for Snowpark Scala.

Release notes change log¶