Link Search Menu Expand Document

ARRAY_UNNEST (deprecated)

ARRAY_UNNEST is deprecated. Instead, we recommend using the UNNEST clause in a SELECT statement. For more information and examples, see SELECT.

This function “unfolds” a given array by creating a column result containing the individual members from the array’s values.

Syntax

ARRAY_UNNEST(<arr>)
Parameter Description
<arr> The array to be unfolded.

Example

SELECT
	ARRAY_UNNEST([ 1, 2, 3, 4 ]) AS res;

Returns:

res
1
2
3
4