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: 2026/01/19 16:14:19
Last updated: 2026-01-19 16:14:54