Hash functions

Snowflake 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

HASH

HASH_AGG

Aggregate function.

Language: English