title: BigQuery SHA256 function
body: <p>I need to hash some strings using <code>SHA256</code>.  Using <code>BigQuery</code> to do this results in what I understand to be a <code>BASE64</code> result, where as I need something that is different.  </p>
  
  <p>For example, if I want to hash "def@gmail.com" the result should be:</p>
  
  <blockquote>
    <p>c392e50ebeca7bea4405e9c545023451ac56620031f81263f681269bde14218b</p>
  </blockquote>
  
  <p>But doing this in <code>BigQuery</code>: </p>
  
  <pre><code>SELECT SHA256("def@gmail.com") as sha256;
  </code></pre>
  
  <p>the result is: </p>
  
  <blockquote>
    <p>w5LlDr7Ke+pEBenFRQI0UaxWYgAx+BJj9oEmm94UIYs=</p>
  </blockquote>
  
  <p>It's the first result that I need to get, any ideas if this is possible in <code>BigQuery</code>, I'm trying to avoid needing to use <code>javascript</code> for this.</p>