FunctionsJSON

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_type(…) → 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_strip_nulls

Returns a JSON object with keys whose value is JSON null removed. This is useful for cleaning documents before export or hashing.

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.