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>' ] )

Copy

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¶

SELECT SYSTEM$GET_HASH_FOR_APPLICATION('hello_snowflake_app');

Copy

Output:

+--------------------------------------------------------+
| SYSTEM$GET_HASH_FOR_APPLICATION('HELLO_SNOWFLAKE_APP') |
|--------------------------------------------------------|
| yksY1823VLDNSbwRW3LrIuI+sfUII                          |
+--------------------------------------------------------+

SELECT SYSTEM$GET_HASH_FOR_APPLICATION('hello_snowflake_app', '01bafe06-3210-d462-0000-04150406931a');

Copy

+------------------------------------------------------------------------------------------------+
| SYSTEM$GET_HASH_FOR_APPLICATION('HELLO_SNOWFLAKE_APP', '01bafe06-3210-d462-0000-04150406931a') |
|------------------------------------------------------------------------------------------------|
| nGEP/JvFhc9a7r41p+y98hUx6Q=                                                                    |
+------------------------------------------------------------------------------------------------+