How to create a calendar table in Google BigQuer

How to create a calendar table in Google BigQuery

When aggregating data that jumps around by date, you may want a calendar table. You can create a calendar table in Google BigQuery with the …