Generate date table BigQuery
select day as date_bk , day as date , cast ( day as datetime ) as date_time , cast ( day as timestamp ) as date_timestamp , format_date ( '%Y-%m-%d' , day ) as date_string , extract ( year from day ) AS year , extract ( quarter from day ) AS quarter , 'Q' || extract ( quarter from day ) AS quarter_string , extract ( month from day ) AS month , format_date ( '%B' , day ) AS month_string , format_date ( '%b' , day ) AS month_abbr_string , extract ( week from day ) AS week_sun , cast ( format_date ( '%W' , day ) as integer ) AS week_mon , extract ( isoweek from day ) AS iso_week , 'W' || format ( '%02d' , extract ( isoweek from day )) AS iso_week_string , extract ( day from day ) AS day_of_mon...