Utility and Hash Functions¶
Snowflake provides utility functions such as
GET_DDL, which provide
information such as descriptions of the statements used to create database
Snowflake also provides hash functions, which take an 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 described here.
These hash functions are not cryptographic hash functions.
For cryptographic functions, use use the MD5 or the SHA families of functions (see String & Binary Functions).
In this Topic: