9.24 Release notes: Aug 18, 2025-Aug 20, 2025

Attention

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

Security updates

Self-service activation of Tri-Secret Secure (General availability)

Self-service activation of Tri-Secret Secure is now generally available and is no longer in Preview.

Customers with the ACCOUNTADMIN role can activate Tri-Secret Secure for their Snowflake account using system functions without requiring Snowflake support. The self-service procedure also supports deactivating Tri-Secret Secure and simplifies working with your customer managed key (CMK).

For more information, see Self-service Tri-Secret Secure in Snowflake.

SQL updates

ALTER LISTING command to simplify adding and removing targets (General availability)

You can now add or remove targets (accounts, roles, and organizations) from a listing without passing all of the existing targets. With this release, the ALTER LISTING command allows you to provide a manifest section that contains only the targets you want to add or remove. This partial manifest reuses the familiar structures targets, external_targets, and organization_targets, which are already defined in the listing manifest reference.

New features

Snowflake Native App Framework - MONITOR privilege support for apps (General availability)

The Snowflake Native App Framework supports granting the MONITOR privilege on an app to a user role or to another app. To grant the MONITOR privilege, run the following commands:

GRANT MONITOR ON APPLICATION <app_name> TO ROLE <app_user>;
GRANT MONITOR ON APPLICATION <app_name> TO APPLICATION <other_app_name>;
Copy

The MONITOR privilege allows the grantee to run the following commands:

DESC APPLICATION <app_name>;
DESC SPECIFICATION SPEC IN APPLICATION <app_name>;
SHOW APPROVED SPECIFICATIONS IN APPLICATION <app_name>;
SHOW OBJECTS OWNED BY APPLICATION <app_name>;
SHOW REFERENCES IN APPLICATION <app_name>;
SHOW SPECIFICATIONS IN APPLICATION <app_name>;
Copy

The owner of the app has privileges to run these commands by default. The MONITOR privilege allows the app owner to delegate monitoring of an app to a user role or another app.

Data lake updates

Set a target file size for Apache Iceberg™ tables (Preview)

You can now set a target Parquet file size for Iceberg tables. Doing so improves cross-engine query performance when you use an external Iceberg engine such as Apache Spark, Delta, or Trino that’s optimized for larger file sizes. You can set the target file size when you create a table, or update it later by using the ALTER ICEBERG TABLE command. For more information, see Set a target file size.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

Aug 15, 2025

Snowflake Native App Framework: MONITOR privilege support for apps

Added to New features

Aug 21, 2025

Set a target file size for Apache Iceberg™ tables (Preview)

Added to Data lake updates

Aug 21, 2025

Self-service activation of Tri-Secret Secure (General availability)

Added to Security updates

Aug 21, 2025

ALTER LISTING command to simplify adding and removing targets (General availability)

Added to SQL updates

Aug 21, 2025