Array

UNNEST

BigQuery

Mengubah array menjadi set of rows (flatten array).

Tipe hasil: Table of TDiperbarui: 7 Jan 2026

Syntax

SQL

UNNEST(array_expression) [WITH OFFSET]

array_expressionARRAY<T>wajib

Array untuk di-unnest

WITH OFFSETmodifieropsional

Menambahkan kolom offset (index)

SQL

1 SELECT element
2 FROM UNNEST(['a', 'b', 'c']) as element;

Mengubah array menjadi rows.

Hasil

SQL

1 SELECT element, idx
2 FROM UNNEST(['a', 'b', 'c']) as element WITH OFFSET as idx;

Flatten dengan index.

Hasil

UNNEST

PostgreSQL

FLATTEN

Snowflake

UNNEST

DuckDB

1	SELECT element, idx
2	FROM UNNEST(['a', 'b', 'c']) as element WITH OFFSET as idx;