Functions/Lists & arrays/flatten
Lists & arrays Scalar

flatten()

Flattens a nested list by one level.

Arguments & returns

flatten(nested_list)

Scalar
Overload link nested_list Returns
#01 T[][] T[]

Example

flatten example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

BigQuery

SELECT ARRAY_CONCAT_AGG(arr) FROM (SELECT [1, 2] AS arr) AS t
In DuckDB
SELECT FLATTEN(ARRAY_AGG(arr) FILTER(WHERE NOT arr IS NULL)) FROM (SELECT [1, 2] AS arr) AS t

SQLGlot example ↗

Snowflakearray_flatten()

SELECT ARRAY_FLATTEN([[]])
In DuckDB
SELECT FLATTEN([[]])

SQLGlot example ↗