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/11/06 07:00:15
Last updated: 2025-11-06 07:00:51