Categories:

System functions (System Information)

SYSTEM$GET_HASH_FOR_APPLICATION

Returns the hash value for a Snowflake Native App or query ID.

Syntax

SYSTEM$GET_HASH_FOR_APPLICATION( '<app_name>' [ , '<query_id>' ] )

Arguments

Required

'app_name'

The name of the app whose hash value you want to return.

Optional:

'query_id'

The query ID whose hash value you want to return.

Returns

Returns a signed 64-bit hash value. If a query ID is passed as an argument to this function, this function returns the hash value of the query ID. Otherwise, it returns the hash value for the app.

Examples

The following example returns the hash value for the app ‘hello_snowflake_app’:

SELECT SYSTEM$GET_HASH_FOR_APPLICATION('hello_snowflake_app');
+--------------------------------------------------------+
| SYSTEM$GET_HASH_FOR_APPLICATION('HELLO_SNOWFLAKE_APP') |
|--------------------------------------------------------|
| a1b2c3d4e5fg+1234567890+1234
+--------------------------------------------------------+

The following example returns the hash value for a query id associated with the app ‘hello_snowflake_app’:

SELECT SYSTEM$GET_HASH_FOR_APPLICATION('hello_snowflake_app', 'abcd1234-12345-WXYZ-0000-0987654321');
+------------------------------------------------------------------------------------------------+
| SYSTEM$GET_HASH_FOR_APPLICATION('HELLO_SNOWFLAKE_APP', '<app_id>') |
|------------------------------------------------------------------------------------------------|
| a1b2c3d4e5fg+1234567890+1234                                                                   |
+------------------------------------------------------------------------------------------------+