FunctionsJSON

json_typeof

Returns the JSON type of the input value (object, array, string, number, boolean, or null). Use this for schema discovery and conditional extraction.

json_typeof(…) → String

Kind · scalar

Returns the JSON type of the input value (object, array, string, number, boolean, or null). Use this for schema discovery and conditional extraction.

Part of the JSON family.

json_type

Returns the JSON type of the input value (object, array, string, number, boolean, or null). Use this for schema discovery and conditional extraction.

json_value

Extracts a scalar textual value from a JSON input. This version supports direct scalar extraction and root path '$'.