Learning Google BigQuery

Using partition tables in your projects

Partitioned tables are mainly used to improve performance and reduce billing costs. Most reporting application queries include filters by date range, and in that case, partition tables will be highly helpful. Partition tables are not just for raw data tables or historical tables; they should also be used in aggregate tables and staging tables. 

The daily data loading jobs should load data into specified partitions, and in case of any cleanup or reloading, that individual partition can be deleted without affecting other partitions and reloading the data. This can be done concurrently for multiple partitions. Tables that are used as staging tables to load data temporarily and delete it after some period ...