Weld
Start free
Stripe model

Get all subscriptions

Extracts a comprehensive overview of Stripe subscriptions. This helps in understanding the status and duration of various subscriptions tied to different customers.

See the SQLAll Stripe models
Grain
See the notes
Built from
  1. 1
    Raw tables
  2. 1
    Staging
Reads from Stripe
subscription
Ships as
Weld and dbt SQL, open source on GitHub
staging.stripe.subscriptions
1-- staging.stripe.subscriptions
2-- Get all subscriptions. Extracts a comprehensive overview of Stripe subscriptions.
3-- This helps in understanding the status and duration of various subscriptions tied
4-- to different customers.
5--
6-- From the weld.app template library. Not reconciled against Stripe;
7-- check the output against the source before relying on it.
8
9select
10    id,
11    customer_id,
12    start_date,
13    canceled_at,
14    id as subscription_id,
15    status
16from
17    {{raw.stripe.subscription}}

Refs like {{raw.…}} resolve to your synced tables in Weld; the dbt view uses source() instead.

Notes

How it counts. And where it stops.

This SQL model enables businesses to quickly gather a holistic view of their Stripe subscriptions. By listing out essential details like subscription ID, associated customer ID, start date, potential cancellation date, and the subscription's status, businesses can efficiently manage and track their billing processes. This insight is crucial for maintaining customer relationships and ensuring a smooth subscription experience for users.

Raw tables it reads

  • raw.stripe.subscription

More Stripe models

Put Stripe in front
of your agents.

Connect Stripe, deploy the models, and ask questions in Claude, Cursor or ChatGPT. Free for 14 days, no credit card.

Start for freeTalk to us