DECODE64

This page describes the DECODE64 function in Lenses SQL.

DECODE64(expr)

Decodes a Base64 encrypted string.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    DECODE64(password_hash),
    password_hash 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "DECODE64": "q�wsv�oF���4���q�������tu�y�����������;��u��5��",
    "password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
  }
}