Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Stripe Data

After the Stripe setup is complete, you'll see the following tables in your data warehouse.

To see a full list of attributes for each table, refer to Stripes's API documentation - click the table name to go there. 

Table Name Description
balance_history This table contains data about transactions have have contributed to your Stripe account balance, including charges, transfers, etc. Attributes include the balance history ID, amount, available on date, currency, description, fee, fee details, net, source, status, type, and created at date.
charges This table contains information about charges to credit and debit cards, including the amount, currency, status, customer ID, and more.
coupons This table contains information about a percent- or amount-off discount you may want to apply to a customer. Note that coupons only apply to invoices; they do not apply to one-off charges.
customers Customer objects allow you to perform recurring charges and track multiple charges that are associated with the same customer.
events Events let you know about something interesting that has just happened in an account. When an interesting event occurs, a new event object is created. For example, when a charge succeeds charge.succeeded event is created; or, when an invoice can't be paid an invoice.payment_failed event is created.

Note that many API requests may cause multiple events to be created. For example, if you create a new subscription for a customer, you will receive both a customer.subscription.created event and a charge.succeeded event.
invoice_items This table contains information about items contained in customer invoices. Attributes include the invoice item ID, amount, currency, customer, date, description, discountable flag, period start and end, plan details, and subscription.
invoices This table contains information about invoices including the amount owed, subscriptions, invoice items, any automatic proration adjustments, and more.
plans This table contains the pricing information for different products and feature levels on your site. For example, you may have a $10/month plan for basic features and a $20/month plan for premium features.
subscriptions This table contains the details of subscription plans your customers belong to. Attributes include customer ID, status, canceled/ended at dates, tax percent, trial information, and more.
transfers This table contains data about your transfers. A transfer is created any time Stripe sends you money or you initiiate a transfer to a connected account. Attributes include the transfer ID, amount, application fee, balance transaction, card details, currency, description, recipient, reversal info, source transaction, source type, statement descriptor, status, type, and created at date.
transfer_transactions This table contains both a transfer_id and transaction_id so that you can join together your transfers with the transactions in your balance_history table.

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!