SHA

​

Syntax

​

Scalar

sha(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: A 40-character lowercase hexadecimal digest.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Usage notes

• An empty string hashes to da39a3ee5e6b4b0d3255bfef95601890afd80709.

​

Examples

​

Value and NULL input

SELECT sha('abc') AS digest, sha(CAST(NULL AS STRING)) AS null_value;

​

Hash empty text

SELECT sha('') AS digest;