Link Search Menu Expand Document

ARRAY_CONCAT

Combines one or more arrays that are passed as arguments.

Syntax

ARRAY_CONCAT(<array> [, ...n])

Parameters

Parameter Description Supported input types
<array> [, ...n] The arrays to be combined. If only one array is given, an identical array is returned. ARRAY

Return Type

ARRAY of the same type as the input arrays

Example

In the following example, two arrays are combined to show all of the levels in a particular game:

SELECT
    ARRAY_CONCAT([ 1, 2, 3, 4 ], [ 5, 6, 7, 8, 9, 10 ]) AS levels;

Returns: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]