In BigQuery the MD5 hash function by default stores the hash as type BYTES which results in the following output for our example:
op6QlI9O7lIWj6tfqc+8+A==
If you want to get the actual hash you need to use the TO_HEX()
function which outputs:
a29e90948f4eee52168fab5fa9cfbcf8
QueryStash
Created: Oct 7th 2020