Release Notes

October 2025

We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

* 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.

September 2025

We have updated the Quickstart packages for the following connectors:

Amazon Selling Partner to version 0.2.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
Qualtrics to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
QuickBooks to version 0.21.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
Recharge to version 1.1.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 20, 2025.
Reddit Ads to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 12, 2025.
SAP ERP on HANA to version 0.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
Shopify to version 0.22.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
Zendesk Support to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.

August 2025

We have made the following changes to the Schema tab for connections set up before June 18, 2024:

We display all table names in lowercase
We display all the tables, including the empty tables
We no longer support table-level selection and deselection
We have removed the following tables:
- META_FIELD_CHARGE
- META_FIELD_CUSTOMER
- META_FIELD_ORDER
- META_FIELD_STORE
- META_FIELD_SUBSCRIPTION

We have made the following changes for connections set up before June 18, 2024:

Replaced the UTM_TAG table with the following new tables:
- CHARGE_UTM_TAG
- CHECKOUT_UTM_TAG
- CUSTOMER_UTM_TAG
- SUBSCRIPTION_UTM_TAG
Renamed the ORDER table to ORDERS
Renamed the subscription_id column of the SUBSCRIPTION_HISTORY table to id
Added a new column, buyer_accepts_marketing, to the CHECKOUT table
Stopped syncing data into the is_deleted column for the following tables, as this information is already available in the _fivetran_deleted column:
- ONE_TIME_PRODUCT
- ORDERS
- CHARGE
- CUSTOMER

We have updated the Quickstart packages for the following connectors:

Amazon Ads to version 1.0.0.
Asana to version 1.0.0.
Facebook Pages to version 1.0.0.
Fivetran Platform to version 2.3.0.
GitHub to version 1.0.0.
Greenhouse to version 1.0.0.
Instagram Business to version 1.0.0.
Intercom to version 1.0.0.
Iterable to version 1.0.0.
Jira to version 1.0.0.
Klaviyo to version 1.0.0.
Lever to version 1.0.0.
LinkedIn Ad Analytics to version 1.0.0.
LinkedIn Company Pages to version 1.0.0.
Mailchimp to version 1.0.0.
Marketo to version 1.0.0.
Microsoft Advertising to version 1.0.0.
Mixpanel to version 0.14.0.
NetSuite SuiteAnalytics to version 1.0.0.
Pardot to version 1.0.0.
Pendo to version 1.0.0.
Pinterest Ads to version 1.0.0.
Qualtrics to version 1.0.0.
QuickBooks to version 0.21.0.
Recharge to version 1.0.0.
Recurly to version 1.0.0.
Reddit Ads to version 1.0.0.
Sage Intacct to version 1.0.0.
Salesforce Marketing Cloud to version 0.3.0.
ServiceNow to version 0.5.0.
Shopify to version 0.21.0.

July 2025

We have updated the Quickstart packages for the following connectors:

Connectors supporting the Ad Reporting data model to version 1.17.0.
Fivetran Platform Connector to version 2.2.2.
GitHub to version 0.9.1.
HubSpot to version 0.26.0.
Iterable to version 0.14.0.
Microsoft Dynamics 365 CRM to version 0.1.0-b2.
Qualtrics to version 0.4.0.
QuickBooks to version 0.20.1.
Recharge to version 0.5.0.
Reddit Ads to version 0.7.0.
SAP ERP on HANA to version 0.2.1.
Shopify to version 0.19.1.
Stripe to version 0.19.2.
Zendesk Support to version 0.25.0.

May 2025

We have updated the Quickstart packages for the following connectors:

Connectors supporting the Ad Reporting data model to version 1.14.0.
Connectors supporting the Social Media Reporting data model to version 0.7.0.
Google Ads to version 0.13.0.
Instagram Business to version 0.3.0.
Intercom to version 0.9.2.
Mailchimp to version 0.10.1.
QuickBooks to version 0.18.1.
Recharge to version 0.4.0.
Recurly to version 0.6.0.
Shopify to version 0.19.0.
Stripe to version 0.18.0.
TikTok Ads to version 0.8.1.
Zendesk Support to version 0.22.0.
Zuora to version 0.5.0.

We can no longer retrieve the charge records processed over 90 days ago because Recharge has changed its API. Effective March 19, 2025, Recharge introduced a 90-day lookback restriction on the retrieve and list charge endpoints for API versions 2021-01 and 2021-11.

As a result of this change, Fivetran can't retrieve records from the Charges API endpoints with a processed_at date older than 90 days for processed charges whose status equals success, refunded, or partially refunded.

If you perform a historical re-sync, we can't retrieve charge records with a status of success, refunded, or partially refunded that were processed over 90 days ago. We won't mark these records as deleted unless we receive a delete webhook event.

We have increased the replay window to one day for the CHARGE table to capture any delayed updates from the source.

April 2025

We have updated the Quickstart packages for the following connectors:

Facebook Ads to version 0.9.0
Google Ads to version 0.12.0
HubSpot to version 0.23.0
LinkedIn Ad Analytics to version 0.11.0
Microsoft Advertising to version 0.11.1
NetSuite SuiteAnalytics to version 0.19.0
Pinterest to version 0.12.0
Recharge to version 0.3.1
Reddit Ads to version 0.4.0
TikTok Ads to version 0.8.0
Twitter Ads to version 0.9.0
Xero to version 0.9.0
Zuora to version 0.4.0

February 2025

We now re-import the previous day’s data for the CUSTOMER table to capture any delayed updates from the source.

June 2024

We have made the following changes to the Schema tab for connections created on or after June 18, 2024:

Table names now appear in lowercase
We display all the tables, including the empty tables
We no longer support table-level selection and deselection for syncing

We have made the following schema changes for connections created on or after June 18, 2024:

Renamed the ORDER table to ORDERS
Replaced the UTM_TAG table with the following new tables:
- CHARGE_UTM_TAG
- CHECKOUT_UTM_TAG
- CUSTOMER_UTM_TAG
- SUBSCRIPTION_UTM_TAG

December 2023

We have modified our incremental sync strategy to ensure data consistency. Now, our incremental syncs have a 30-minute gap duration to minimize data inconsistencies. For example, a sync starting at 9:00 a.m. fetches data only up to 8.30 a.m. from the Recharge API.

October 2023

The Recharge connector now supports priority-first sync for the DISCOUNT table. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Recharge's priority-first syncs fetch the most recent 15 days' worth of data from the supported tables. We are gradually rolling out this change to all existing connections. To learn more, see our priority-first sync documentation.

September 2023

The Recharge connector now supports priority-first sync for the following tables:

ADDRESS
ADDRESS_DISCOUNT
ADDRESS_SHIPPING_LINE
CHARGE
CHARGE_DISCOUNT
CHARGE_LINE_ITEM
CHARGE_ORDER_ATTRIBUTE
CHARGE_SHIPPING_LINE
CHARGE_TAX_LINE
CHECKOUT
CHECKOUT_LINE_ITEM
CUSTOMER
METAFIELD
ONE_TIME_PRODUCT
ORDER
ORDER_LINE_ITEM
PAYMENT_METHOD
PLAN
SUBSCRIPTION
SUBSCRIPTION_HISTORY
UTM_TAG
Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Recharge's priority-first syncs fetch the most recent 15 days' worth of data from the supported tables. We are gradually rolling out this change to all existing connections. To learn more, see our priority-first sync documentation.

We now sync the METAFIELD table using the following endpoints:

META_FIELD_CHARGE
META_FIELD_CUSTOMER
META_FIELD_ORDER
META_FIELD_STORE
META_FIELD_SUBSCRIPTION

We have added a new column, value_type, to the DISCOUNT table.

June 2023

We now capture soft deletes for the PAYMENT_METHOD table. We create a new _fivetran_deleted column in the destination table, and mark the deleted rows as TRUE.

We have released pre-built, dbt Core-compatible data models for Recharge. 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.

April 2023

We have upgraded our Recharge connector from version 2021-01 to 2021-11 of the Recharge API. We have made the following schema changes:

We have the added the following new tables:
- ADDRESS_DISCOUNTS
- CHARGE_DISCOUNT
- CHARGE_ORDER_ATTRIBUTE
We have deprecated the following tables:
- CHARGE_DISCOUNT_CODE
- CHARGE_NOTE_ATTRIBUTE

We have added the following new columns to the tables below:

