Constantin Lungudatawise.devยทJun 8, 2024The relationship between ARRAY_AGG and UNNESTIf you're working with nested data in BigQuery, you've might've seen UNNEST, which helps 'unpack' arrays into individual rows. But there's also ARRAY_AGG, which, if you haven't encountered it before, which takes all rows for your GROUP BY bucket an...55 readsPractical BigQuerySQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.