Stripe link
Stripe is an online payment processing platform.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | BANK_ACCOUNT , CARD , COUPON , CUSTOMER , INVOICE , INVOICE_ITEM , PERSON , PLAN , PRODUCT , and SKU tables. |
Custom data | ||
Data blocking | check | Column level and table level |
Column hashing | check | |
Re-sync | check | Table level |
History | check | ORDER_HISTORY and SUBSCRIPTION_HISTORY tables*. Supports history mode. |
API configurable | check | API configuration |
Priority-first sync | check | All tables and their child tables except APPLE_PAY_DOMAIN , CHECKOUT_SESSION , CREDIT_NOTE , EARLY_FRAUD_WARNING , PLAN , and SKU . |
Fivetran data models | check | Get the models: source / transform; Supports Quickstart data models |
Private networking |
* Connectors created before February 1, 2022, do not have history mode.
Setup guidelink
Follow our step-by-step Stripe setup guide to connect Stripe with your destination using Fivetran connectors.
Sync overviewlink
We use hard deletes to remove records from the following tables:
APPLICATION_FEE_REFUND
CHECKOUT_SESSION_LINE_ITEM
CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
CHECKOUT_SESSION_LINE_ITEM_TAX_RATE
CHECKOUT_SESSION_PAYMENT_METHOD
CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES
CHECKOUT_SESSION_SHIPPING_OPTION
CHECKOUT_SESSION_TAX_RATE
CREDIT_NOTE_LINE_ITEM
CUSTOMER_BALANCE_TRANSACTION
CUSTOMER_DISCOUNT
DISCOUNT
DISPUTE_BALANCE_TRANSACTION
FEE
INVOICE_CUSTOM_FIELD
INVOICE_DISCOUNT
INVOICE_ITEM_TAX_RATE
INVOICE_LINE_ITEM
INVOICE_LINE_ITEM_TAX_RATE
INVOICE_TAX_RATE
ORDER_ITEM
ORDER_RETURN_ITEM
PHASE
PHASE_PLAN
SETUP_ATTEMPT
SHIPPING_METHOD
SUBSCRIPTION_DISCOUNT
SUBSCRIPTION_ITEM
SUBSCRIPTION_TAX_RATE
TIER
TRANSFER_REVERSAL
USAGE_RECORD
NOTE: The shape of the resources that the Stripe API retrieves from the Events endpoint depends on the default version of the API used by your Stripe account. Make sure that your Stripe account uses an API version released after February 19, 2019.
To capture new records and updates, we re-import the PLAN
table every time we perform a sync for the connector.
Schema informationlink
This schema applies to all Stripe connections created after March 25, 2019.
To zoom, open the ERD in a new window.Schema noteslink
The CARD
table does not include credit card number or CVV code data. Instead, the fingerprint
column contains Stripe-provided hashes that uniquely identify each card number. You can use this column to check if two customers who've signed up are using the same card number.
If you want to sync the following columns in the CARD
table, contact Stripe support to enable them on your account because these columns are not available in the standard Stripe API requests:
iin
description
issuer
To sync data from the CARD
, BANK_ACCOUNT
and SOURCE
tables, select the CHARGE
,SOURCE
,BANK_ACCOUNT
,PAYMENT_METHOD
,CARD
, and ACCOUNT
tables in the Schema tab.
To sync data from the PAYMENT_METHOD
table, select the SETUP_INTENT
,SETUP_ATTEMPT
, and CHARGE
tables in the Schema tab.
To sync data from the DISPUTE
,PAYOUT
and BALANCE_TRANSACTION
tables, select the DISPUTE
,PAYOUT
, and BALANCE_TRANSACTION
tables in the Schema tab.
To sync data from the INVOICE
,PRICE
and PRODUCT
tables, select the INVOICE
,PRICE
,PRODUCT
,INVOICE_TAX_RATE
,INVOICE_DISCOUNT
,INVOICE_LINE_ITEM
, and INVOICE_LINE_ITEM_TAX_RATE
tables in the Schema tab.
Connected Accountslink
Fivetran supports syncing Connected Accounts data for the following endpoints:
- Events
- Charges
- Payouts
- Balance Transaction
- Apple Pay Domain
- Refunds
- Disputes
- Payment Intent
NOTE: To sync data from connected accounts, select the
ACCOUNT
table in the Schema tab.
In the connector setup form, set the Sync Connected Accounts toggle to ON.
We populate the connected_account_id
column for the supported tables.
NOTE: If you enable this feature during a sync, we perform a historical re-sync of these tables.
Sync overviewlink
On weekly basis, we re-sync pending balance transactions. During these re-syncs, we sync back to the earliest pending balance transaction that's present in the Stripe account.
NOTE: We recommend that you do not re-sync the following tables to avoid data loss in the history table:
SUBSCRIPTION_HISTORY
and its child tablesUSAGE_RECORD
Syncing empty tables and columnslink
Fivetran can sync empty tables and columns for your Stripe connector.
We create a table in the destination even if we can't retrieve the source table data from Stripe. For more information, see our Features documentation.
UTC conversionlink
We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Stripe account's time zone to store the data in your destination.