The correct method to flat tables
BigQuery is an analytics engine optimized to crunch pre-joined (or: nested) information. Sub-relations make sense in analytical situations as a result of we don’t wish to cope with joins over larger datasets — simply think about day by day year-over-year comparisons during the last 3 years, aggregating Terabytes of knowledge — however with joins including one other layer of…