Release Noteslink
November 2023link
Effective November 22, 2023, we have deprecated the ORDER
and SUBSCRIPTION
tables.
October 2023link
We have added two new columns, flat_amount_decimal
and unit_amount_decimal
, to the TIER
table.
The Stripe connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Stripe's priority-first syncs fetch the most recent 30 days' worth of data from the supported tables. We have rolled out this feature for all active connectors. If a connector is currently paused and if you unpause it within 2 months, the connector will start supporting priority-first sync as soon as you unpause it. However, if you unpause the connector after 2 months from now, we will consider it as a new connector and perform a historical sync on a priority-first basis.
To learn more, see our priority-first sync documentation.
July 2023link
Stripe's Balance Transaction API now fetches the balance transactions only for the payouts whose reconciliation_status
field has changed to completed
. To support this change, we have updated our sync strategy and now fetch the balance transactions when the reconciliation_status
of a payout changes to completed
. This change applies to both Stripe Standard and Connected accounts. You may observe sync delays for the payouts we sync using the /events
endpoint.
We have added a new table, INVOICE_CUSTOM_FIELD
. If you want to backfill the historical data for this table, you can re-sync the INVOICE
table or contact our support team to re-sync it for you.
June 2023link
We have added the following fields to the CHECKOUT_SESSION_LINE_ITEM_DISCOUNT
table:
checkout_session
coupon_id
customer_id
end
invoice_id
invoice_item_id
promotion_code
start
subscription_id
We have added a new column, reconciliation_status
, to the PAYOUT
table.
Be sure to re-sync these tables for the latest changes or contact our support team to re-sync it for you.
April 2023link
We have added a new table, INVOICE_LINE_ITEM_TAX_RATE
, to store the mappings of invoices and their associated invoice line items and tax rates. You can re-sync the INVOICE
table to backfill the INVOICE_LINE_ITEM_TAX_RATE
table for old invoices.
March 2023link
We have changed our sync strategy to handle invalid or deleted connected accounts. We now display a warning on your connector dashboard when we detect invalid or deleted Stripe connected accounts and skip these accounts from the sync. Previously, we didn't skip these accounts, causing the connector to break.
February 2023link
We now update the three_d_secure
column of the CARD
table in the destination as 'attempted' when we receive a JSON response. For more information about three_d_secure
fields, see Stripe's documentation.
You can backfill the data for the three_d_secure
columns in the CARD
and PAYMENT_METHOD_CARD
tables. Perform a re-sync for the CARD
and PAYMENT_METHOD_CARD
tables. This will result in re-syncing the associated parent and child tables.
January 2023link
We now sync data from the CUSTOMER
endpoint to the PAYMENT_METHOD
table. Previously, we synced data only from the PAYMENT_INTENT
and SETUP_INTENT
endpoints, to the PAYMENT_METHOD
table. To sync records from the CUSTOMER
endpoint, we recommend that you re-sync the CUSTOMER
table.
October 2022link
We have added a new column, collection_method
, to the INVOICE
and SUBSCRIPTION
(SUBSCRIPTION_HISTORY
for history mode connectors) tables. This column stores the same value as the billing
column. Stripe has deprecated the billing
column. We will continue to support both columns.
We have added the following new columns to the CARD
table:
iin
description
issuer
NOTE: These columns are not available in standard Stripe API requests. Contact Stripe support to enable them on your account.
September 2022link
We have added the following new tables:
CHECKOUT_SESSION
CHECKOUT_SESSION_PAYMENT_METHOD
CHECKOUT_SESSION_TAX_RATE
CHECKOUT_SESSION_SHIPPING_OPTION
CHECKOUT_SESSION_SHIPPING_ADDRESS_ALLOWED_COUNTRIES
CHECKOUT_SESSION_LINE_ITEM
CHECKOUT_SESSION_LINE_ITEM_TAX_RATE
SHIPPING_RATE
August 2022link
We have added a new column, invoice_item_id
, to the INVOICE_LINE_ITEM
table.
February 2022link
We have added two new tables, ORDER_HISTORY
and SUBSCRIPTION_HISTORY
. We automatically sync these tables for connectors created after February 1, 2022.
January 2022link
We have deprecated the following tables and no longer sync new data to them:
TAX_RATE_INVOICE_MAPPING
TAX_RATE_INVOICE_ITEM_MAPPING
TAX_RATE_SUBSCRIPTION_MAPPING
In May 2021, we renamed these tables but continued syncing to the old tables as well as to the new tables for existing connectors. Now, the data from these tables syncs only to the following renamed tables:
INVOICE_TAX_RATE
INVOICE_ITEM_TAX_RATE
SUBSCRIPTION_TAX_RATE
If your connector was created before May 3, 2021, be sure to update your queries.
If your connector was created after May 3, 2021, you don't need to do anything.
December 2021link
We added a new column, reporting_category
, to the BALANCE_TRANSACTION
table.
We have added a new table, ISSUING_TRANSACTION
, that contains data from Stripe's /issuing/transactions endpoint.
November 2021link
We have added a new column, invoice_item_id
, to the PRICE
table.
October 2021link
We have added a new column, invoice_line_item
, to the CREDIT_NOTE_LINE_ITEM
table.
September 2021link
We have added the following new fields to the CHARGE
table:
billing_detail_address_city
billing_detail_address_country
billing_detail_address_line1
billing_detail_address_line2
billing_detail_address_postal_code
billing_detail_address_state
billing_detail_email
billing_detail_name
billing_detail_phone
We now support the ISSUING_CARD
and ISSUING_DISPUTE
tables for Stripe Connect accounts.
August 2021link
We have added a new table, PROMOTION_CODE.
See Stripe's promotion code documentation for more details.
We have deprecated the metadata_*
columns from the Stripe schema.
We now support the PAYMENT_INTENT
table for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.
The Stripe connector now supports table-level re-syncs.
We now support table grouping in the Schema tab of your connector details page.
The Stripe connector now supports history mode for the following tables:
ORDER
SUBSCRIPTION
SUBSCRIPTION_ITEM
We are gradually rolling out this improvement to all existing customers.
July 2021link
We have added two new columns, pause_collection_behavior
and pause_collection_resumes_at
, to the SUBSCRIPTION
table.
We have added the following new columns to the PAYMENT_METHOD_CARD
table:
three_d_secure_authentication_flow
three_d_secure_result
three_d_secure_result_reason
three_d_secure_version
We have added a new table, SETUP_ATTEMPT
. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table. For more information, see Stripe's SetupAttempts documentation.
We have deprecated the three_d_secure_usage_supported
column from the PAYMENT_METHOD_CARD
and CARD
tables.
May 2021link
We now support the REFUND
and DISPUTE
tables for Stripe Connect accounts. If you'd like to sync data from Stripe connected accounts, contact our support team.
We have renamed the following tables:
TAX_RATE_INVOICE_MAPPING
toINVOICE_TAX_RATE
TAX_RATE_INVOICE_ITEM_MAPPING
toINVOICE_ITEM_TAX_RATE
TAX_RATE_SUBSCRIPTION_MAPPING
toSUBSCRIPTION_TAX_RATE
We will continue to sync the TAX_RATE_*_MAPPING
tables for existing connectors.
We have added a new column, price_id
, to the INVOICE_LINE_ITEM
table.
We have added two new columns, price_id
and plan_id
, to the INVOICE_ITEM
table.
We have added a new column, three_d_secure_usage_supported
, to the PAYMENT_METHOD_CARD
and CARD
tables.
April 2021link
We have added a new table, TAX_RATE_INVOICE_MAPPING
, which stores the tax rates applied to an invoice.
We have added a new table, APPLE_PAY_DOMAIN
. By default, we exclude the table from your syncs. On your Connector Details page, go to the Schema tab and select the table.
We have added the following new columns to the INVOICE
table:
default_payment_method_id
payment_intent_id
post_payment_credit_notes_amount
pre_payment_credit_notes_amount
subscription_id
We have added the following new columns to the SUBSCRIPTION
table:
default_payment_method
latest_invoice_id
pending_setup_intent_id
We have added a new column, payment_method_types
, to the PAYMENT_INTENT
table.
We will deprecate the metadata_*
columns from the Stripe schema after August 1, 2021. Be sure to update your queries with the metadata
column. We sync metadata as JSON objects. For more information on the metadata
column, see our documentation.
March 2021link
We have added the following new columns to the ACCOUNT
table:
capabilities_afterpay_clearpay_payments
capabilities_au_becs_debit_payments
capabilities_bacs_debit_payments
capabilities_bancontact_payments
capabilities_cartes_bancaires_payments
capabilities_eps_payments
capabilities_fpx_payments
capabilities_giropay_payments
capabilities_grabpay_payments
capabilities_ideal_payments
capabilities_jcb_payments
capabilities_oxxo_payments
capabilities_p24_payments
capabilities_sepa_debit_payments
capabilities_sofort_payments
capabilities_tax_reporting_us_1099_k
capabilities_tax_reporting_us_1099_misc
We have added the following new columns to the tables below:
payment_method_id
to theCHARGE
tablediscount_id
to theORDER_ITEM
andORDER_REFUND_ITEM
tablespayment_intent_id
to theREFUND
table
We have added two new columns, destination_payment_id
and source_transaction_id
, to the TRANSFER
table.
We will deprecate the destination_payment
and source_transaction
columns of the TRANSFER
table after June 20, 2021. Be sure to update your queries.
We have added the following new columns to the CARDHOLDER
table:
spending_controls_allowed_categories
spending_controls_blocked_categories
spending_controls_spending_limits
spending_controls_spending_limits_currency
We have added a new column, amount_details_atm_fee
, to the AUTHORIZATION
and TRANSACTION
tables.
We have added a new column, wallet_type
, to the CARD
table.
February 2021link
We have added a new field, calculated_statement_descriptor
, to the CHARGE
table.
We have added the following new fields to the INVOICE
table:
status_transitions_finalized_at
status_transitions_marked_uncollectible_at
status_transitions_paid_at
status_transitions_voided_at
January 2021link
We have added a new field, metadata
, to the SUBSCRIPTION_SCHEDULE
table.
December 2020link
We now create empty tables in the destination even if the source tables are empty (contain only Null
values).
We have added a new table, CREDIT_NOTE_LINE_ITEM
. See Stripe's documentation on the credit note line item object for more information.
We have added a new table, PRICE
. See Stripe's documentation on prices for more information.
We have added the following new fields to the CREDIT_NOTE
table:
customer_balance_transaction
discount_amount
subtotal
total
voided_at
We now sync the metadata as JSON objects. We have added a new column, metadata
, to the following tables:
ACCOUNT
APPLICATIOIN_FEE_REFUND
AUTHORIZATION
BANK_ACCOUNT
CARD
CARDHOLDER
CHARGE
COUPON
CREDIT_NOTE
CUSTOMER
CUSTOMER_BALANCE_TRANSACTION
DISPUTE
FILE_LINK
INVOICE
INVOICE_ITEM
INVOICE_LINE_ITEM
ISSUING_CARD
ISSUING_DISPUTE
ORDER
PAYMENT_INTENT
PAYMENT_METHOD
PAYOUT
PLAN
PRODUCT
REFUND
SETUP_INTENT
SKU
SOURCE
SUBSCRIPTION
SUBSCRIPTION_ITEM
TAX_RATE
TOPUP
TRANSACTION
TRANSFER
TRANSFER_REVERSAL
November 2020link
We have added the following new fields to the ACCOUNT
table:
requirements_current_deadline
requirements_currently_due
requirements_disabled_reason
requirements_errors
requirements_eventually_due
requirements_past_due
requirements_pending_verification
We now sync the BANK_ACCOUNT
and CARD
tables' records using the external_accounts
field of the ACCOUNT
table. See Stripe's documentation on external accounts for more information.
We have added a new table, CUSTOMER_DISCOUNT
, which stores information about customer discounts. See Stripe's documentation on discounts for more information.
We have removed the _fivetran_id
field from the INVOICE_DISCOUNT
and SUBSCRIPTION_DISCOUNT
tables.
September 2020link
We have added the following new columns to the tables below:
is_deleted
andcapabilities_platform_payments
to theACCOUNT
tableverification_data_expiry_check
to theAUTHORIZATION
tablelivemode
to theORDER_RETURN
tableid
to theSUBSCRIPTION_DISCOUNT
table
We now support metadata_*
columns in the AUTHORIZATION
table.
August 2020link
We have released pre-built, dbt Core-compatible data models for Stripe. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We have added three new tables:
TAX_RATE
stores the tax rates that can be applied to either a subscription or an invoice item.TAX_RATE_SUBSCRIPTION_MAPPING
stores the tax rates applied to a subscription.TAX_RATE_INVOICE_ITEM_MAPPING
stores the tax rates applied to an invoice item.
We have renamed the following fields in the AUTHORIZATION
table:
authorized_amount
toamount
authorized_currency
tocurrency
We have moved the following fields from the TRANSACTION
table to the AUTHORIZATION
table:
merchant_data_network_id
merchant_data_postal_code
merchant_data_state
merchant_data_category
merchant_data_city
merchant_data_name
merchant_data_country
We have added the following columns to the ISSUING_CARD
table:
cancellation_reason
number
replaced_by
replacement_for
replacement_reason
shipping_eta
shipping_service
shipping_status
shipping_tracking_url
shipping_type
We have removed the following columns from the ISSUING_CARD
table:
authorization_controls_currency
authorization_controls_max_amount
authorization_controls_max_approvals
shipping_phone
We have removed the is_deleted
column from the PAYMENT_METHOD
table.
We have removed the client_secret
column from the SETUP_INTENT
table.
July 2020link
We now capture deletes for the INVOICE
, INVOICE_ITEM
, and PERSON
tables. Deletes from these tables are captured in the is_deleted
column.
You can now select the PAYMENT_METHOD
and CUSTOMER_BALANCE_TRANSACTION
tables to sync from the Schema tab on your connector details page.
We have added a new column, is_deleted
, to the PERSON
table.
We have added a new table, SETUP_INTENT
. Read Stripe's documentation for more information.
June 2020link
We can now enable support for your Stripe Connected Accounts on your connector. Contact our Support team to enable this feature on your connector.
We have added a new table, USAGE_RECORD
. This table stores the usage records of a subscription.
May 2020link
We have added the following columns to CUSTOMER
table:
address_*
balance
name
phone
April 2020link
You can now select the tables you want to sync from the Schema tab on your connector details page.
March 2020link
We have added a new field, tax_exempt
, to the CUSTOMER
table.
We have added a new table, PAYMENT_METHOD
, which stores customer payment method details. We have also added the following child tables to support the various payment types:
AU_BECS_DEBIT
stores details about the AU_BECS_DEBIT payment method.FPX
stores details about the FPX payment method.IDEAL
stores details about the IDEAL payment method.PAYMENT_METHOD_CARD
stores details about the CARD payment method.SEPA_DEBIT
stores details about the SEPA_DEBIT payment method.
We have updated the ACCOUNT
table to support the latest Stripe API version. We have deprecated the following fields from the ACCOUNT
table:
business_name
business_url
debit_negative_balances
decline_charge_on_avs_failure
decline_charge_on_cvc_failure
display_name
legal_entity
payout_schedule_delay_days
payout_schedule_interval
payout_schedule_monthly_anchor
payout_schedule_weekly_anchor
payout_statement_descriptor
product_description
statement_descriptor
support_address
support_email
support_phone
timezone
verification
See the Stripe ERD to learn more about the fields we support in the ACCOUNT
table.
February 2020link
You can now configure your Stripe connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have added a new field, start_date
, to the SUBSCRIPTION
table. This field stores the actual subscription start date, while the start
field in the same table stores the last modified date of the subscription.
We have added a new table, SUBSCRIPTION_SCHEDULE
, which stores the historical change data of a subscription.
We have added a new table, PHASE
, which stores the details about phases in the subscription schedule life cycle.
We have added a new table, PHASE_PLAN
, which stores the subscription plan details during a specific phase.
We have added the following fields to the BALANCE_TRANSACTION
table:
payout_id
. This field stores the automatic payout ID in which the balance transaction was paid out.exchange_rate
. This field stores the exchange rate used for a transaction.
January 2020link
We have added a new field unique_id
to the INVOICE_LINE_ITEM
table. This fix resolves the pagination break issue for invoice line items, which was introduced by the Stripe API update.
December 2019link
We have added a new table, EARLY_FRAUD_WARNING
, which contains the following fields:
id
charge_id
actionable
created
fraud_type
livemode
November 2019link
We have added a new field, network
, to the CARD
table.
October 2019link
For version 2 of the Stripe connector, we have added a new column, invoice_id
, to the CHARGE
table to support mapping between the CHARGE
and INVOICE
tables.
September 2019link
- We have added the
customer_id
field to theINVOICE_ITEM
table.
August 2019link
- We have made the
subscription_id
column a primary key. - The
SUBSCRIPTION_ITEM
table now holds only existing subscription items. We will delete subscription items which are not related to any subscription. - For example, when a subscription item is removed from a subscription, it does not belong to any subscription, so we delete that subscription item from the table.
July 2019link
- We have deprecated the OAuth 2.0 authentication mechanism for creating a new connector. Going forward, you need to use the restricted API key to create a new connector. We will continue to run existing connectors set up using the OAuth 2.0 mechanism. We encourage you to move to the new authentication for greater security.
April 2019link
Added new table
CREDIT_NOTE
with the following fields:id
amount
created
currency
customer
invoice_id
livemode
memo
number
pdf
reason
refund_id
status
type
March 2019link
We have released a new version of the Stripe connector, version 1.
- The new version contains changed, added and deprecated tables. In the existing tables we have added new fields and removed the deprecated ones. See the schema for details.
Added Tables
ATTRIBUTE
AUTHORIZATION
CARDHOLDER
DISPUTE_BALANCE_TRANSACTION
FILE
INVOICE_DISCOUNT
ISSUING_CARD
ISSUING_DISPUTE
PAYMENT_INTENT
PAYOUT
PRODUCT
SHIPPING_METHOD
SUBSCRIPTION_DISCOUNT
SUBSCRIPTION_ITEM
TIER
TRANSACTION
TRANSFER_REVERSAL
Renamed Tables
_ACCOUNT
->ACCOUNT
_APPLICATION_FEES
->APPLICATION_FEE
_APPLICATION_FEE_REFUNDS
->APPLICATION_FEE_REFUND
_BALANCE_TRANSACTIONS
->BALANCE_TRANSACTION
_BANK_ACCOUNTS
->BANK_ACCOUNT
_CARDS
->CARD
_CHARGES
->CHARGE
_COUPONS
->COUPON
_CUSTOMERS
->CUSTOMER
_DISPUTES
->DISPUTE
_FEES
->FEE
_INVOICES
->INVOICE
_INVOICE_ITEMS
->INVOICE_ITEM
_ORDER
->ORDER
_ORDER_ITEM
->ORDER_ITEM
_ORDER_RETURNED
->ORDER_RETURN
_ORDER_RETURNED_ITEM
->ORDER_RETURNED_ITEM
_PLANS
->PLAN
_REFUNDS
->REFUND
_REVIEWS
->REVIEW
_SKU
->SKU
_SOURCE
->SOURCE
_SUBSCRIPTIONS
->SUBSCRIPTION
_TOPUP
->TOPUP
_TRANSFERS
->TRANSFER
Deprecated Tables
_RECIPIENTS
_SUBSCRIPTION_PLAN
- The sunset date for version 0 is June 15, 2019.
- Connect to the new Stripe v1 integration.
Link to Stripe Documentation..
January 2019link
We have added the outcome_risk_score
field to the CHARGES
table.
December 2018link
The Stripe connector now supports top-up objects. This data appears in the TOPUP
table.
May 2018link
We have added a new table, FILE_UPLOAD
.
We have added the following columns to the tables below:
TABLE NAME | NEW COLUMN NAME |
---|---|
CHARGE | status |
INVOICES | amount_paid |
PLANS | nickname |