DECODE64
This page describes the DECODE64 function in Lenses SQL.
Decodes a Base64 encrypted string.
Available in:
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"
}
}