Let me preface by saying that I am not using this for storing passwords or any other sensitive info -- I simply want a row-level sha/hash that I can use later or to check for unique records. My tables will be on the long side, in the range of 0.1 - 10 trillion rows.
I am using a Snowflake datawarehouse, and thus my options are SHA1, SHA2, MD5 (each with binary options), and HASH.
I guess I would like to minimize the chance of collisions (given the long tables) while not burning my compute credits needlessly.
Which one is the best option given my use case?