JSON_PARSE function - Amazon Redshift
SyntaxArgumentsReturn typeExample
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

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)