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 following GENERATE_DATE_ARRAY()" creates a calendar array, and "UNNEST()" expands the array to rows to make it a table. SELECT * FROM UNNEST( GENERATE_DATE_ARR…
