Generating a Numbers Table in MySQL and Redshift

Looker Q&A Looker
8

For BigQuery, a new native method (GENERATE_DATE_ARRAY):
SELECT date FROM UNNEST(GENERATE_DATE_ARRAY(DATE_SUB(CURRENT_DATE, INTERVAL 5 YEAR), CURRENT_DATE)) date