1 of 1

EMAIL

This page describes the EMAIL function in Lenses SQL.

EMAIL(emailExpr)

Anonymize the value and obfuscate an email address.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
 EMAIL(email) AS email_hidden,
 email 
FROM users-events
LIMIT 1;

Output:

{
  "value": {
    "email_hidden": "B*****@hotmail.com",
    "email": "Brenda.Pierce@hotmail.com"
  }

This page describes the EMAIL function in Lenses SQL.

EMAIL(emailExpr)

Anonymize the value and obfuscate an email address.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
 EMAIL(email) AS email_hidden,
 email 
FROM users-events
LIMIT 1;

Output:

{
  "value": {
    "email_hidden": "B*****@hotmail.com",
    "email": "Brenda.Pierce@hotmail.com"
  }