Skip to main content
Version: current

AES_DECRYPT

Categories: Cryptography

AES_DECRYPT

Decrypts a string produced by AES encryption.

Syntax​

AES_DECRYPT(ciphertext varchar, key varchar) → varchar​

  • ciphertext: The string to be decrypted.
  • key: The key to use to decrypt the ciphertext.

Examples

AES_DECRYPT example
SELECT AES_DECRYPT(UNBASE64('Fad52k2P1Y6rMZ0DBcg8SQ=='), 'mypassword')
-- Dremio