1 of 1

FIRST1

This page describe the FIRST1 function in Lenses SQL.

FIRST1(strExpr)

Anonymize the value and only keep the first character.

Available in:

Processors

SQL Studio

✓

Sample code:

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

Output:

{
  "value": {
    "first_name_hidden": "M*****",
    "first_name": "Melissa"
  }
}