UNNEST

All functions > ARRAY_OF_ROWS > UNNEST

Unnests an array of rows into a table of rows

Syntax

UNNEST(base)
sql

Arguments

ParameterTypeRequiredDescription
baseARRAYROWYesArray of rows to unnest

Returns

ROW - Unnested row

Last update at: 2025/10/13 10:23:46