AS_NULLABLE

This page describes the AS_NULLABLE function in Lenses SQL.

AS_NULLABLE(expr)

Returns the provided value with its type changed from the original type to its nullable version.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT AS_NULLABLE(modified_at) AS null_value 
FROM users-events
LIMIT 100;

Output:

{
  "value": {
    "null_value": null
  }
}

In case you want to know more about nullability scenarios, see here.