Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
更新しました 2024/07/26
Send us feedback
get_json_object
Applies to: Databricks SQL Databricks Runtime
Extracts a JSON object from path.
path
get_json_object(expr, path)
expr: A STRING expression containing well formed JSON.
expr
path: A STRING literal with a well formed JSON path.
A STRING.
If the object cannot be found null is returned.
> SELECT get_json_object('{"a":"b"}', '$.a'); b
json_tuple table-valued generator function