Refactoring BigQuery public datasets pt. 1: nested and repeated in FDA food_events
Data munging is one of the most time consuming exercises in the data analysis process. It's not unheard of to spend 90% of the effort in...
Ideas, tips and tricks
I've been working with and building data warehouses for almost twenty years. In 2021, I began working with Google BigQuery, due to it's simplicity and low barrier of entry. This blog is from the perspective of moving from a traditional data warehouse to GBQ.