Snowflake

COMPARE WHETHER TWO TABLES CONTAIN THE SAME DATA OR NOT USING HASH_AGG IN SNOWFLAKE.

Snowflake has one cool function called HASH_AGG which returns a 64 bit signed hash value over the set of inputs column. As the snowflake document itself mentioned, “HASH_AGG is not a cryptographic hash function and should not be used as such”. We can use it to compare whether two columns or sets of columns value are identical or not.