Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

GET_ARRAY_LENGTH function

Returns the length of a SUPER array given an object or array path.

Syntax

GET_ARRAY_LENGTH( super_expr )

Arguments

Return type

The GET_ARRAY_LENGTH function returns an INT.

Example

The following example shows the GET_ARRAY_LENGTH function.

SELECT GET_ARRAY_LENGTH(ARRAY(1,2,3,4,5,6,7,8,9,10));
 get_array_length
----------------------
            10
(1 row)