Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

DUMP

This page describes the DUMP function in Lenses SQL.

DUMP(expr)

Show the internal representation of a value.

Available in:

Processors
SQL Studio

✓

✓

Sample code:

USE `kafka`;
SELECT 
    DUMP(id) AS dump_id,
    DUMP(users_id) AS dump_users_id,
    DUMP(created_at) AS dump_created_at,
    DUMP(modified_at) AS dump_modified_at,
    DUMP(email) AS dump_email,
    DUMP(first_name) AS dump_first_name,
    DUMP(last_name) aAS s dump_last_name
FROM users-events
WHERE modified_at IS NULL
LIMIT 1;

Output:

{
  "value": {
    "dump_id": "io.lenses.sql.model.StringValue@StringValue(8c8b3c3a-7fa9-43bd-a8d2-1290e3940e49)",
    "dump_users_id": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_created_at": "io.lenses.sql.model.StringValue@StringValue(2023-10-29T22:20:50.010963)",
    "dump_modified_at": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_email": "io.lenses.sql.model.StringValue@StringValue(Brenda.Pierce@hotmail.com)",
    "dump_first_name": "io.lenses.sql.model.StringValue@StringValue(Brenda)",
    "dump_last_name": "io.lenses.sql.model.StringValue@StringValue(Pierce)"
  }
}

Last updated

Was this helpful?