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.
Extracts a JSON object from a JSON string by a specified path.
Analyze Syntax
func.get_json_object(get_column(table, 'data'), '$.address')
Analyze Examples
func.get_json_object(get_column(table, 'data'), '$.address')
┌─────────────┐
│ JSON object │
└─────────────┘
SQL Syntax
GET_JSON_OBJECT(<data>, '$.address')
SQL Examples
SELECT GET_JSON_OBJECT('{"address":{"city":"NYC"}}', '$.address');
┌────────────────┐
│ {"city":"NYC"} │
└────────────────┘