Snowflake Functions
Encryption Functions
Snowflake Functions
Encryption Functions
decrypt
decrypted binary string (return) Supported Signatures
function decrypt(binary, varchar) returns binary
function decrypt(binary, varchar, binary) returns binary
function decrypt(binary, varchar, binary, varchar) returns binary
function decrypt(binary, varchar) returns binary
function decrypt(binary, varchar, varchar) returns binary
function decrypt(binary, varchar, varchar, varchar) returns binary
decrypt_raw
decrypted binary string (return) Supported Signatures
function decrypt_raw(binary, binary) returns binary
function decrypt_raw(binary, binary, binary) returns binary
function decrypt_raw(binary, binary, binary, binary) returns binary
function decrypt_raw(binary, binary, binary, binary, varchar) returns binary
function decrypt_raw(binary, binary, binary, binary, varchar, binary) returns binary
encrypt
encrypted binary string including IV/nonce and AEAD tag (return) Supported Signatures
function encrypt(binary, varchar) returns binary
function encrypt(binary, varchar, binary) returns binary
function encrypt(binary, varchar, binary, varchar) returns binary
function encrypt(varchar, varchar) returns binary
function encrypt(varchar, varchar, binary) returns binary
function encrypt(varchar, varchar, binary, varchar) returns binary
function encrypt(binary, varchar) returns binary
function encrypt(binary, varchar, varchar) returns binary
function encrypt(binary, varchar, varchar, varchar) returns binary
function encrypt(varchar, varchar) returns binary
function encrypt(varchar, varchar, varchar) returns binary
function encrypt(varchar, varchar, varchar, varchar) returns binary
encrypt_raw
variant containing the encrypted binary string and additional data (return) Supported Signatures
function encrypt_raw(binary, binary) returns variant
function encrypt_raw(binary, binary, binary) returns variant
function encrypt_raw(binary, binary, binary, binary) returns variant
function encrypt_raw(binary, binary, binary, binary, varchar) returns variant
try_decrypt
decrypted binary string (return) Supported Signatures
function try_decrypt(binary, varchar) returns binary
function try_decrypt(binary, varchar, binary) returns binary
function try_decrypt(binary, varchar, binary, varchar) returns binary
function try_decrypt(binary, varchar) returns binary
function try_decrypt(binary, varchar, varchar) returns binary
function try_decrypt(binary, varchar, varchar, varchar) returns binary
try_decrypt_raw
decrypted binary string (return) Supported Signatures
function try_decrypt_raw(binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary, binary) returns binary
function try_decrypt_raw(binary, binary, binary, binary, varchar) returns binary
function try_decrypt_raw(binary, binary, binary, binary, varchar, binary) returns binary