Stripe billing data to a data warehouse diagram
This is a worked example. Wavelength built the diagram below from the description on this page. Nobody drew it by hand.
What was said
Customers subscribe through Stripe Checkout. Stripe creates the subscription and sends a webhook to our billing service. The billing service provisions the account in Postgres. If a payment fails, Stripe retries the card and the customer success team gets an alert. Stripe data lands in Snowflake through Stripe Data Pipeline, and finance reports monthly recurring revenue in Sigma.
The diagram
What is in this flow
- Systems: Stripe Checkout, Stripe, Billing Service, Stripe Data Pipeline and Sigma.
- Data stores: Postgres and Snowflake.
- People and teams: Customer Success Team and Finance.
- Decisions: Payment Failed?.
- Size: 11 steps and 10 connections.
Questions to confirm
The AI inferred these links. On a real call, you ask the customer to confirm them.
- Does Stripe payment fails? Payment Failed??
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1(["Customers")]
n2{{"Stripe Checkout"}}
n3{{"Stripe"}}
n4{{"Billing Service"}}
n5[("Postgres")]
n6("Customer Success Team")
n7{"Payment Failed?"}
n8{{"Stripe Data Pipeline"}}
n9[("Snowflake")]
n10("Finance")
n11{{"Sigma"}}
n1 -->|subscribe| n2
n2 -->|creates subscription| n3
n3 -->|sends webhook| n4
n4 -->|provisions account| n5
n3 -.->|payment fails?| n7
n7 -->|retries card| n3
n3 -->|alerts| n6
n3 -->|data lands| n8
n8 -->|loads| n9
n10 -->|reports MRR| n11Map your own process
Describe your version out loud, or paste the transcript of a call. Wavelength draws the flow as you talk, and you can edit it by voice, by prompt, or by hand.
Every new account starts with 14 days of Pro. No card needed.