Array functions overview

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


Array	Returns an array containing specified values.
ArrayContains	Searches for a specific value in an array. If the value is found, the function returns `True`, otherwise it returns `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 aggregate function also creates arrays:


ArrayAgg	Join the values of a group or column into a single array