SHA2 (Lakehouse v2)
Returns the SHA-2 hash of a string for a specified bit length (224, 256, 384, or 512).
Analyze Syntax
Section titled “Analyze Syntax”func.sha2(<str>, <bit_length>)Analyze Examples
Section titled “Analyze Examples”func.sha2('hello', 256)
┌───────────────┐│ '2cf24dba...' │└───────────────┘SQL Syntax
Section titled “SQL Syntax”SHA2(<str>, <bit_length>)SQL Examples
Section titled “SQL Examples”SELECT SHA2('hello', 256);
┌──────────────────────────────────────────────────────────────────┐│ 2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824 │└──────────────────────────────────────────────────────────────────┘