[ad_1]
The right option to flat tables
![Martin Weitzmann](https://miro.medium.com/v2/resize:fill:88:88/1*k2EEGL79HN3MiTzQABN1QA.jpeg)
![Towards Data Science](https://miro.medium.com/v2/resize:fill:48:48/1*CJe3891yB1A1mzMdqemkdg.jpeg)
BigQuery is an analytics engine optimized to crunch pre-joined (or: nested) knowledge. Sub-relations make sense in analytical situations as a result of we don’t wish to take care of joins over larger datasets — simply think about day by day year-over-year comparisons during the last 3 years, aggregating Terabytes of information — however with joins including one other layer of…
[ad_2]
Source link