1 of 13

Obfuscation

This page describes how to use obfuscation functions in Lenses SQL Processors.

ANONYMIZE

This page describes the ANONYMIZE function in Lenses SQL.

Obfuscates the entire string input.

Available in:

Processors

SQL Studio

Sample code:

Output:

MASK

This page describes the MASK function in Lenses SQL.

MASK(strExpr)

Alias for ANONYMIZE.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

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

EMAIL

This page describes the EMAIL function in Lenses SQL.

Anonymize the value and obfuscate an email address.

Available in:

Processors

SQL Studio

Sample code:

Output:

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"
  }
}

FIRST2

This page describes the FIRST2 function in Lenses SQL.

Anonymize the value and only keep the first two characters.

Available in:

Processors

SQL Studio

Sample code:

Output:

FIRST3

This page describes the FIRST3 function in Lenses SQL.

FIRST3(strExpr)

Anonymize the value and only keep the first three characters.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

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

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"
  }
}

LAST1

This page describes the LAST1 function in Lenses SQL.

Anonymize the value and only keep the last character.

Available in:

Processors

SQL Studio

Sample code:

Output:

LAST2

This page describes the LAST2 function in Lenses SQL.

LAST2(strExpr)

Anonymize the value and only keep the last two characters.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

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

LAST3

This page describes the LAST3 function in Lenses SQL.

Anonymize the value and only keep the last three characters.

Available in:

Processors

SQL Studio

Sample code:

Output:

LAST4

This page describes the LAST4 function in Lenses SQL.

Anonymize the value and only keep the last four characters.

Available in:

Processors

SQL Studio

Sample code:

Output:

INITIALS

This page describes the INITALS function in Lenses SQL.

Anonymize the value and only keep the initials of all the words in the input.

Available in:

Processors

SQL Studio

Sample code:

Output: