get_array_length function - Amazon Redshift

Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

get_array_length function

Returns the length of the specified array. The GET_ARRAY_LENGTH function returns the length of a SUPER array given an object or array path.

Syntax

get_array_length( super_expr )

Arguments

super_expr

A valid SUPER expression of array form.

Return type

The get_array_length function returns a BIGINT.

Example

The following example shows a 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)