Link Search Menu Expand Document

FLATTEN

Converts an array of arrays into a flat array. That is, for every element that is an array, this function extracts its elements into the new array. The resulting flattened array contains all the elements from all source arrays.

The function:

  • Applies to any depth of nested arrays.
  • Does not change arrays that are already flat.

Syntax

FLATTEN(<arr_of_arrs>)
Parameter Description
<arr_of_arrs> The array of arrays to be flattened.

Example

SELECT
	flatten([ [ [ 1, 2 ] ], [ [ 2, 3 ], [ 3, 4 ] ] ])

Returns: (1, 2, 2, 3, 3, 4)