UNNEST

All functions > CORE > UNNEST

Unnests an array of rows into a table of rows

Signatures

Returns: Unnested row

UNNEST(base: ARRAY<ROW>) → ROW

Notes

• Unnests an array of rows into a table of rows
• Each row in the input array becomes a row in the output table
• The output table has the same number of rows and columns as the input array
• The output table has the same column names and types as the input array