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
IS_VALID_JSON function
IS_VALID_JSON_ARRAY function
JSON_ARRAY_LENGTH function
JSON_EXTRACT_ARRAY_ELEMENT_TEXT function
JSON_EXTRACT_PATH_TEXT function
Javascript is disabled or is unavailable in your browser.
To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.