Using GAPS_FILL in BigQuery

Another new time series function in BigQuery in addition to the ones previously presented is the GAPS_FILL table-valued function. It allows us to fill in a time series (DATE, DATETIME, TIMESTAMP) with missing rows to a desired time grain. Previously,...