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 to INVOICE_TAX_RATE
TAX_RATE_INVOICE_ITEM_MAPPING to INVOICE_ITEM_TAX_RATE
TAX_RATE_SUBSCRIPTION_MAPPING to SUBSCRIPTION_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 the CHARGE table
discount_id to the ORDER_ITEM and ORDER_REFUND_ITEM tables
payment_intent_id to the REFUND 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 and capabilities_platform_payments to the ACCOUNT table
verification_data_expiry_check to the AUTHORIZATION table
livemode to the ORDER_RETURN table
id to the SUBSCRIPTION_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 to amount
authorized_currency to currency

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 the INVOICE_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