JSON_PARSE function - Amazon Redshift

JSON_PARSE function

The JSON_PARSE function parses data in JSON format and converts it into the SUPER representation.

To ingest into SUPER data type using the INSERT or UPDATE command, use the JSON_PARSE function.

Syntax

JSON_PARSE(json_string)

Arguments

json_string

An expression that returns serialized JSON in the varchar form.

Return type

SUPER

Example

The following example is an example of the JSON_PARSE function.

SELECT JSON_PARSE('[10001,10002,"abc"]'); json_parse -------------------------- [10001,10002,"abc"] (1 row)
SELECT JSON_TYPEOF(JSON_PARSE('[10001,10002,"abc"]')); json_typeof ---------------- array (1 row)