ARRAY_LENGTH

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the total number of elements in an array.

1ARRAY_LENGTH(<array>)

• <array>: The array to measure.

Returns an integer that represents the total number of elements in the array.

• Returns the count of all elements including NULL and duplicate values.
• For an empty array, returns 0.

Determine the number of elements in an array.

1SELECT ARRAY_LENGTH(array[1, 2, 3]) AS element_count;

Returns 3, counting all elements in the array.

• Array Data Type