array length in Athena

Hi,

You can calculate the length of the array in Athena using the CARDINALITY function [1].
Here's the basic syntax:

SELECT CARDINALITY(json_column_name) AS array_length
FROM your_table_name;

Reference:
[1] https://docs.aws.amazon.com/athena/latest/ug/finding-lengths.html

Thanks,
Atul