stripe_invoices_transformed_2.sql

days as (

  select (min(period_start) over () + row_number() over ())::date as date_day
  from invoices

), months as (

  select distinct date_trunc('month', date_day)::date as date_month
  from days
  where date_day <= current_date

),