Array functions overview

Sigma's array functions manage and manipulate arrays, or lists of homogenous values.

ArrayContains

Determines if the array (or list) contains the specified value; True or False.

ArrayDistinct

Returns the array without duplicate values.

ArrayLength

Determines the number of entries in an array, or list.

ArraySlice

Returns a portion of an array, defined by the starting index and length.

The following Window function also operates on arrays:

ArrayAgg

Aggregates a column's row values into a single array; one result for each window.