FunctionsJSON

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

Kind · scalar

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

Part of the JSON family.

json_shared_data_paths_with_types

Analyzes JSON documents and returns the set of JSON paths observed. Shared-data variants focus on paths that share common prefixes or repeated structures across documents. Type variants also report…

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.