ARRAY_FIRST

Returns the first element in the given array for which the given function returns true. The <function> parameter must be included.

Syntax

ARRAY_FIRST(<function>, <array>)

Parameter	Description	Supported input types
`<function>`	A Lambda function used to check elements in the array	A Lambda function returning `BOOLEAN`
`<array>`	The array evaluated by the function	Any array

The element type of <array>

The following example returns the first value in the levels array greater than 2:

SELECT
	ARRAY_FIRST(x -> x > 2, [ 1, 2, 4, 9 ]) AS levels;

Returns: 4

⌘I