9.25 Release notes: Aug 25, 2025-Aug 28, 2025¶

Sensitive data classification: Automatic classification of a database (General availability)¶

You can now set a classification profile on a database so that all tables and views within the database are automatically classified for sensitive data.

For more information, see Set a classification profile on a database.

Support for keys generated with Elliptic Curve Digital Signature Algorithms (ECDSA)¶

For Snowflake authentication methods that use a cryptographic key (key-pair authentication and External OAuth), you can now generate keys using Elliptic Curve Digital Signature Algorithms (ECDSA) algorithms ES256(P-256), ES384 (P-384), and ES512 (P-512). These signatures use the SHA-256, SHA-384, and SHA-512 hash algorithms, respectively.

Querying semantic views (General availability)¶

The ability to query semantic views is now generally available and is no longer in Preview.

You can use a SELECT statement to query a semantic view by specifying the SEMANTIC_VIEW clause. In this clause, you specify the dimensions and metrics that you want to retrieve. You can also filter the results based on dimensions.

For information, see Querying semantic views.

Semantic views: Listing facts in a view, schema, database, or account¶

To list the facts in a semantic view, schema, database, or account, run the SHOW SEMANTIC FACTS command.

For information, see SHOW SEMANTIC FACTS.

Semantic views: Support for renaming views¶

You can use ALTER SEMANTIC VIEW … RENAME TO … to rename a semantic view.

For information, see ALTER SEMANTIC VIEW.

Apache Iceberg™ tables: Row-level deletes for externally managed tables (General availability)¶

Snowflake supports row-level deletes with positional delete files for externally managed Iceberg tables. Iceberg engines can perform update, delete, and merge operations on these tables using both copy-on-write and merge-on-read modes. This expands interoperability between Snowflake and external tools that manage Iceberg table data, and ensures consistent behavior across different compute engines.

For more information, see Use row-level deletes.

Data quality: Updated privilege model allows non-owners to associate a data metric function with an object¶

Users with the SELECT privilege on a table or view can associate it with a data metric function (DMF) to set up a data quality check. Previously, only the owner of the table or view could associate a DMF.

As part of this change, an association between a DMF and an object has a new property: EXECUTE AS ROLE. This property specifies which role the DMF runs with.

For more information, see Required privilege on the table or view.

Object tags: New limit for allowed values¶

The ALLOWED_VALUES property of a tag controls which values someone can associate with the tag when they set it on an object. This list of allowed values can now include 5,000 values. Previously, the limit was 300.

For more information, see Set a list of allowed tag values.