1 of 1

LAST3

This page describes the LAST3 function in Lenses SQL.

LAST3(strExpr)

Anonymize the value and only keep the last three characters.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "first_name_hidden": "*****nda",
    "first_name": "Brenda"
  }
}

This page describes the LAST3 function in Lenses SQL.

LAST3(strExpr)

Anonymize the value and only keep the last three characters.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "first_name_hidden": "*****nda",
    "first_name": "Brenda"
  }
}