JSON Functions

2 functions for extracting values from and parsing JSON strings. The source column is always the implicit first input.

FunctionSyntaxParametersNotes
json_extract / get_json_objectjson_extract(column, path)path default "$.value" — JSONPath expression.Returns the extracted value as a string.
json_parse / from_jsonjson_parse(column, schema)schema — required DDL schema string (e.g. "name STRING, age INT").Returns a struct column matching the given schema.