Semi-Structured Functions
This section provides reference information for the semi-structured data functions in Databend.
JSON Parsing, Conversion & Type Checking:
- CHECK_JSON
- JSON_PRETTY
- JSON_TYPEOF
- PARSE_JSON
- FLATTEN
- IS_ARRAY
- IS_BOOLEAN
- IS_FLOAT
- IS_INTEGER
- IS_NULL_VALUE
- IS_OBJECT
- IS_STRING
JSON Query and Extraction:
- JSON_ARRAY_ELEMENTS
- JSON_EACH
- JSON_EXTRACT_PATH_TEXT
- JSON_PATH_EXISTS
- JSON_PATH_MATCH
- JSON_PATH_QUERY
- JSON_PATH_QUERY_ARRAY
- JSON_PATH_QUERY_FIRST
- JQ