github fivetran/dbt_stripe v1.4.0
v1.4.0 dbt_stripe

6 hours ago

PR #138 includes the following updates:

Schema/Data Change

3 total change • 0 possible breaking changes

Data Model(s) Change type Old New Notes
stripe__subscription_item_mrr_report New End Model Each record represents a subscription item for a given month with MRR metrics for both contract and billed/net mrr, movement classification, and monthly discounts applied. Tracks MRR changes over time, classifying each month as new, expansion, contraction, churned, reactivation, or unchanged. If you notice any discrepencies in MRR calculations with this new model, please open up a support ticket.
stg_stripe__coupon New Staging Model Staging model for Stripe coupon data.
stg_stripe__coupon_tmp New Temp Model
stg_stripe__price_plan Datatype casts recurring_interval field as string
recurring_interval_count field as integer
price_plan_id field as string
Avoids datatype errors.
stg_stripe__subscription_item Datatype casts plan_id field as string Avoids datatype errors.

Feature Update

  • Adds new analyses folder with advanced revenue reporting:
    • stripe__arr_snapshot_analysis: Generates a high-level ARR snapshot report for the entire business for revenue forecasting.
    • stripe__customer_mrr_analysis: Generates an MRR report at the customer level for retention reporting and cohort analysis.
    • These analysis files reference the stripe__subscription_item_mrr_report model and can be compiled using dbt compile and executed directly in your data warehouse.

Documentation

  • Adds comprehensive column documentation for stripe__subscription_item_mrr_report in stripe.yml.
  • Adds README in the analysis folder with instructions on how to compile and use the analysis SQL.

Under the Hood

  • Adds consistency test for stripe__subscription_item_mrr_report model.
  • Updates integration_tests/seeds/price_data.csv with additional test data.
  • Adds stripe__subscription_item_mrr_report model to quickstart.yml public models list.

Full Changelog: v1.3.0...v1.4.0

Don't miss a new dbt_stripe release

NewReleases is sending notifications on new releases.