---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-generate-series.md
cuppy_section: docs
cuppy_doc: 9YHY-QBDF
cuppy_doc_uuid: 6fb1ce9b-26a2-4f5e-8612-523a9aef72cd
cuppy_permalink: https://cuppy.io/salesforce/d/9YHY-QBDF
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-generate-series
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: da877a66586d54213ef1e622001dc60652255bc8deb303b5e989848f43add2b6
# 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-generate-series.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_GENERATE_SERIES` (Numerical)

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

Creates an array of sequential values within a range.

*   `<start>`: The starting value of the sequence.
*   `<stop>`: The ending value of the sequence (inclusive).

*   `<step>`: The increment between values. The default is 1.

Returns an array that contains sequential values from `start` to `stop`, incrementing by `step`.

*   If you use a negative step, make sure `<start>` is greater than `<stop>`. If `<start>` is less than or equal to `<stop>`, the function returns an empty array.
*   A negative step generates a descending sequence. A positive step generates an ascending sequence.
*   This function is equivalent to the [generate_series (Numerical)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series.html) function but returns an array instead of a set of rows.
*   Both the `start` and `stop` values are included in the generated series.
*   The step size must be non-zero.
*   The step size can also be negative. For negative step sizes, `start` must be greater than `stop`.
*   For positive step sizes, if `start` is greater than `stop`, the function returns no rows.
*   For negative step sizes, if `start` is less than `stop`, the function returns no rows.
*   If any input is `null`, the function returns no rows.

Create an array of integers from 1 to 5.

Returns `[1, 2, 3, 4, 5]`.

Create an array of integers from 1 to 5 with step 2.

Returns `[1, 3, 5]`.

Create an array counting down from 5 to 1 in increments of 2.

Returns `[5, 3, 1]`.

Create a descending array with decimal values.

Returns `[3.7, 3.4, 3.1]`.

When the step direction doesn’t match the range direction, an empty array is returned.

Returns `[]`.

The examples in [generate_series examples](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series.html#examples) apply to `array_generate_series`.

*   [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array.html)
*   [`ARRAY_GENERATE_SERIES` (Time-based)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-generate-series-time.html) - the time-based version of this function
*   [`generate_series` (Numerical)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series.html) - the set-returning version of this function


---
<!-- 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 -->