Constantin Lungudatawise.dev·Mar 31, 2024Accessing ARRAY elements in BigQuerySo 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...1 like·74 readsPractical BigQuerybigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.