ARRAY_LENGTH

Returns the length of an array.

Syntax

ARRAY_LENGTH( <array> )

Aliases

• ARRAY_SIZE

Examples

SELECT 
    ARRAY_LENGTH(['apple', 'banana', 'cherry']) AS item_count,
    ARRAY_SIZE(['apple', 'banana', 'cherry']) AS item_count_alias;

┌───────────────────────────────┐
│ item_count │ item_count_alias │
├────────────┼──────────────────┤
│          3 │                3 │
└───────────────────────────────┘