JSON

JSON_ARRAY_LENGTH

BigQuery

Mengembalikan jumlah elemen dalam JSON array.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

JSON_ARRAY_LENGTH(json_expression)

json_expressionJSONwajib

JSON array

SQL

1 SELECT
2   JSON_ARRAY_LENGTH(JSON '[1, 2, 3]') as len,
3   JSON_ARRAY_LENGTH(JSON '[]') as empty_len;

Menghitung jumlah elemen array.

Hasil

len	empty_len
3	0

JSON_ARRAY_LENGTH

PostgreSQL

JSON_LENGTH

MySQL

ARRAY_SIZE

Snowflake

JSON_ARRAY_LENGTH

DuckDB

1	SELECT
2	JSON_ARRAY_LENGTH(JSON '[1, 2, 3]') as len,
3	JSON_ARRAY_LENGTH(JSON '[]') as empty_len;