Text-based JSON functions

The following functions parse JSON values as VARCHAR. For parsing JSON, we recommend you instead use the following functions, which parse JSON values as SUPER. Amazon Redshift parses SUPER values more efficiently than VARCHAR.

• JSON_PARSE function

• CAN_JSON_PARSE function

• JSON_SERIALIZE function

• JSON_SERIALIZE_TO_VARBYTE function

Topics

• IS_VALID_JSON function
• IS_VALID_JSON_ARRAY function
• JSON_ARRAY_LENGTH function
• JSON_EXTRACT_ARRAY_ELEMENT_TEXT function
• JSON_EXTRACT_PATH_TEXT function