Generate Date Array BigQuery
with generate_months as (
SELECT * FROM
UNNEST(GENERATE_DATE_ARRAY('2020-01-01', '2021-12-1', INTERVAL 1 MONTH)) AS dates
)
select 1 as key, left(cast(dates as string),7) as yearmonth
from generate_months
