FIRST4

This page describes the FIRST4 function in Lenses SQL.

FIRST4(strExpr)

Anonymize the value and only keep the first four characters.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
 FIRST4(first_name) AS first_name_hidden,
  first_name 
FROM users-events
LIMIT 1;

Output:

{
  "value": {
    "first_name_hidden": "Char*****",
    "first_name": "Charles"
  }
}