The first time I encountered the BigQuery export schema this year my heart sank: arrays and structs were not something covered in my SQL intro course! But having spent a few months extracting data like this I've come to appreciate the logic. These are all the 'notes to self' I wish I'd had at the... Continue Reading →