Snowflake Native Apps: changes to hash values (Preview)¶

Attention

This behavior change is in the 2025_02 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the following changes will be implemented:

The values of the following shared events on the provider side will change:
- snow.application.hash
- snow.database.hash
- snow.query.hash
The hash value of the APPLICATION_NAME_HASH column of the DATA_SHARING_USAGE.LISTING_ACCESS_HISTORY will change.
The application hash value of the APPLICATION_OBJECTS_ACCESSED column in the DATA_SHARING_USAGE.LISTING_ACCESS_HISTORY will change.

Before the change:: Snowflake uses SHA1 to calculate the hash value of query id, app name, or database name. A consumer could call the native SHA1() function to calculate the hash value.
After the change:: Snowflake uses HMAC to calculate the hash value of query id, app name, or database name. The consumer must call the SYSTEM$GET_HASH_FOR_APPLICATION function to calculate the hash value.

Ref: 1901