Joinless fact tables in Google BigQuery (storing facts at the transaction header level)
There's information out there in the wild indicating that best practices for Google BigQuery involves using nesting and repeated columns...
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.