Generating date intervals in BigQuery

Ever had to generate a date interval in BigQuery? Take a look at the GENERATE_DATE_ARRAY function. Needs 3 arguments:- start_date- end_date- interval step (DAY, WEEK, MONTH, QUARTER, YEAR) Since it generates an ARRAY, we would need to UNNEST it to ge...