> JOINs are a non-trivial problem with data in the terabyte-to-petabyte range. but that benchmark is 250G, plus all established players I think support joins w

> JOINs are a non-trivial problem with data in the terabyte-to-petabyte range. but that benchmark is 250G, plus all established players I think support joins well, I work with BQ closely and it works very well. > So just because you can do query-time JOINs doesn't mean you should if you haven't thought about it ahead of time. prebuilding denormalized table can significantly increase your datasize, so it is tradeoff and depends on your data structure and cardinality.