ARRAY_SIZE

ARRAY_SIZE(array)

Returns the size of array, size includes inner elements that are NULL``. ReturnsNULLif array isNULL`. See here for Snowflake documentation.