Table functions

Functions that return rows instead of a single value, such as exploding arrays or generating ranges.

Function	Type	What it does
`explode`	Table	Expands each ARRAY element or MAP entry into a row.
`explode_outer`	Table	Expands each ARRAY element or MAP entry into a row, preserving empty/NULL inputs as one NULL row.
`generator`	Table	Produces the specified number of rows with zero visible columns.
`inline`	Table	Expands ARRAY<STRUCT> elements into rows with one output column per struct field.
`inline_outer`	Table	Expands ARRAY<STRUCT> elements into rows with one output column per struct field.
`json_tuple`	Table	Extracts JSON paths into generated STRING columns.
`posexplode`	Table	Expands each ARRAY element or MAP entry into a row.
`range`	Table	Generates an exclusive-end sequence of BIGINT values.
`stack`	Table	Splits row-major values into a fixed number of generated rows.

Last modified on October 15, 2026