Accessing ARRAY elements in BigQuery

So here's 3 ways we can access elements in a BigQuery array. - by index: array[index], starting at 0- using OFFSET(index): array[OFFSET(index)], also starting at 0- using ORDINAL(1-based index)), starting at 1 The above will return an "index out of r...