JSON

OBJECT_AGG

Snowflake

Fungsi aggregate yang membuat JSON object dari key-value pairs di multiple rows.

Tipe hasil: OBJECTDiperbarui: 6 Jan 2026

Syntax

SQL

OBJECT_AGG(key, value)

keyVARCHARwajib

Column atau expression untuk object keys

valueVARIANTwajib

Column atau expression untuk object values

SQL

1 SELECT
2   user_id,
3   OBJECT_AGG(setting_name, setting_value) as user_settings
4 FROM user_settings
5 GROUP BY user_id;

Membuat object settings per user dari rows.

Hasil

user_id	user_settings
1	{"theme": "dark", "language": "id", "notifications": "on"}
2	{"theme": "light", "language": "en"}

JSON_OBJECT_AGG

PostgreSQL

JSON_OBJECTAGG

MySQL

1	SELECT
2	user_id,
3	OBJECT_AGG(setting_name, setting_value) as user_settings
4	FROM user_settings
5	GROUP BY user_id;