Semi-structured Data Functions

📄️ As_<Type>

Strict casting VARIANT values to other data types.

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.

Extracts value from a Json string by path_name.

Returns an array containing the list of keys in the input object.

Interprets input JSON string, producing a VARIANT value