Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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