BigQuery

The right solution to flat tablesBigQuery is an analytics engine optimized to crunch pre-joined (or: nested) data. Sub-relations make sense in analytical scenarios because we don’t wish to take care of joins over larger...

Clustering: A straightforward technique to group similar rows and forestall unnecessary data processingIn my previous article, I explained the way to optimise SQL queries using partitioning:Now, I’m writing the sequel! (Dad joke, anyone?)This text...