title: Use Sha vs md5 or Hash in Snowflake-db
body: <p>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 quickly check for unique records. My tables will be on the long side, in the range of 0.1 - 10 trillion rows. </p>
  
  <p>I am using a <a href="https://docs.snowflake.net/manuals/sql-reference/functions-string.html" rel="nofollow noreferrer">Snowflake datawarehouse</a>, and thus my options are SHA1, SHA2, MD5 (each with binary options), and <a href="https://docs.snowflake.net/manuals/sql-reference/functions/hash.html" rel="nofollow noreferrer">HASH</a>. </p>
  
  <p>I guess I would like to <strong>minimize the chance of collisions</strong> (given the long tables) while <strong>not burning my compute credits needlessly</strong>. </p>
  
  <p>Which one is the best option given my use case?</p>