Array functions - Firebolt Documentation

Preview BigQuery array functions in BigQuery compatibility mode. See also the Firebolt Arrays guide.

Function	Support	Notes
`ARRAY`	Supported	Array subquery and constructor.
`UNNEST`	Supported	Table-valued. Expands an array to rows, including `WITH OFFSET AS alias`.
`ARRAY_CONCAT`	Supported
`ARRAY_LENGTH`	Supported
`ARRAY_FIRST`	Supported
`ARRAY_REVERSE`	Supported
`ARRAY_TO_STRING`	Supported
`ARRAY_SLICE`	With limitations	Firebolt indexes by offset and length, whereas BigQuery uses start and end positions, so results differ.
`GENERATE_ARRAY`	Supported
`GENERATE_DATE_ARRAY`	With limitations	Step must be a whole number of days.
`ARRAY_LAST`	Not supported
`GENERATE_TIMESTAMP_ARRAY`	Not supported

Array construction and access

Construct	Notes
`[e1, e2, ...]`	Array literal.
`ARRAY<T>[e1, e2, ...]`	Typed array literal.
`array[OFFSET(n)]`, `array[ORDINAL(n)]`	Element access, 0-based and 1-based.

BigQuery arrays cannot contain NULL elements. Firebolt allows them, so a NULL element does not raise the error BigQuery would. See Data types.

⌘I