How to use Backfill: the Time Machine for Scheduled Queries in BigQuery
How to retroactively run Big Data analytics jobs in BigQuery
I love BigQuery and I used it in a number of Big Data projects. I like its flexibility, the powerful query language (including the possibility to query external sources) and the many built-in functionalities.