Skip to main content
Returns an array of all non-null values in the specified column, preserving the input order. Category: aggregate Syntax:
ArrayAgg([column])
Returns: ArrayColumn Context Filtering: ✗ No

Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column whose values are aggregated into an array.

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

ArrayAgg([Score])
Returns an array of all Score values.
Last modified on March 13, 2026