The right solution to flat tables

BigQuery is an analytics engine optimized to crunch pre-joined (or: nested) data. Sub-relations make sense in analytical scenarios because we don’t need to take care of joins over greater datasets — just imagine each day year-over-year comparisons during the last 3 years, aggregating Terabytes of knowledge — but with joins adding one other layer of…