SQL · JSON functions

json_tree

Walks a JSON document into rows with key, value, type and path.

sqlRunnable example sql course

Syntax

json_tree(json)

Example

Open in the lab

SELECT key, value FROM json_tree('{"a":1}');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.