July 02-08, 2025 — 9.18 Release Notes

Attention

The release has completed. For differences between the in-advance and final versions of these release notes, see Release notes change log.

SQL updates

Snowflake Scripting output (OUT) arguments — General Availability

With this release, Snowflake Scripting supports output (OUT) arguments. When an output argument is specified in the definition of a Snowflake Scripting stored procedure, the stored procedure can return the current value of the output argument to a calling program, such as an anonymous block or a different stored procedure.

For more information, see Using arguments passed to a stored procedure.

Data pipeline updates

Dynamic tables: Support for externally managed Apache Iceberg™ tables — General Availability

You can now create dynamic tables that read from Iceberg tables that are managed by external catalogs. This is useful for processing data from external data lakes, without duplicating or ingesting the data into Snowflake.

For more information, see Create dynamic tables that read from Snowflake-managed or externally managed Apache Iceberg™ tables

Data governance updates

Data Quality: New system data metric function

A new system data metric function, ACCEPTED_VALUES, validates whether values in a column match a Boolean expression. When the ACCEPTED_VALUES function runs, it returns the number of records where the column value didn’t match the Boolean value, which can indicate a data quality issue.

For more information, see ACCEPTED_VALUES. For general information about system data metric functions, see Introduction to data quality and data metric functions.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

30-Jun-25

Dynamic tables: Support for externally managed Apache Iceberg™ tables

Added to Data pipeline updates section

03-Jul-2025