Constantin Lungudatawise.dev·Mar 31, 2024Enumerating ARRAY elements in BigQuery using WITH OFFSETIn a previous post we've covered what ARRAYS are in BigQuery, their use cases and how to flatten them with UNNEST. Quite important to mention, ARRAYS are ordered collections (like lists in Python) - you set up that order when creating it. By UNNESTIN...50 readsPractical BigQuerybigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.