Array

GENERATE_ARRAY

BigQuery

Membuat array berisi sequence of numbers.

Tipe hasil: ARRAY<INT64> or ARRAY<FLOAT64>Diperbarui: 7 Jan 2026

Syntax

SQL

GENERATE_ARRAY(start, end [, step])

startINT64/FLOAT64wajib

Nilai awal sequence

endINT64/FLOAT64wajib

Nilai akhir sequence (inclusive)

stepINT64/FLOAT64opsional

Increment (default: 1)

Default: 1

SQL

1 SELECT
2   GENERATE_ARRAY(1, 5) as one_to_five,
3   GENERATE_ARRAY(0, 10, 2) as evens,
4   GENERATE_ARRAY(5, 1, -1) as descending;

Membuat berbagai sequences.

Hasil

one_to_five	evens	descending
[1,2,3,4,5]	[0,2,4,6,8,10]	[5,4,3,2,1]

1	SELECT
2	GENERATE_ARRAY(1, 5) as one_to_five,
3	GENERATE_ARRAY(0, 10, 2) as evens,
4	GENERATE_ARRAY(5, 1, -1) as descending;