Semi-Structured Functions

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

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

JSON Data Manipulation:

• JSON_ARRAY
• JSON_STRIP_NULLS

Object Operations:

• GET
• GET_IGNORE_CASE
• GET_PATH
• OBJECT_KEYS

Type Conversion:

• AS_TYPE