Stripe Connector

Start moving your Stripe data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Stripe connector in the Weld documentation

invoice_item

id

62 more stripe tables

Explore available Stripe data

Browse all the data tables available for the Stripe connector, in our interactive ERD data viewer.

View the Stripe Data Schema

Transform and model Stripe data

Get clean data models from your Stripe data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Stripe

raw.stripe.table1

raw.stripe.table2

Get started with Stripe SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Stripe.

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.

Get subscription plans

Pulls an exhaustive view of Stripe subscriptions, diving into associated items, the specifics of plans, discounts applied through coupons, and additional metrics like the amount discounted and subscription intervals.

Normalize to monthly revenue

This SQL model fetches the monthly subscription amounts, converts them to EUR using average monthly forex rates, and provides insights into revenue streams in a standardized currency.

Identify active subscriptions and sum revenue

This SQL model fetches the monthly revenue per subscription and applies discounts to provide a net monthly amount. It then identifies if a subscription is active or canceled based on the status.

Create time series for each customer

This SQL model captures the monthly recurring revenue (MRR) trend for each customer, including the change in MRR, and provides a rank based on the MRR. It also considers the customer's subscription status and cancellation date.

View all Stripe templates