JSON

JSON_TYPE

BigQuery

Mengembalikan tipe dari nilai JSON (object, array, string, number, boolean, null).

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

JSON_TYPE(json_expression)

Parameter

json_expressionJSONwajib

Nilai JSON untuk dicek tipenya

Contoh Penggunaan

Check JSON Types

SQL

1 SELECT
2   JSON_TYPE(JSON '{"a": 1}') as obj_type,
3   JSON_TYPE(JSON '[1, 2]') as arr_type,
4   JSON_TYPE(JSON '"hello"') as str_type,
5   JSON_TYPE(JSON '123') as num_type,
6   JSON_TYPE(JSON 'null') as null_type;

Mengidentifikasi tipe berbagai nilai JSON.

Hasil

obj_type	arr_type	str_type	num_type	null_type
object	array	string	number	null

Fungsi Equivalen di Database Lain

JSON_TYPEOF

PostgreSQL

JSON_TYPE

MySQL

TYPEOF

Snowflake

JSON_TYPE

DuckDB

Fungsi Terkait

JSON_ARRAY_LENGTHJSON_KEYS

Kembali ke BigQuery Functions

1	SELECT
2	JSON_TYPE(JSON '{"a": 1}') as obj_type,
3	JSON_TYPE(JSON '[1, 2]') as arr_type,
4	JSON_TYPE(JSON '"hello"') as str_type,
5	JSON_TYPE(JSON '123') as num_type,
6	JSON_TYPE(JSON 'null') as null_type;