Can I denormalize (by joining) multiple large tables in bigquery?
Table1 is 400M rows Table2 is 2M rows Table3 is 800K rows
If not, do I have to do it in my relational database before I upload? That would be a difficult solution.
Should I chunk the tables into smaller pieces and run iterations of joins over the tables so that it is always large to small? This would also be a difficult solution.
Thank you.
