JSON Functions
2 functions for extracting values from and parsing JSON strings. The source column is always the implicit first input.
| Function | Syntax | Parameters | Notes |
|---|---|---|---|
json_extract / get_json_object | json_extract(column, path) | path default "$.value" — JSONPath expression. | Returns the extracted value as a string. |
json_parse / from_json | json_parse(column, schema) | schema — required DDL schema string (e.g. "name STRING, age INT"). | Returns a struct column matching the given schema. |