SQL · JSON functions

json_type()

The type of a JSON value: object, array, text, integer, real, true, false or null.

sqlRunnable example sql course

Syntax

json_type(json, path)

Example

Open in the lab

SELECT json_type('{"a":[1]}', '$.a') AS kind;

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