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 objects.

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.

Note

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:

List of Hash Functions

Function Notes
HASH Scalar
HASH_AGG Aggregate

List of Utility Functions

Function
GET_DDL