AES_DECRYPT
Learn how to use the AES_DECRYPT cryptographic function in PlaidCloud Lakehouse. Decrypts a value encrypted with AES - see syntax, examples, and output.
Cryptographic Functions
This section provides reference information for the cryptographic functions in PlaidCloud Lakehouse.
AES_ENCRYPT
Learn how to use the AES_ENCRYPT cryptographic function in PlaidCloud Lakehouse. Encrypts a value using AES encryption - see syntax, examples, and output.
BASE64_DECODE_BINARY
Learn how to use the BASE64_DECODE_BINARY cryptographic function in PlaidCloud Lakehouse. Decodes a base64-encoded string to a binary value.
BASE64_DECODE_STRING
Learn how to use the BASE64_DECODE_STRING cryptographic function in PlaidCloud Lakehouse. Decodes a base64-encoded string to a VARCHAR string.
FROM_BASE64
Learn how to use the FROM_BASE64 cryptographic function in PlaidCloud Lakehouse. Decodes a base64-encoded string. Alias for BASE64_DECODE_STRING.
MD5
Learn how to use the MD5 cryptographic function in PlaidCloud Lakehouse. Returns the MD5 hash of a string as a 32-character hexadecimal string.
MD5SUM
Learn how to use the MD5SUM cryptographic function in PlaidCloud Lakehouse. Returns the MD5 hash of multiple strings concatenated together.
MD5SUM_NUMERIC
Learn how to use the MD5SUM_NUMERIC cryptographic function in PlaidCloud Lakehouse. Returns the MD5 hash of multiple strings as a 128-bit numeric value.
SHA2
Learn how to use the SHA2 cryptographic function in PlaidCloud Lakehouse. Returns the SHA-2 hash of a string for a specified bit length (224, 256, 384, or 512).
SM3
Learn how to use the SM3 cryptographic function in PlaidCloud Lakehouse. Returns the SM3 hash of a string - see syntax, examples, and output.
TO_BASE64
Learn how to use the TO_BASE64 cryptographic function in PlaidCloud Lakehouse. Encodes a string to a base64-encoded string - with syntax and examples.