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.

Parses a JSON string and returns a JSON value.

Analyze Syntax

func.parse_json('{"a":1}')

Analyze Examples

func.parse_json('{"a": 1}')

┌─────────────┐
│ JSON object │
└─────────────┘

SQL Syntax

PARSE_JSON('{"a":1}')

SQL Examples

SELECT PARSE_JSON('{"name": "Alice"}');

┌──────────────────┐
│ {"name":"Alice"} │
└──────────────────┘