Utility & Hash Functions

Snowflake provides utility functions that return information, such as descriptions of the statements used to create database objects.

Snowflake also provides hash functions, which take input value(s) and return a signed 64-bit numeric value. Hash functions are deterministic. Snowflake provides both a scalar hash function and an aggregate hash function, both of which are listed here.

Note

The hash functions are not cryptographic hash functions.

For cryptographic functions, use the SHA families of functions (see String & Binary Functions).

Function Name

Notes

GET_DDL

HASH

HASH_AGG

Aggregate function.