Tus datos, diseñados
para la claridad estratégica.

with subscriptions as (
    select * from {{ ref('stg_stripe_subscriptions') }}
),

monthly_revenue as (
    select
        customer_id,
        date_trunc('month', created_at) as revenue_month,
        sum(amount) as mrr
    from subscriptions
    where status = 'active'
    group by 1, 2
)

select * from monthly_revenue