JSON

OBJECT_DELETE

Snowflake

Menghapus satu atau lebih key dari OBJECT.

Tipe hasil: OBJECTDiperbarui: 6 Jan 2026

Syntax

SQL

OBJECT_DELETE(object, key1 [, key2, ...])

objectOBJECTwajib

Object yang akan dimodifikasi

keyVARCHARwajib

Key untuk dihapus

SQL

1 SELECT OBJECT_DELETE(
2   PARSE_JSON('{"name": "John", "age": 30, "temp": "x"}'),
3   'temp'
4 ) as cleaned;

Menghapus key temp.

Hasil

{"name":"John","age":30}

1	SELECT OBJECT_DELETE(
2	PARSE_JSON('{"name": "John", "age": 30, "temp": "x"}'),
3	'temp'
4	) as cleaned;