JSON_SIZE function - Amazon Redshift
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 (PDF).

JSON_SIZE function

The JSON_SIZE function returns the number of bytes in the given SUPER expression when serialized into a string.

Syntax

JSON_SIZE(super_expression)

Arguments

super_expression

A SUPER constant or expression.

Return type

INTEGER

The JSON_SIZE function returns an INTEGER indicating the number of bytes in the input string. This value is different from the number of characters. For example, the UTF-8 character ⬤, a black dot, is 3 bytes in size even though it is 1 character.

Usage notes

JSON_SIZE(x) is functionally identical to OCTET_LENGTH(JSON_SERIALIZE). However, note that JSON_SERIALIZE returns an error when the provided SUPER expression would exceed the VARCHAR limit of the system when serialized. JSON_SIZE does not have this limitation.

Examples

To return the length of a SUPER value serialized to a string, use the following example.

SELECT JSON_SIZE(JSON_PARSE('[10001,10002,"⬤"]')); +-----------+ | json_size | +-----------+ | 19 | +-----------+

Note that the provided SUPER expression is 17 characters long, but ⬤ is a 3-byte character, so JSON_SIZE returns 19.