August 2025
Connector SDK
Fivetran Connector SDK
Connector SDK now supports private links as a connection option. See our Connector SDK Connection Options documentation for more information.
fivetran-connector-sdk PyPI package
We have released version 2.0.1 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Minor improvements and enhancements.
We have released version 2.0.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
Operations like
op.upsert()no longer require the use ofyieldin your connector code.Previously, operations had to be yielded like this:
yield op.upsert(table="table_name", data=data)Now, you can call them directly without yield:
op.upsert( table="table_name", data=data)This simplifies connector logic and improves code readability. See our Migration Guide to learn how to remove
yieldusages from your connector code.Performance improvements and internal design enhancements.
We have released version 1.8.1 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Minor improvements and enhancements.
We have released version 1.8.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Internal design and performance improvements.
- Updated tester.
fivetran-api-playground PyPI package
We have released version 1.1.1 of the fivetran-api-playground PyPI package. This release adds the following:
- Added two new cursor endpoints for retrieving user data for multiple sync strategies:
/incremental/timestamp- Get a list of user data which was updated since the timestamp in params./incremental/step- Get a list of users within a start and end parameter.
We have released version 1.1.0 of the fivetran-api-playground PyPI package. This release adds the following:
- Added two new cursor endpoints for retrieving company and department data:
/cursors/companies- Get a list of companies with filtering options./cursors/<company_id>/departments- Get department details for a specific company with filtering options.
Fivetran AWS Seoul Servers
We have added new servers in the AWS Asia Pacific (Seoul) region.
If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in Asia Pacific (Seoul), your data does not leave this region during processing.
For more information, see our data residency documentation.
Lite Connectors
Lite connectors are now available for the following sources:
Transformations for dbt Core
Auto-pause failing dbt Core transformations
We’ve introduced an auto-pause feature for dbt Core transformations that encounter repeated failures. This helps prevent resource waste and reduces unnecessary alerts from ongoing issues.
How it works
If a dbt Core transformation run fails consecutively due to factors outside of Fivetran’s control (such as issues with your data, configuration, or environment), the system will automatically pause the transformation if both of the following conditions are met:
- The transformation has failed more than 10 times in a row (i.e., on the 11th consecutive failure)
- At least 24 hours have passed since the first failure in the sequence
Key details
- Only failures caused by factors external to Fivetran (such as your data, configuration, or environment) will trigger the auto-pause mechanism
- System-level or transient errors don’t count toward the consecutive failure threshold
- When a transformation is auto-paused, you’ll see an alert on your dashboard
- If you’ve subscribed to transformation notifications, you’ll also receive an email
- The failure counters reset after the transformation is paused
Feature availability
This feature is being rolled out gradually to all users over the next few days.
You can manually resume paused transformations through the Fivetran dashboard once you’ve resolved the underlying issues.
Updated dbt Quickstart packages
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.
Schema changes
Ada
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION | |||||
| column | New Column | agent_handle_time | |||
| column | New Column | agent_id | |||
| column | New Column | agent_name | |||
| column | New Column | bot_handle_time | |||
| column | New Column | csat_ces_max | |||
| column | New Column | csat_customer_effort_score | |||
| column | New Column | csat_net_promoter_score | |||
| column | New Column | device | |||
| column | New Column | end_user_id | |||
| column | New Column | oauth_channel | |||
| column | New Column | record_last_updated | |||
Apple App Store
We have added a new table, SALES_SUBSCRIPTION_OFFER_CODE_REDEMPTION. We are gradually rolling out these changes to all existing connections.
Auth0
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
USER_IDENTITIES | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Rename Column | user_id | user_identity_id | ||
| column | Primary Key Change | index 🔑 | New primary key. | ||
BigCommerce
We have made the following changes for connections set up before July 21, 2024:
Added two new columns,
idandtype, to thePAYMENT_METHODtableAdded two new tables,
PAYMENT_METHOD_STORED_INSTRUMENTandPAYMENT_METHOD_SUPPORTED_INSTRUMENTRemoved the
CATEGORYtable and its data is now available in theCATEGORY_TREEtableReplaced the
BILLING_ADDRESS_CUSTOM_FIELDtable with two new tables,CHECKOUT_BILLING_ADDRESS_CUSTOM_FIELDandCONSIGNMENT_BILLING_ADDRESS_CUSTOM_FIELDRenamed the
timestampcolumn of theORDER_SHIPPING_ADDRESS_QUOTEtable totimestampsRenamed the
option_idcolumn of thePRODUCT_VARIANT_OPTIONS_VALUEtable toproduct_variant_option_idRenamed the
offlinecolumn of theORDER_REFUND_PAYMENTtable toofflinesRenamed the primary key,
tag, of theSTORE_BLOG_TAGtable totagsChanged the primary key from
indexto_fivetran_idfor the following tables:CATEGORY_SETTINGCUSTOMER_SETTING_PER_CHANNELEMAIL_SETTINGLOCALE_SETTINGPRICE_LIST_RECORDROBOT_SETTINGSEARCH_SETTINGSECURITY_SETTINGSEO_SETTINGSTATUS_SETTINGSTORE_PROFILE_SETTINGSTOREFRONT_PRODUCT_SETTING
Brex
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EXPENSE | |||||
| column | New Column | address_city | |||
| column | New Column | address_coordinates_latitude | |||
| column | New Column | address_coordinates_longitude | |||
| column | New Column | address_country | |||
| column | New Column | address_line1 | |||
| column | New Column | address_line2 | |||
| column | New Column | address_postal_code | |||
| column | New Column | address_state | |||
| column | New Column | address_timezone | |||
| column | New Column | approved_at | |||
| column | New Column | billing_amount | |||
| column | New Column | billing_currency | |||
| column | New Column | billing_entity_id | |||
| column | New Column | budget_amount | |||
| column | New Column | budget_currency | |||
| column | New Column | completion_date | |||
| column | New Column | expense_type | |||
| column | New Column | exported_at | |||
| column | New Column | integration_billing_entity_id | |||
| column | New Column | integration_spending_entity_id | |||
| column | New Column | merchant_country | |||
| column | New Column | payment_instrument_type | |||
| column | New Column | payment_posted_at | |||
| column | New Column | purchased_amount | |||
| column | New Column | purchased_currency | |||
| column | New Column | repayment_initiated_by_department_id | |||
| column | New Column | repayment_initiated_by_first_name | |||
| column | New Column | repayment_initiated_by_id | |||
| column | New Column | repayment_initiated_by_last_name | |||
| column | New Column | repayment_initiated_by_location_id | |||
| column | New Column | repayment_initiation_date | |||
| column | New Column | review_approved_at | |||
| column | New Column | review_approver_department_id | |||
| column | New Column | review_approver_first_name | |||
| column | New Column | review_approver_id | |||
| column | New Column | review_approver_last_name | |||
| column | New Column | review_approver_location_id | |||
| column | New Column | review_compliance_status | |||
| column | New Column | review_copilot_approver_department_id | |||
| column | New Column | review_copilot_approver_first_name | |||
| column | New Column | review_copilot_approver_id | |||
| column | New Column | review_copilot_approver_last_name | |||
| column | New Column | review_copilot_approver_location_id | |||
| column | New Column | reviewer_status | |||
| column | New Column | spending_entity_billing_address_city | |||
| column | New Column | spending_entity_billing_address_country | |||
| column | New Column | spending_entity_billing_address_line1 | |||
| column | New Column | spending_entity_billing_address_line2 | |||
| column | New Column | spending_entity_billing_address_phone_number | |||
| column | New Column | spending_entity_billing_address_postal_code | |||
| column | New Column | spending_entity_billing_address_state | |||
| column | New Column | spending_entity_created_at | |||
| column | New Column | spending_entity_display_name | |||
| column | New Column | spending_entity_id | |||
| column | New Column | spending_entity_is_default | |||
| column | New Column | spending_entity_status | |||
| column | New Column | status_reason | |||
| column | New Column | submitted_at | |||
| column | New Column | trip_id | |||
| column | New Column | usd_equivalent_amount | |||
| column | New Column | usd_equivalent_currency | |||
EXPENSE_CUSTOM_FIELD | |||||
| table | New Table | EXPENSE_CUSTOM_FIELD | |||
EXPENSE_REVIEWER | |||||
| table | New Table | EXPENSE_REVIEWER | |||
Centra
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
RETURN | |||||
| column | New Column | grand_total_formatted_value | |||
| column | New Column | grand_total_value | |||
| column | New Column | grand_total_value_in_cent | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ORDER_LINE | |||||
| column | Discontinued Column | order_updated_at 🔑 | No longer primary key | ||
ORDERS | |||||
| column | Primary Key Change | updated_at 🔑 | updated_at | No longer primary key | |
ChartMogul
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PLAN_IN_PLAN_GROUP | |||||
| column | Primary Key Change | PLAN_GROUP_uuid | PLAN_GROUP_uuid 🔑 | Added to primary key. | |
Delighted
For connections created before April 26, 2024, we have renamed the primary key, tag, of the RESPONSE_TAG table to tags.
Drata
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TRUSTCENTER_PRIVATE_ACCESS | |||||
| column | Primary Key Change | id 🔑 | id | No longer a primary key. | |
| column | New Column | _fivetran_id 🔑 | New primary key. | ||
Eloqua
We now sync the new activity type, ExternalActivity, to the CONTACT_ACTIVITY table. As part of this update, we’ve introduced the following columns:
external_asset_nameexternal_asset_typeexternal_type
We are gradually rolling out this change to all existing connections.
Factbird
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
LINE_STOP | |||||
| column | New Column | time_range_from | |||
| column | New Column | time_range_to | |||
STOP | |||||
| column | New Column | original_start | |||
Fivetran Platform Connector
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DESTINATION_COLUMN_METADATA (new table name: DESTINATION_COLUMN) | |||||
| table | Rename Table | DESTINATION_COLUMN_METADATA | DESTINATION_COLUMN | ||
DESTINATION_SCHEMA_METADATA (new table name: DESTINATION_SCHEMA) | |||||
| table | Rename Table | DESTINATION_SCHEMA_METADATA | DESTINATION_SCHEMA | ||
DESTINATION_TABLE_METADATA (new table name: DESTINATION_TABLE) | |||||
| table | Rename Table | DESTINATION_TABLE_METADATA | DESTINATION_TABLE | ||
SOURCE_COLUMN_METADATA (new table name: SOURCE_COLUMN) | |||||
| table | Rename Table | SOURCE_COLUMN_METADATA | SOURCE_COLUMN | ||
SOURCE_FOREIGN_KEY_METADATA (new table name: SOURCE_FOREIGN_KEY) | |||||
| table | Rename Table | SOURCE_FOREIGN_KEY_METADATA | SOURCE_FOREIGN_KEY | ||
SOURCE_SCHEMA_METADATA (new table name: SOURCE_SCHEMA) | |||||
| table | Rename Table | SOURCE_SCHEMA_METADATA | SOURCE_SCHEMA | ||
SOURCE_TABLE_METADATA (new table name: SOURCE_TABLE) | |||||
| table | Rename Table | SOURCE_TABLE_METADATA | SOURCE_TABLE | ||
Float
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PUBLIC_HOLIDAY | |||||
| table | New Table | PUBLIC_HOLIDAY | |||
TEAM_HOLIDAY | |||||
| table | New Table | TEAM_HOLIDAY | |||
Gong
We have made the following schema changes for connections created before August 29, 2025:
- Added four new columns,
call_outcome_name,call_outcome_category,call_outcome_id, andbrief, to theCALLtable. - Added a new column,
count, to theCALL_TRACKERtable. - Added five new tables,
CALL_OUTLINE,CALL_OUTLINE_ITEM,CALL_HIGHLIGHT,CALL_HIGHLIGHT_ITEM, andCALL_KEY_POINT.
Google Business Profile
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
LOCATION_INSIGHT | |||||
| table | New Table | LOCATION_INSIGHT | |||
LOCATION_KEYWORD_IMPRESSION | |||||
| table | New Table | LOCATION_KEYWORD_IMPRESSION | |||
Google Campaign Manager 360
Our Google Campaign Manager 360 connector now supports syncing metadata. For a full list of metadata tables the connector syncs, see the Google Campaign Manager 360 ERD. Only connections created on and after August 11, 2025 support syncing metadata tables.
Google Search Ads 360
We now support custom columns. When you select custom columns in any report, you'll see the following additional tables in your schema:
The
CUSTOM_COLUMNS_METADATAtable with the following columns:idcustomer.idname
The
CUSTOM_COLUMNStable with the following columns:idvalue
We are gradually rolling out these changes to all connections.
We've added support for the following fields for the CUSTOMER table:
- customer.account_level - customer.associate_manager_descriptive_name - customer.associate_manager_id - customer.manager_descriptive_name - customer.manager_id - customer.sub_manager_descriptive_name - customer.sub_manager_id
Greenhouse
We have made the following changes for connections set up before July 18, 2024:
- Changed the primary key of the
EDUCATIONtable fromidtoindex - Added the
primary_email_addresscolumn to theUSERStable - Added the
response_statuscolumn to theSCHEDULED_INTERVIEWERtable - Removed the
is_primarycolumn from theUSER_EMAILtable - Renamed the
TAGtable toTAGS - Renamed the
USERtable toUSERS - Renamed the
demographic_questioncolumn of theDEMOGRAPHIC_ANSWER_OPTIONtable todemographic_question_id - Renamed the following columns of the
EMAILtable:fromtofrom_emailtototo_emailin the
- Renamed the following columns of the
EMAIL_TEMPLATEtable:defaulttois_defaultfromtofrom_email
- Renamed the
endcolumn of theSCHEDULED_INTERVIEWtable toends
Help Scout
We have made the following changes for connections set up before June 26, 2024:
- Renamed the
ordercolumn of theMAILBOX_WORKFLOW_HISTORYtable toorders - Renamed the
rating_commentscolumn of theHAPPINESS_RATINGtable torating_comment
Hubspot
We now capture deletes for the CUSTOM_OBJECTS table.
Intercom
We have made the following schema changes:
- Added a new table,
TICKET_STATE. - Added a new column,
enabled_push_messaging, to theCONTACT_HISTORYtable. - Added a new column,
app_package_code, to theTICKET_PART_HISTORYtable.
Iterable
We have added a new table, LIST_USER. We are gradually rolling out this change to all existing connections.
We will discontinue the email_list_ids column from the USER_HISTORY table on October 13, 2025, because the LIST_USER table contains the same data.
Lever
We have made the following changes for connections set up before July 27, 2024:
Added the following new tables:
FEEDBACK_FORM_SCORE_CARD_SUB_FIELDFEEDBACK_FORM_TEMPLATE_FIELDPOSTING_FORM_SCORE_CARD_SUB_FIELDPOSTING_FORM_TEMPLATE_FIELDPROFILE_FORM_SCORE_CARD_SUB_FIELDPROFILE_FORM_TEMPLATE_FIELDREFERRAL_FORM_SCORE_CARD_SUB_FIELDREFERRAL_FORM_TEMPLATE_FIELD
Removed the
SCORE_CARD_SUB_FIELDandTEMPLATE_FIELDtablesRenamed the
USERtable toUSERSRenamed the
endcolumn of thePANELtable toendsRenamed the
custom_field_*column of theREQUISITIONtable tocustom_fields_*Renamed the primary key,
tag, of theOPPORTUNITY_TAGandPOSTING_TAGtables totagsChanged the primary key of the
OFFERtable to a composite key consisting of theidandopportunity_idcolumnsChanged the primary key of the
FILEtable to a composite key consisting of theidandcontact_idcolumns
Mandrill
We have made the following changes for connections set up before June 19, 2024:
Renamed the
timestampcolumn of the following tables totimestamps:EVENTMESSAGEMESSAGE_SMTP_EVENT
Renamed the
tagcolumn of theMESSAGE_TAGtable totags
PayPal
We have made the following changes for connections set up before June 21, 2024:
Renamed the following columns of the
DISPUTEtable:return_shipping_address_line_1toreturn_shipping_address_address_line_1return_shipping_address_line_2toreturn_shipping_address_address_line_2return_shipping_address_line_3toreturn_shipping_address_address_line_3
Renamed the following columns of the
TRANSACTIONtable:auctionitem_sitetoauction_item_siteavailable_balance_amounttoavailable_balance_valueshipping_address_*toshipping_info_address_*shipping_methodtoshipping_info_methodshipping_nametoshipping_info_nameshipping_secondary_address_*toshipping_info_secondary_address_*
Renamed the following columns of the
TRANSACTION_ITEM_DETAILtable:insurance_amount_amounttoinsurance_amountinsurance_amount_currency_codetoinsurance_currency_code
Pipedrive
We have added a new table, DEAL_FIELD. We are gradually rolling out this change to all connections.
We have added a new child table, INSTALLMENT, to the DEAL_HISTORY table. We are gradually rolling out this change to all connections.
Pylon Support Platform
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTACT | |||||
| table | New Table | CONTACT | |||
Recharge
We have made the following changes for connections set up before June 18, 2024:
Replaced the
UTM_TAGtable with the following new tables:CHARGE_UTM_TAGCHECKOUT_UTM_TAGCUSTOMER_UTM_TAGSUBSCRIPTION_UTM_TAG
Renamed the
ORDERtable toORDERSRenamed the
subscription_idcolumn of theSUBSCRIPTION_HISTORYtable toidAdded a new column,
buyer_accepts_marketing, to theCHECKOUTtableStopped syncing data into the
is_deletedcolumn for the following tables, as this information is already available in the_fivetran_deletedcolumn:ONE_TIME_PRODUCTORDERSCHARGECUSTOMER
Sailthru
We have changed the primary key of the following tables from message_id to event_id:
ES_CAMPAIGN_SENDSES_CAMPAIGN_OPENSES_CAMPAIGN_CLICKSES_CAMPAIGN_BOUNCESES_CAMPAIGN_UNSUBSCRIBESES_TRIGGERED_SENDSES_TRIGGERED_OPENSES_TRIGGERED_CLICKSES_TRIGGERED_BOUNCESES_TRIGGERED_UNSUBSCRIBES
The new primary key field, the event_id field, is present for records from March 20th, 2025, onwards. The existing records in these tables will be moved to backup tables whose names contain the suffix _backup.
Salesforce Commerce Cloud
We have discontinued the ADDRESS table and will no longer sync it. Use the CUSTOMER_ADDRESS table.
Samsara
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ADDRESS | |||||
| column | New Column | external_id | |||
DRIVER | |||||
| column | New Column | external_id | |||
FUEL_ENERGY_BY_DRIVER_REPORT | |||||
| table | New Table | FUEL_ENERGY_BY_DRIVER_REPORT | |||
FUEL_ENERGY_BY_VEHICLE_REPORT | |||||
| table | New Table | FUEL_ENERGY_BY_VEHICLE_REPORT | |||
ROUTE | |||||
| column | New Column | external_id | |||
ROUTE_STOP | |||||
| column | New Column | external_id | |||
TAGS | |||||
| column | New Column | external_id | |||
TRAILER | |||||
| column | New Column | external_id | |||
VEHICLE | |||||
| column | New Column | external_id | |||
VEHICLE_IDLING_REPORT | |||||
| column | Discontinued Column | external_id_* | |||
SAP Concur
We have added a new field, expense_id, to the EXPENSE_ENTRY table.
We have added a new table, EXPENSE_COMMENT.
We are gradually rolling out this change to all existing connections.
Shopify
We've updated the Shopify connector schema. The new schema only applies to Fivetran accounts created on or after August 1, 2025.
We have added the following new tables:
BUNDLE_COMPONENTBUNDLE_COMPONENT_OPTION_SELECTIONBUNDLE_COMPONENT_VARIANTCOMPANY_LOCATIONCOMPANY_LOCATION_CATALOGCOMPANY_LOCATION_TAX_EXEMPTIONMARKETING_EVENTSALESALE_TAXSALES_AGREEMENT
We are gradually rolling out these changes to all connections. These new tables' MAR will be free until September 30, 2025.
Short.io
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DOMAIN_STATISTICS_BROWSER | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | browser | browser 🔑 | Added to primary key. | |
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
DOMAIN_STATISTICS_CITY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | city | city 🔑 | Added to primary key. | |
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
DOMAIN_STATISTICS_COUNTRY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | country | country 🔑 | Added to primary key. | |
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
DOMAIN_STATISTICS_OS | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | os | os 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
DOMAIN_STATISTICS_REFERER | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | referer | referer 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
DOMAIN_STATISTICS_SOCIAL | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | domain_statistics_domain_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | social | social 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
LINK | |||||
| column | Primary Key Change | domain_id | domain_id 🔑 | Added to primary key. | |
| column | Discontinued Column | updated_at | . | ||
LINK_STATISTICS | |||||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
LINK_STATISTICS_BROWSER | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | browser | browser 🔑 | Added to primary key. | |
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_STATISTICS_CITY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | city | city 🔑 | Added to primary key. | |
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_STATISTICS_COUNTRY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | country | country 🔑 | Added to primary key. | |
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_STATISTICS_OS | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | os | os 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_STATISTICS_REFERER | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | referer | referer 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_STATISTICS_SOCIAL | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | link_statistics_link_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | social | social 🔑 | Added to primary key. | |
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
| column | Primary Key Change | link_id 🔑 | New primary key. | ||
LINK_TAG | |||||
| column | Primary Key Change | domain_id 🔑 | New primary key. | ||
Sprout Social
We have added a new table, MESSAGE. We are gradually rolling out this change to all existing connections.
Survicate
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
NUMERICAL_SCALE_RESPONSE | |||||
| table | New Table | NUMERICAL_SCALE_RESPONSE | |||
Tableau
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DATA_LENS | |||||
| table | Discontinued Table | DATA_LENS | |||
TikTok Organic
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PROFILE_METRIC | |||||
| column | Primary Key Change | date | date 🔑 | Added to primary key. | |
| column | Discontinued Column | index 🔑 | No longer a primary key. | ||
PROFILE_METRIC_AUDIENCE_ACTIVITY | |||||
| column | Primary Key Change | hour | hour 🔑 | Added to primary key. | |
| column | Discontinued Column | index 🔑 | No longer a primary key. | ||
| column | Discontinued Column | profile_metric_index 🔑 | No longer a primary key. | ||
| column | Primary Key Change | date 🔑 | Added to primary key. | ||
Typeform
We have added a new table, RESPONSE_TAG.
Workday Financial Management
We have fixed a bug and rectified the values of the included_ledger_account_id and included_ledger_account_code columns of the ALL_INCLUDED_LEDGER_ACCOUNT table. We have also removed the incorrect records in the ALL_INCLUDED_LEDGER_ACCOUNT table in your destination.
Workday HCM
We no longer sync data for the time_calculation_tag_code column in the CALCULATED_TIME_BLOCK table. We now sync this data in the new CALCULATION_TAG table, which is a child table of CALCULATED_TIME_BLOCK.
Xero
We have added a new column, item_id, to the INVOICE_LINE_ITEM table.
Zendesk Chat
We have made the following changes for connections set up before July 23, 2024:
Renamed the
timestampcolumn of the following tables totimestamps:CHATCHAT_HISTORYENGAGEMENT
Renamed the primary key,
tag, of theCHAT_TAGtable totags
Zoho Inventory
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BILL | |||||
| column | New Column | location_id | |||
BILL_LINE_ITEM | |||||
| column | Discontinued Column | warehouse_id | |||
| column | New Column | location_id | |||
INVENTORY_ADJUSTMENT | |||||
| column | Discontinued Column | warehouse_id | |||
| column | New Column | location_id | |||
INVOICE | |||||
| column | New Column | location_id | |||
INVOICE_LINE_ITEM | |||||
| column | Discontinued Column | warehouse_id | |||
| column | New Column | location_id | |||
LOCATION | |||||
| table | New Table | LOCATION | |||
LOCATION_ASSOCIATED_SERIES | |||||
| table | New Table | LOCATION_ASSOCIATED_SERIES | |||
LOCATION_ASSOCIATED_USER | |||||
| table | New Table | LOCATION_ASSOCIATED_USER | |||
SALES_ORDER | |||||
| column | New Column | location_id | |||
SALES_ORDER_LINE_ITEM | |||||
| column | Discontinued Column | warehouse_id | |||
| column | New Column | location_id | |||
TRANSFER_ORDER | |||||
| column | Discontinued Column | from_warehouse_id | |||
| column | Discontinued Column | from_warehouse_name | |||
| column | Discontinued Column | to_warehouse_id | |||
| column | Discontinued Column | to_warehouse_name | |||
| column | New Column | from_location_id | |||
| column | New Column | from_location_name | |||
| column | New Column | to_location_id | |||
| column | New Column | to_location_name | |||
WAREHOUSE | |||||
| table | Discontinued Table | WAREHOUSE | Data is available in the LOCATION table. | ||
WAREHOUSE_SALES_CHANNEL | |||||
| table | Discontinued Table | WAREHOUSE_SALES_CHANNEL | Data is available in the LOCATION table. | ||
Improvements
Ada
We now use the Ada v2 API to retrieve data from the conversations endpoint. We now use the /api/v2/export/conversations endpoint to sync the CONVERSATION table. Previously, we used /data_api/v1.4/conversations. We are gradually rolling out this change to all connections.
BigCommerce
We have made the following changes to the Schema tab for connections set up before July 19, 2024:
- We display all table names in lowercase
- We display all the tables, including the empty tables
- We no longer support table-level selection or deselection
Box
We now support syncing files to multiple destination tables and handling file patterns in Merge Mode. To support these features, we have made the following changes to the connection setup form:
- Added the Files field and sub-fields Table name and File pattern, that enable you to define destination tables and specify the file pattern names.
- Renamed the Destination table field to Table group name to enable unique identification of connections that share the same destination schema name.
For more information, see our setup instructions and REST API configuration. We are gradually rolling out these enhancements to all existing connections.
Brex
We now support priority-first sync for the EXPENSE table. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use.
CockroachDB
We now support CockroachDB versions 24.1.0 - 25.3.0.
Databricks Lakebase for PostgreSQL
Our Databricks Lakebase for PostgreSQL destination is now generally available.
Read our Databricks Lakebase for PostgreSQL destination documentation.
Datadog
We now capture all the data of custom fields returned by the Datadog API’s Incidents endpoint in the INCIDENT_FIELD table.
Delighted
We have made the following changes to the Schema tab for connections set up before April 26, 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 made the following changes to the connection setup form:
- Added support to configure archive patterns per table. This is useful when an archive folder contains files following different naming patterns, allowing you to route each pattern to a specific destination table based on its pattern.
- Renamed the Archive Folder Pattern field to Archive File Pattern.
For more information, see our setup instructions
Factbird
We have changed our sync strategy for Factbird connections:
- We now sync historical data for your connection starting from January 1, 2019.
- We now sync data for the
OEEtable daily. - We now incrementally sync the
BATCHtable and its child tables to capture newly added and updated records.
File Connectors
We have added a new toggle, Manually provide cell reference, to the setup form of the following connectors:
- Amazon S3
- Box
- Dropbox
- SFTP
- SharePoint
You can now manually specify a cell reference for the file path instead of using the default automatic detection.
FTP
We have improved the setup experience for FTP connections.
- Added a new configuration option, Run connection test to perform an intermediate test during configuration
- Added a new configuration option, Preview Files to perform an intermediate test during configuration
- Added support for displaying fields based on the file type
- Added a new field, Quote character, to use an enclosing character
- Reorganised fields to make the setup form more intuitive
- Removed Infer as an option from the File Type field
- Removed the Enable Advanced Options toggle
- Changed the Null Sequence field to a toggle
- For the Delimiter character(s) field, we now use
,as the default value - For the Line Separator field, we now use
\nas the default value
For more information, see our setup instructions and REST API configuration.
We are gradually rolling out these changes to all existing connections.
Google Ad Manager
Starting on August 11, 2025, new connections created in the dashboard become multi-reporting connections.
We have upgraded our Google Ad Manager connector from version 202411 to 202505 of the Google Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in the Google Ad Manager API documentation.
Google Campaign Manager 360
You can now choose several Floodlight Configuration IDs in the Google Campaign Manager 360 FLOODLIGHT and PATH_TO_CONVERSION reports. We are gradually rolling out this change to all existing connections.
Starting from August 11, 2025, newly created connections will support adding multiple reports. For more information, see the Google Campaign Manager 360 setup guide.
Gorgias
We no longer capture deletes for the CUSTOMER table and its child tables.
Greenhouse
We have made the following changes to the Schema tab for connections set up before July 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
Healthie
We have changed our sync strategy and now re-import all tables during every sync.
Help Scout
We have made the following changes to the Schema tab for connections set up before June 26, 2024:
- We display all table names in lowercase
- We display all the tables, including the empty tables
- We no longer support table-level selection or deselection
Ironclad
We have updated our sync strategy. We now incrementally sync the RECORD table. Previously, we re-imported the RECORD table during every sync.
Lever
We have made the following changes to the Schema tab for connections set up before July 27, 2024:
- We display all table names in lowercase
- We display all the tables, including the empty tables
We now store data only from the Lever API's Opportunity endpoint in the OPPORTUNITY table and its child tables. Previously, this table included data from both the Opportunity and Candidate endpoints.
Managed Data Lake Service
We have published Fivetran Iceberg REST Catalog Postman collection, which helps you get metadata from tables stored in your Fivetran Iceberg REST Catalog.
Mandrill
We have made the following changes to the Schema tab for connections set up before June 19, 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 Use Template Labels toggle and Template labels field from the connection setup form.
Marketo
We have made changes to our Marketo connection setup form and REST API parameters to support the Marketo SOAP API deprecation. These changes won't impact how your connection syncs data to your destination.
We have removed the Provide SOAP API Credentials for BULK API Quota Estimation toggle and the following related fields from the connection setup form:
- SOAP API User Id
- SOAP API Encryption Key
- SOAP API Endpoint
Similarly, we have discontinued the following parameters from the REST API Configuration:
user_idencryption_keysoap_uri
MongoDB
We no longer support the _id fields of BSON_DB_POINTER, BSON_SYMBOL, and SYMBOL data types during historical or incremental syncs of a collection. Learn more in our MongoDB documentation.
MySQL
We have fixed a data inconsistency issue for MySQL and MariaDB connections that use Fivetran Teleport Sync, where during the initial sync, we converted the TIMESTAMP values to UTC in your destination, but in subsequent updates, we converted these values using the source's timezone configuration. We now always convert TIMESTAMP values to UTC in your destination. This change is consistent with how we handle these values for connections using the binary log update method.
To fix existing values in your destination, contact our support team to re-sync the affected tables and understand the MAR impact.
We now support AWS IAM database authentication for our Amazon Aurora MySQL, RDS MySQL, and RDS MariaDB connectors.
PayPal
We have made the following changes to the Schema tab for connections set up before June 21, 2024:
- We display all table names in lowercase
- We display all the tables, including the empty tables
PostgreSQL ctid improvement
We now support syncing tables without primary keys (PK-less) and tables with unsupported primary key types when using the Fivetran Teleport Sync method for the PostgreSQL connector. Previously we supported only tables with primary keys of following types for Fivetran Teleport Sync:
- character varying (with specified maximum length)
- text
- uuid
- smallint
- int
- bigint
- numeric (with specified precision)
- date
We can now sync tables with primary keys of all data types using a special PostgreSQL system column ctid. Previously, the Fivetran Teleport Sync method did not support syncing PK-less tables and tables that had strict type requirements on primary key as mentioned above.
Recharge
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_CHARGEMETA_FIELD_CUSTOMERMETA_FIELD_ORDERMETA_FIELD_STOREMETA_FIELD_SUBSCRIPTION
Sage Intacct
Now, when we encounter an API check failure during a sync, we temporarily exclude the complete endpoint, including the parent table and all the associated child tables, from the sync. We try to automatically retrieve the endpoints in subsequent syncs.
Salesforce
We have upgraded our Salesforce connector from version 63.0 to 64.0 of the Salesforce REST API. For more information, see Salesforce's changelog.
We are gradually rolling out this change to all existing connections.
ServiceNow
You can now sync columns from parent tables to child tables by using the Inherited columns mode. We are gradually rolling out these changes to all existing connections.
See our Syncing columns from parent tables to child tables documentation to learn more.
Short.io
We have made the following changes to our sync strategy for the LINK table and its child tables:
We no longer re-import these tables to capture updates and deletes.
We now sync only the last 6 month's worth of data during historical syncs.
Square
We have changed the sync strategy for the following tables:
GIFT_CARD_ACTIVITYREFUNDADDITIONAL_REFUND_RECIPIENTSHIFTSHIFT_BREAK
We now incrementally sync them to capture new records.
We also re-import these tables to capture updates and deletes. The re-import frequency depends on the duration of the last re-import for the table:
- If the last re-import took less than 2 hours, we re-import the table once a day.
- If the last re-import took more than 2 hours, we re-import the table once a week on Saturdays.
We are gradually rolling out these changes to all existing connections.
Swoogo
We have fixed a bug where the TRANSACTION table in your destination did not contain the payment_gateway_name and registrant_id columns, even though they were defined in the connection schema. The table now correctly includes these columns.
Workday Financial Management
We have removed the toggle button to choose between different OAuth authentication options in the setup form for all connections set up before February 25, 2025. For all connections, we now only support API client for integrations method if you use OAuth based authentication.
Workday HCM
We have removed the toggle button to choose between different OAuth authentication options in the setup form for all connections set up before February 25, 2025. For all connections, we now only support API client for integrations method if you use OAuth based authentication.
Xero
We have updated the CONTACT_ADDRESS table to correctly store multiple addresses per contact.
Zendesk Chat
We have made the following changes to the Schema tab for connections set up before July 23, 2024:
- We display all table names in lowercase
- We display all the tables, including the empty tables
REST API Improvements
Deprecated config parameters for Google Campaign Manager 360
As of August 11, 2025, the Fivetran REST API no longer supports the following configuration parameters for Google Campaign Manager 360 connections:
conversion_dimensionscustom_floodlight_variablesdimensionsenabble_all_dimension_combinationsmetricsper_interaction_dimensionsreport_configuration_idsreport_type
We will fully sunset these parameters on November 11, 2025.
Google Search Ads 360
We've introduced the custom_column_ids API parameter for configuring your Google Search Ads 360 custom reports. We are gradually rolling out these changes to all customers.