Maybe I’m just not finding it, but could not find a function for Array Size that simply returns an integer value with the number of elements in an array if the input is a 1-d array, or n-dimensional array for n+1 inputs (like ARRAY_SIZE in Snowflake).
I’d expect this to be a common ask
Hey @pedro, length should be what you’re looking for here:
1 Like
Oh wow, I tried that first and for some reason it gave me the string length and not the number of elements. Now I tried again and it works… I did find it weird that I couldn’t find such a standard functionality!
Thank you, solved!