---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-agg.md
cuppy_section: docs
cuppy_doc: 8RTP-K9VQ
cuppy_doc_uuid: d78e5545-da8e-45fb-b85d-86f2bca43aeb
cuppy_permalink: https://cuppy.io/salesforce/d/8RTP-K9VQ
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-agg
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: d28432a9a04a7edcaf2910e7a3dda2c85d6b739e09456902282ed1004f414c54
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-agg.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## `ARRAY_AGG`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Collects the input values from a group into an array using an optional, user-supplied order.

Use with `GROUP BY` to build one array per group:

*   `<value>`: The expression collected into the array. Its result type becomes the element type of the returned array.

*   `DISTINCT`: Keeps only distinct values. When you use `DISTINCT`, the `ORDER BY` expression (including its collation) must match `<value>`.
*   `ORDER BY <sort_expression> [, ...]`: Orders the elements within the array (an aggregate-local ordering). Each sort key accepts `ASC` / `DESC` and `NULLS FIRST` / `NULLS LAST`.
*   `NULL ON NULL`: Collects `NULL` inputs as `NULL` array elements. This is the default.
*   `ABSENT ON NULL`: Skips `NULL` inputs so they don’t appear in the array.

An array whose element type matches `<value>`.

**Null handling:**

*   With the default `NULL ON NULL`, `NULL` inputs are kept as `NULL` array elements.
*   With `ABSENT ON NULL`, `NULL` inputs are dropped. A group whose values are all `NULL` returns an empty array (`[]`).

*   `array_agg` keeps `NULL`s by default (`NULL ON NULL`).
*   The [`FILTER` clause](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/filter-clause.html) isn’t supported for `array_agg`.
*   When you combine `DISTINCT` with `ORDER BY`, the sort expression (and its collation) must match the aggregated value.
*   If no `ORDER BY` is specified, the resulting array has an implementation-defined, non-deterministic order.
*   `array_agg` with `ORDER BY` isn’t supported in combination with `ROLLUP`, `CUBE`, or `GROUPING SETS`.
*   To turn the resulting array into a delimited string, use [`ARRAY_TO_STRING`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-to-string.html). To expand an array back into rows, use [`UNNEST`](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/unnest.html).

Order the elements by `timestamp` and skip `NULL` events.

Returns `["started","completed"]`.

Without `ABSENT ON NULL`, `NULL` inputs are collected as `NULL` elements.

Returns `[1,NULL,3]`.

Build a sorted array of product names for each category.

*   [LISTAGG](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/listagg.html)
*   [JSON_ARRAYAGG](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/json-arrayagg.html)
*   [ARRAY_TO_STRING](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-to-string.html)
*   [UNNEST](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/unnest.html)
*   [array data type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array.html)
*   [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.html)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->