Stripe
Stripe is an online payment processing and credit card processing platform for businesses. Stripe provides the technical, fraud prevention, and banking infrastructure required to operate online payment systems.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
The Stripe connector currently does not support the API categories Connect, Issuing, Orders, and Fraud. We also do not support Connected Accounts. To request support for other API categories or features, please reach out to our team.
🔧 Setup Guide
Prerequisites
To connect Stripe to Weld, you need:
- An active Stripe account with permission to access data from accounts you would like to sync.
- Administratior or Developer access to the account.
Step 1 - Create API Keys
- Log into the account that you will connect to Weld.
- Click on the Developers tab.
- Go to API Keys, and click on Create Restricted Key.
- Create a name for your Key.
- Grant
Readpermissions for the resources you want to sync. - Create your Key
Step 2 - Configuration and finalize
- On the Weld connector setup page, enter a destination schema name.
- Enter the Stripe API key.
- Click Connect
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Stripe account.\
📊 SQL Templates
View all →Extracts a comprehensive overview of Stripe subscriptions. This helps in understanding the status and duration of various subscriptions tied to different customers.
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.
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.
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.
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.
This SQL model provides a comprehensive view of the Monthly Recurring Revenue (MRR) by categorizing the revenue into new MRR, contraction MRR, churn MRR, and expansion MRR. It also computes the net new MRR and total MRR over time.
Changelog
RSScolumncolumn