title: How to create sha256 hash with salt
body: <p>I would like to migrate hash generation to BigQuery which has <code>SHA256</code>, but does not have salt as parameter. </p>
  
  <p>For example in <code>R</code> I can do something like this:</p>
  
  <pre class="lang-r prettyprint-override"><code>library(openssl)
  sha256("test@gmail.com", key = "111")
  # [1] "172f052058445afd9fe3afce05bfec573b5bb4c659bfd4cfc69a59d1597a0031"
  </code></pre>
  
  <p><strong>Update</strong></p>
  
  <p>same with python based on an answer <a href="https://stackoverflow.com/questions/58384610/how-to-reproduce-an-sha256-based-hmac-from-r-in-python-3/">here</a>:</p>
  
  <pre class="lang-py prettyprint-override"><code>import hmac
  import hashlib
  print(hmac.new(b"111", b"test@gmail.com", hashlib.sha256).hexdigest())
  # 172f052058445afd9fe3afce05bfec573b5bb4c659bfd4cfc69a59d1597a0031
  </code></pre>