Semi-structured Data Functions

📄️ CHECK_JSON

Checks the validity of a JSON document.

Extracts value from an ARRAY by index, an OBJECT by field_name, or a VARIANT that contains either ARRAY or OBJECT.

Extracts value from an OBJECT by field_name, or a VARIANT that contains OBJECT.

Extracts value from an ARRAY, an OBJECT, or a VARIANT by path_name.

Interprets input JSON string, producing a VARIANT value