Returns the length of the given array, i.e., how many elements it contains. Produces NULL for NULL arrays. Alias: LENGTH (when used with an array argument)

​
Syntax

ARRAY_LENGTH(<array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array whose length should be calculatedARRAY

​
Return Type

INTEGER

​
Example

SELECT
	ARRAY_LENGTH([ 1, 2, 3, 4 ]) AS levels;
Returns: 4 
SELECT
	ARRAY_LENGTH([ [ 1, 2, 3 ], [ 4, 5, 6, 7 ]) AS levels;
Returns: 2