According to this announcement, Google BigQuery now supports SHA256 encryption calls in SQL (bypassing the previous need to use embedded JavaScript.) However, the documentation for the function isn't yet live according to the post.
We tried "SELECT SHA256('string_value')..." but the function is not recognized.
Anyone have early knowledge on what is the correct syntax for SHA256 encryption on BigQuery?
This new function is supported in Standard SQL mode only!