TABLE	NEW COLUMNS
`ADDRESS`	`payment_method_id` and `country_code`
`CHARGE`	`billing_address_country_code`, `orders_count`, and `shipping_address_country_code`
`CHARGE_LINE_ITEM`	`taxable_amount`, `tax_due`, `taxable`, `total_price`, `unit_price`, and `unit_price_includes_tax`
`CHECKOUT`	`billing_address_country_code`, `external_transaction_id_payment_processor`, and `shipping_address_country_code`
`CUSTOMER`	`tax_exempt`
`ORDER`	`billing_address_country_code` and `shipping_address_country_code`
`ORDER_LINE_ITEM`	`tax_due`, `taxable`, `taxable_amount`, `total_price`, `unit_price`, and `unit_price_includes_tax`
`PAYMENT_METHOD`	`billing_address_country_code`, `default`, and `payment_details`

We have replaced the following columns in the tables below:

TABLE	OLD COLUMN	NEW COLUMN
`ADDRESS`	`cart_note`	`order_note`
`CHARGE`	`transaction_id`	`external_transaction_id_payment_processor`
`CHARGE`	`total_weight`	`total_weight_grams`
`CHARGE`	`number_times_tried`	`charge_attempts`
`CHARGE`	`shopify_variant_id_not_found`	`external_variant_id_not_found`
`CHARGE`	`processor_name`	`payment_processor`
`CHECKOUT`	`note_attributes`	`order_attributes`
`CUSTOMER`	`has_card_error_in_dunning`	`has_payment_method_in_dunning`
`CUSTOMER`	`number_active_subscriptions`	`subscriptions_active_count`
`CUSTOMER`	`number_subscriptions`	`subscriptions_total_count`
`ONETIME`	`shopify_product_id`	`external_product_id`
`ORDER_LINE_ITEM`	`product_title`	`title`

We have deprecated the following columns from the tables below:

TABLE	DEPRECATED COLUMNS
`ADDRESS`	`country`
`CHARGE`	`billing_address_country`, `first_name`, `last_charge_attempt_date`, `last_name`, `shipments_count`, `shipping_address_country`, and `sub_total`
`CHARGE_LINE_ITEM`	`price` and `subscription_id`
`CHECKOUT`	`billing_address_country`, `buyer_accepts_marketing`, `discount_code`, and `shipping_address_country`
`CUSTOMER`	`billing_address1`, `billing_address2`, `billing_city`, `billing_company`, `billing_country`, `billing_first_name`, `billing_last_name`, `billing_phone`, `billing_province`, `billing_zip`, `processor_type`, `reason_payment_method_not_valid`, and `status`
`DISCOUNT`	`discount_type`, `duration`, `duration_usage_limit`, `once_per_customer`, and `times_used`
`ONETIME`	`recharge_product_id` and `status`
`ORDER`	`address_is_active`, `billing_address_country`, `first_name`, `last_name`, `payment_processor`, `shipping_address_country`, `shipping_date`, `shopify_customer_id`, and `shopify_id`
`ORDER_LINE_ITEM`	`price` and `subscription_id`
`PAYMENT METHOD`	`billing_address_country`

We will re-sync all the new tables and columns to load their historical data.

March 2023

We now capture deletes for the CHARGE and CUSTOMER tables. In order to remove the previously deleted records from these tables, trigger a full historical re-sync for these tables.

We have upgraded our Recharge connector from version 2021-01 to 2021-11 of the Recharge API. We have made the following schema changes:

We have added a new table, CHARGE_TAX_LINE, to replace the tax_lines column of the CHARGE table.
We have added a new table, PAYMENT_METHODS, to replace the PAYMENT_SOURCE table.
We have added a new table, PLANS, to replace the PRODUCT table.
We have added two new columns, purchase_item_id and purchase_item_type, to the ORDER_LINE_ITEM and CHARGE_LINE_ITEM tables.
We have renamed the following columns of the DISCOUNT table:
- applies_to_product_type to applies_to_purchase_item_type
- usage_limit to automatic_redemptions_per_customer
We have renamed the following columns of the ORDER table:
- shopify_cart_token to external_cart_token
- shopify_order_id to external_order_id_ecommerce
- shopify_order_number to external_order_number_ecommerce
We have renamed the following columns of the SUBSCRIPTION table:
- shopify_product_id to external_product_id_ecommerce
- shopify_variant_id to external_variant_id_ecommerce
We have renamed the following columns in the CHARGE_LINE_ITEM and ORDER_LINE_ITEM tables:
- shopify_product_id to external_product_id_ecommerce
- shopify_variant_id to external_variant_id_ecommerce
We have renamed the shopify_customer_id column of the CUSTOMER table to external_customer_id_ecommerce.
We have renamed the shopify_order_id column of the CHARGE table to external_order_id_ecommerce.
We have renamed the shopify_variant_id column of the ONETIME_PRODUCT table to external_variant_id_ecommerce.
We have deprecated the status column of the CUSTOMER table.
We have deprecated the subscription_id column of the ORDER_LINE_ITEM and CHARGE_LINE_ITEM tables.

