GET_JSON_BOOL
Learn how to use the GET_JSON_BOOL json function in PlaidCloud Lakehouse. Extracts a boolean value from a JSON object by a specified path.
JSON Functions
This section provides reference information for the JSON functions in PlaidCloud Lakehouse.
GET_JSON_DOUBLE
Learn how to use the GET_JSON_DOUBLE json function in PlaidCloud Lakehouse. Extracts a double value from a JSON object by a specified path.
GET_JSON_INT
Learn how to use the GET_JSON_INT json function in PlaidCloud Lakehouse. Extracts an integer value from a JSON object by a specified path.
GET_JSON_OBJECT
Learn how to use the GET_JSON_OBJECT json function in PlaidCloud Lakehouse. Extracts a JSON object from a JSON string by a specified path.
GET_JSON_STRING
Learn how to use the GET_JSON_STRING json function in PlaidCloud Lakehouse. Extracts a string value from a JSON object by a specified path.
JSON_ARRAY
Learn how to use the JSON_ARRAY json function in PlaidCloud Lakehouse. Creates a JSON array from a list of values - see syntax, examples, and output.
JSON_CONTAINS
Learn how to use the JSON_CONTAINS json function in PlaidCloud Lakehouse. Checks whether a JSON document contains a specific value at a path.
JSON_EACH
Learn how to use the JSON_EACH json function in PlaidCloud Lakehouse. Expands the top-level JSON object into a set of key-value pairs.
JSON_EXISTS
Learn how to use the JSON_EXISTS json function in PlaidCloud Lakehouse. Checks whether a JSON document contains a value at a specified path.
JSON_KEYS
Learn how to use the JSON_KEYS json function in PlaidCloud Lakehouse. Returns the keys of the top-level JSON object as a JSON array - with syntax and examples.
JSON_LENGTH
Learn how to use the JSON_LENGTH json function in PlaidCloud Lakehouse. Returns the number of elements in a JSON object or array - with syntax and examples.
JSON_OBJECT
Learn how to use the JSON_OBJECT json function in PlaidCloud Lakehouse. Creates a JSON object from key-value pairs - see syntax, examples, and output.
JSON_PRETTY
Learn how to use the JSON_PRETTY json function in PlaidCloud Lakehouse. Formats a JSON value with indentation for readability - with syntax and examples.
JSON_QUERY
Learn how to use the JSON_QUERY json function in PlaidCloud Lakehouse. Extracts a JSON value from a JSON document using a path expression.
JSON_REMOVE
Learn how to use the JSON_REMOVE json function in PlaidCloud Lakehouse. Removes an element from a JSON document at a specified path - with syntax and examples.
JSON_SET
Learn how to use the JSON_SET json function in PlaidCloud Lakehouse. Sets a value in a JSON document at a specified path - see syntax, examples, and output.
JSON_STRING
Learn how to use the JSON_STRING json function in PlaidCloud Lakehouse. Converts a JSON value to a JSON-encoded string - see syntax, examples, and output.
PARSE_JSON
Learn how to use the PARSE_JSON json function in PlaidCloud Lakehouse. Parses a JSON string and returns a JSON value - see syntax, examples, and output.
TO_JSON
Learn how to use the TO_JSON json function in PlaidCloud Lakehouse. Converts a SQL value to a JSON value - see syntax, examples, and output.