Semi-Structured Functions

This section provides reference information for the semi-structured data functions in Databend.

JSON Parsing and Conversion:

• CHECK_JSON
• JSON_PRETTY
• JSON_TYPEOF
• PARSE_JSON

JSON Query and Extraction:

• JSON_EXTRACT_PATH_TEXT
• JSON_PATH_EXISTS
• JSON_PATH_QUERY
• JSON_PATH_QUERY_ARRAY
• JSON_PATH_QUERY_FIRST

JSON Data Manipulation:

• JSON_ARRAY
• JSON_STRIP_NULLS

Object Operations:

• GET
• GET_IGNORE_CASE
• GET_PATH
• OBJECT_KEYS

Type Conversion:

• AS_TYPE