For more information about the changes, see Recharge API’s changelog.

If you want to sync historical data for these columns, contact our support team.

October 2022

We have renamed our ReCharge connector to Recharge, following Recharge's name change. This name change applies to the Fivetran dashboard and our documentation.

October 2021

We have replaced the is_deleted column in the SUBSCRIPTION table with a new _fivetran_deleted column. We have removed the is_deleted column. Be sure to update your queries.

April 2021

We have added the following new columns to the UTM_TAG table:

campaign
content
data_source
medium
source
term
time_stamp

We will discontinue the following columns of the UTM_TAG table after July 1, 2021:

utm_campaign
utm_content
utm_data_source
utm_medium
utm_source
utm_term
utm_time_stamp

Be sure to update your queries with the new column names before we remove the old columns.

March 2021

We have added the following new tables:

CHECKOUT
CHECKOUT_LINE_ITEM
METAFIELD
PAYMENT_SOURCE
PRODUCT

We use webhooks to retrieve data from the Checkouts endpoint. See Recharge's API Documentation for more information.

February 2021

We have added the following new columns to the CUSTOMER table:

first_charge_processed_at
number_active_subscriptions
number_subscriptions

November 2020

We now use webhooks to capture deletes for the ONE_TIME_PRODUCT, ORDER, and SUBSCRIPTION tables. We have added a is_deleted column to the three tables to track the deleted records.

We have deprecated the ANALYTICS_DATA table. We now sync this data to the UTM_TAG table.

August 2020

We now use webhooks to sync record updates in the CHARGE, ORDER, and SUBSCRIPTION tables.

We have added a new table, ONE_TIME_PRODUCT.

July 2020

We have added the following columns to the CHARGE table:

last_charge_attempt_date
retry_date
number_times_tried
error
error_type
shopify_variant_id_not_found

We have replaced the ANALYTICS_DATA table with the UTM_TAG table. We will discontinue the replaced table after November 1, 2020. Be sure to update your queries with the new table name before we remove the old table.

We have removed the _fivetran_deleted column from the SUBSCRIPTION table.

May 2020

We have added a new column, _fivetran_deleted, to the SUBSCRIPTION table.

We have added a new column, _next_charge_scheduled_at, to the SUBSCRIPTION ATTRIBUTE table.

April 2020

We now sync analytics data from the CUSTOMER, CHARGE, and SUBSCRIPTION tables into the ANALYTICS_DATA table.

January 2020

We have added the following columns to the CHARGE table:

email
has_uncommited_changes
processor_name
total_refunds
transaction_id

December 2019

We have added the following columns to the CUSTOMER table:

has_card_error_in_dunning
has_valid_payment_method
reason_payment_method_not_valid

June 2019

We have added three new columns, price, sku, and grams, to the ORDER_LINE_ITEM table.

January 2019

We have removed the restrict_by_email column from the DISCOUNT table.

May 2018

We have corrected the way our system interprets timestamps. The Recharge API produces timestamps that look like 2018-01-01T00:00:00. Previously, we interpreted these timestamps as UTC, when they were actually Eastern Time (ET). This meant that all destination timestamps were off by 4 or 5 hours, depending on the daylight saving time changes. All timestamps are now correctly converted from ET to UTC before they arrive in your destination. Note that there is still one hour each year where the timestamp is ambiguous due to daylight saving time. Recharge is working on a fix for this in their API.

April 2018

The Recharge API sometimes returns non-number values in the price column of the ADDRESS_SHIPPING_LINE table, so this field is now a STRING.

The note_attribute column in the CHARGE_NOTE_ATTRIBUTE table can now contain nested JSON values. For example:

[
  {
    "name": "How did you hear about us?",
    "value": "Social_media_ad:"
  },
  "some attribute"
]