BASE64
This page describes the BASE64function in Lenses SQL.
Returns the input string using base64 algorithm.
Available in:
Sample code:
USE `kafka`;
SELECT
BASE64(password_hash),
password_hash
FROM users-topic
LIMIT 1;
Output:
{
"value": {
"BASE64": "Y2M1M2MzYjNiMGI5NjY4MDQ1NzNjZWI5MTczOTA1MTBkZTk1NzQyZDdjYWYzZDc0NzQ4NzJmZDE3ZjAxZjQyOA==",
"password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
}
}