Skip to main content
Returns the number of elements in the array column accumulated over all rows. As such it is an aggregate function.

​
Syntax

ARRAY_COUNT_GLOBAL(<array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array column over which the function will count the elements.Any ARRAY type

​
Return Type

INTEGER

​
Example

For this example, we will create a table levels as shown below. This table will highlight the levels that a certain player has completed. 
CREATE DIMENSION TABLE levels(esimpson ARRAY(INTEGER));

INSERT INTO
	levels
VALUES
	([ 1, 2, 3, 4 ]),
	([ 5, 0, 20 ]),
	([ 6, 2, 6 ]),
	([ 9, 10, 13 ]),
	([ 20, 13, 40 ]),
	([ 1 ]);
We can use ARRAY_COUNT_GLOBAL to learn how many total array elements are in all rows for the user esimpson. 
SELECT
	ARRAY_COUNT_GLOBAL(esimpson)
FROM
	levels;
Returns: 17 If you want to count elements based on specific criteria, you can use the ARRAY_COUNT function with a SUM aggregation as demonstrated below. 
SELECT
	SUM(ARRAY_COUNT(x -> x > 3, esimpson))
FROM
	levels;
Returns: 11
⌘I