Array functions overview

Array functions manage and manipulate arrays (lists of indexed values).

ArrayReturns an array containing specified values.
ArrayContainsSearches for a specific value in an array. If the value is found, the function returns True, otherwise it returns False.
ArrayDistinctReturns the array without duplicate values.
ArrayLengthDetermines the number of entries in an array, or list.
ArraySliceReturns a portion of an array, defined by the starting index and length.

The following aggregate function also creates arrays:

ArrayAggJoin the values of a group or column into a single array