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
Opens an editable copy you can change by voice or by hand. Free account, no card.
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 7 days of Pro. No card needed.
Related
- Flow diagram examples: all 37 worked process and data flow diagrams
- Order to cash process: a finance flow example
- Procure to pay process: a procurement flow example
- Employee onboarding: an HR flow example
- Invoice approval workflow: an approval flow example
- Support ticket escalation: a support flow example
- Flowchart template: copy, edit, and make your own
- For business analysts: capture an as-is process in swimlanes
- Live demo: describe a process and see the flow, no account needed