Link Search Menu Expand Document

ARRAY_COUNT

Returns the number of elements in the <arr> array that match a specified function <func>. If you want only a count of the elements in an array without any conditions, we recommend using the LENGTH function instead.

Syntax

ARRAY_COUNT(<func>, <arr>)
Parameter Description
<func> Optional. A Lambda function used to check elements in the array. If <func> is not included, ARRAY_COUNT will return a count of all non-false elements in the array.
<arr> An array of elements

Examples

The example below searches through the array for any elements that are greater than 3. Only one number that matches this criteria is found, so the function returns 1

SELECT
	ARRAY_COUNT(x -> x > 3, [ 1, 2, 3, 9 ]) AS res;

Returns: 1

In this example below, there are no <func> criteria provided in the ARRAY_COUNT function. This means the function will count all of the non-false elements in the array. 0 is not counted because it evaluates to FALSE

SELECT
	ARRAY_COUNT([ 0, 1, 2, 3 ]) AS res;

Returns: 3