This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

FLATTEN

Converts an array of arrays into a flat array. This means 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(<array>)

Parameters

Return Type

ARRAY of the same type as the input array

Example

The following example flattens multiple arrays of level IDs:

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

Returns: [1, 2, 2, 3, 3, 4]