You can unnest Array or Object values into separate rows or columns using the following transformations.
Array values can be flattened into individual values in separate rows.
You can also split out the individual values in an array into separate columns.
The following example illustrates how flatten and unnest can be used together to reshape your data.
This example shows how you can unnest Object data into separate columns. The example contains vehicle identifiers, and the
Properties column contains key-value pairs describing characteristics of each vehicle.
This example shows how to extract values (for example, hashtag values) from a column and convert them into a column of arrays.
provides multiple methods for transforming tabular data into nested Arrays and Objects. For more information on nesting data, see Nest Your Data.