Skip to main content
Version: current [26.x]

Categories: Cryptography

AES_DECRYPT

Decrypts a string produced by AES encryption. Deprecated on Dremio Software: Will be removed from Dremio Software in a future release. Dremio recommends DECRYPT on Dremio Software for improved security and support for modern cipher modes.

Syntax​

AES_DECRYPT(ciphertext varchar, key varchar) → varchar​

  • ciphertext: The string to be decrypted.
  • key: The key to use to decrypt the ciphertext. Must be 16, 24, or 32 characters.

Examples

AES_DECRYPT example 
SELECT AES_DECRYPT(UNBASE64('UvicDn/xiUDmfSE+KYjjyw=='), 'mypassword123456')
-- Dremio