flatten_leaves pathexpression: col array or object, [suggesttypes: bool]?

Given an object or array input, recursively flatten all child elements into key-value columns, returning only leaf values.

The key and value child element columns are named '_c_NAME_path' and '_c_NAME_value'. NAME is replaced with the original column name.

Flatten_leaves is a less expensive operation than flatten or flatten_all. The default is to not suggest column types ('suggesttypes' = 'false'.) See also flatten, flatten_single, and flatten_all.

Categories

• Semistructured

Accelerable

flatten_leaves is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

flatten_leaves foo

Given this JSON in column foo:

flatten_leaves produces:

It recurses the JSON object and produce new columns that contain every leaf path and its corresponding value, without intermediate objects. Column 'foo' will be removed.

flatten_leaves foo, true

Given this JSON in column foo:

flatten_leaves produces:

It recurses the JSON object and produces new columns that contain every leaf path and its corresponding value, without intermediate objects. It will also attempt to determine the value's type, creating a third (hidden) column named '_c_foo_type'. Column 'foo' will be removed.