BASE64

This page describes the BASE64function in Lenses SQL.

BASE64(expr)

Returns the input string using base64 algorithm.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

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

Output:

{
  "value": {
    "BASE64": "Y2M1M2MzYjNiMGI5NjY4MDQ1NzNjZWI5MTczOTA1MTBkZTk1NzQyZDdjYWYzZDc0NzQ4NzJmZDE3ZjAxZjQyOA==",
    "password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
  }
}