ARRAY_AGG

The sole aggregation for arrays takes all the values in a column and aggregates them into one field.

Parameter	Type
`arg`	any

Returns: array

Example

Arrays are currently only supported on tables from a live connection to an Athena database. You cannot use them with other databases or with tables derived from an Athena database.

query:

SELECT ARRAY_AGG(country_id)
  FROM city_array

returns:

array_agg
UK, SG, US, CN, CH, BR, NL, IN, IT, AU, CA, JP, DE