May 2026
Quickstart Transformations
Multi-source Quickstart packages during connection setup
When you set up a connection for a connector that supports multi-source Quickstart packages, such as Ad Reporting, Fivetran now prompts you to configure a Quickstart transformation automatically after the connection tests pass. You can choose to join an existing multi-source transformation or create a new one — in both cases, only multi-source transformations are available for these connector types. For more information, see the Quickstart management page.
Schema changes
Adyen
We have added a new table, AGGREGATE_SETTLEMENT_DETAILS_REPORT.
Amazon Ads
Due to Amazon deprecating V2 Stores, we've updated our connector to use the new endpoints that replace it.
The old endpoint:
- /v2/stores
The new endpoints (for more details, see Amazon Ads documentation):
- /brand/stores/v1/stores/list
- /brand/stores/v1/storePages/list
Related tables were slightly changed in the following manner:
- We've added the field
store_statusto theSB_STOREtable - We've added the field
store_page_statusto theSB_STORE_PAGE_INFOtable
ClickUp
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TIME_ENTRY_TASK_TAG | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Calculation Change | |
| column | Discontinued Column | task_id | |||
| column | New Column | time_entry_id | |||
Coupa
We have removed the RECEIPT table.
We have removed the receipt_id column from the INVENTORY_TRANSACTION table.
Kantata
We've added a new table, COST_RATE. The table contains hourly cost rates for account members in specific currencies.
QuickBooks
We've added the following new tables:
BILL_PAYMENT_LINE_LINKED_TXNBILL_TAX_LINE_DETAILCREDIT_MEMO_TAX_LINE_DETAILDEPOSIT_TAX_LINE_DETAILPURCHASE_ORDER_LINE_LINKED_TXN
We are gradually rolling out this change to all existing connections.
Rokt
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ACCOUNT_CAMPAIGN_BREAKDOWN | |||||
| column | Discontinued Column | acquisitions_by_conversion_date | |||
| column | Discontinued Column | acquisitions_by_referral_date | |||
| column | Discontinued Column | audiences | |||
| column | Discontinued Column | campaign_countries | |||
| column | Discontinued Column | campaigns | |||
| column | Discontinued Column | creatives | |||
| column | Discontinued Column | date_end | |||
| column | Discontinued Column | date_start | |||
| column | Discontinued Column | group_by_value 🔑 | No longer primary key | ||
| column | Discontinued Column | impressions | |||
| column | Discontinued Column | referrals | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | device | |||
| column | New Column | impression | |||
| column | New Column | referral | |||
| column | New Column | unique_audience | |||
| column | New Column | unique_campaign | |||
| column | New Column | unique_campaign_country | |||
| column | New Column | unique_creative | |||
ACCOUNT_SUMMARY | |||||
| column | Discontinued Column | campaign_summary_acquisitions_by_conversion_date | |||
| column | Discontinued Column | campaign_summary_acquisitions_by_referral_date | |||
| column | Discontinued Column | campaign_summary_audiences | |||
| column | Discontinued Column | campaign_summary_campaign_countries | |||
| column | Discontinued Column | campaign_summary_campaigns | |||
| column | Discontinued Column | campaign_summary_creatives | |||
| column | Discontinued Column | campaign_summary_gross_cost | |||
| column | Discontinued Column | campaign_summary_impressions | |||
| column | Discontinued Column | campaign_summary_net_cost | |||
| column | Discontinued Column | campaign_summary_referrals | |||
| column | Primary Key Change | date_end 🔑 | date_end | No longer primary key | |
| column | Primary Key Change | date_start 🔑 | date_start | No longer primary key | |
| column | Discontinued Column | transaction_summary_impressions | |||
| column | Discontinued Column | transaction_summary_placement_impressions | |||
| column | Discontinued Column | transaction_summary_positive_placement_engagements | |||
| column | Discontinued Column | transaction_summary_purchases | |||
| column | Discontinued Column | transaction_summary_referrals | |||
| column | Discontinued Column | transaction_summary_revenue | |||
| column | Discontinued Column | transaction_summary_rpm | |||
| column | Discontinued Column | transaction_summary_rpt | |||
| column | Discontinued Column | transaction_summary_transactions | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | campaign_country 🔑 | New primary key | ||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | New Column | click_thru_acquisitions | |||
| column | New Column | click_thru_acquisitions_by_conversion_time | |||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | gross_cost | |||
| column | New Column | impressions | |||
| column | New Column | net_cost | |||
| column | New Column | referrals | |||
| column | New Column | unique_audiences | |||
| column | New Column | unique_campaign_countries | |||
| column | New Column | unique_campaigns | |||
| column | New Column | unique_creatives | |||
ACCOUNT_TRANSACTION_BREAKDOWN | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Calculation Change | |
| column | Discontinued Column | group_by_value | |||
| column | Discontinued Column | placement_impressions | |||
| column | Discontinued Column | positive_placement_engagements | |||
| column | New Column | age_range | |||
| column | New Column | datetime | |||
| column | New Column | gender | |||
| column | New Column | layout_impressions | |||
| column | New Column | page_type | |||
| column | New Column | partner_id | |||
| column | New Column | positive_layout_engagements | |||
ACCOUNT_TRANSACTION_OVERVIEW | |||||
| column | Primary Key Change | date_end 🔑 | date_end | No longer primary key | |
| column | Primary Key Change | date_start 🔑 | date_start | No longer primary key | |
| column | Discontinued Column | placement_impression | |||
| column | Discontinued Column | positive_placement_engagement | |||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | layout_impressions | |||
| column | New Column | positive_layout_engagements | |||
CAMPAIGN_BREAKDOWN_AUDIENCE | |||||
| column | Discontinued Column | account_campaign_breakdown_value 🔑 | No longer primary key | ||
| column | Discontinued Column | acquisitions_by_conversion_date | |||
| column | Discontinued Column | acquisitions_by_referral_date | |||
| column | Discontinued Column | audiences | |||
| column | Discontinued Column | campaign_countries | |||
| column | Discontinued Column | campaigns | |||
| column | Discontinued Column | creative_name | |||
| column | Discontinued Column | creatives | |||
| column | Discontinued Column | date_end | |||
| column | Discontinued Column | date_start | |||
| column | Discontinued Column | group_by_value 🔑 | No longer primary key | ||
| column | Discontinued Column | impressions | |||
| column | Discontinued Column | referrals | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | audience_name 🔑 | New primary key | ||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | device | |||
| column | New Column | impression | |||
| column | New Column | referral | |||
| column | New Column | unique_audience | |||
| column | New Column | unique_campaign | |||
| column | New Column | unique_campaign_country | |||
| column | New Column | unique_creative | |||
CAMPAIGN_BREAKDOWN_COUNTRY | |||||
| column | Discontinued Column | account_campaign_breakdown_value 🔑 | No longer primary key | ||
| column | Discontinued Column | acquisitions_by_conversion_date | |||
| column | Discontinued Column | acquisitions_by_referral_date | |||
| column | Discontinued Column | audiences | |||
| column | Discontinued Column | campaign_countries | |||
| column | Discontinued Column | campaigns | |||
| column | Discontinued Column | creative_name | |||
| column | Discontinued Column | creatives | |||
| column | Discontinued Column | date_end | |||
| column | Discontinued Column | date_start | |||
| column | Discontinued Column | group_by_value 🔑 | No longer primary key | ||
| column | Discontinued Column | impressions | |||
| column | Discontinued Column | referrals | |||
| column | Discontinued Column | results_grouped_by | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | campaign_country 🔑 | New primary key | ||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | device | |||
| column | New Column | impression | |||
| column | New Column | referral | |||
| column | New Column | unique_audience | |||
| column | New Column | unique_campaign | |||
| column | New Column | unique_campaign_country | |||
| column | New Column | unique_creative | |||
CAMPAIGN_BREAKDOWN_CREATIVE | |||||
| column | Discontinued Column | account_campaign_breakdown_value 🔑 | No longer primary key | ||
| column | Discontinued Column | acquisitions_by_conversion_date | |||
| column | Discontinued Column | acquisitions_by_referral_date | |||
| column | Discontinued Column | audiences | |||
| column | Discontinued Column | campaign_countries | |||
| column | Discontinued Column | campaigns | |||
| column | Discontinued Column | creatives | |||
| column | Discontinued Column | date_end | |||
| column | Discontinued Column | date_start | |||
| column | Discontinued Column | group_by_value 🔑 | No longer primary key | ||
| column | Discontinued Column | impressions | |||
| column | Discontinued Column | referrals | |||
| column | Discontinued Column | results_grouped_by | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | Primary Key Change | creative_id 🔑 | New primary key | ||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | device | |||
| column | New Column | impression | |||
| column | New Column | referral | |||
| column | New Column | unique_audience | |||
| column | New Column | unique_campaign | |||
| column | New Column | unique_campaign_country | |||
| column | New Column | unique_creative | |||
CAMPAIGN_BREAKDOWN_SUBVERTICAL | |||||
| column | Discontinued Column | account_campaign_breakdown_value 🔑 | No longer primary key | ||
| column | Discontinued Column | acquisitions_by_conversion_date | |||
| column | Discontinued Column | acquisitions_by_referral_date | |||
| column | Discontinued Column | audiences | |||
| column | Discontinued Column | campaign_countries | |||
| column | Discontinued Column | campaigns | |||
| column | Discontinued Column | creatives | |||
| column | Discontinued Column | date_end | |||
| column | Discontinued Column | date_start | |||
| column | Discontinued Column | group_by_value 🔑 | No longer primary key | ||
| column | Discontinued Column | impressions | |||
| column | Discontinued Column | referrals | |||
| column | Discontinued Column | results_grouped_by | |||
| column | New Column | acquisitions_by_conversion_time | |||
| column | Primary Key Change | campaign_id 🔑 | New primary key | ||
| column | Primary Key Change | datetime 🔑 | New primary key | ||
| column | New Column | device | |||
| column | New Column | impression | |||
| column | Primary Key Change | partner_sub_vertical 🔑 | New primary key | ||
| column | New Column | referral | |||
| column | New Column | unique_audience | |||
| column | New Column | unique_campaign | |||
| column | New Column | unique_campaign_country | |||
| column | New Column | unique_creative | |||
CAMPAIGN_HISTOGRAM | |||||
| table | Discontinued Table | CAMPAIGN_HISTOGRAM | |||
Salesforce
We have implemented a new synthetic primary key column, _fivetran_hashid, for the ActivityFieldHistory table to improve data reliability and query performance. Previously, we used a composite primary key.
The _fivetran_hashid column is a hash of all the columns in the table and ensures that each record is unique, even when the source data lacks a reliable primary key.
We are gradually rolling out this change to all existing Salesforce and Salesforce Sandbox connections.
To minimize the impact of this primary key change, Monthly Active Rows MAR for the ActivityFieldHistory table will be free through May 27, 2026.
Samsara
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DRIVER | |||||
| column | New Column | driver_activation_status | |||
| column | New Column | has_driving_features_hidden | |||
| column | New Column | has_vehicle_unpinning_enabled | |||
| column | New Column | heavy_haul_exemption_toggle_enabled | |||
| column | New Column | phone_number | |||
| column | New Column | static_assigned_vehicle_id | |||
| column | New Column | vehicle_group_tag_id | |||
| column | New Column | waiting_time_duty_status_enabled | |||
DRIVER_ATTRIBUTE | |||||
| table | New Table | DRIVER_ATTRIBUTE | |||
DRIVER_RULESET | |||||
| table | New Table | DRIVER_RULESET | |||
FORM_SUBMISSION_STREAM | |||||
| table | New Table | FORM_SUBMISSION_STREAM | |||
FORM_SUBMISSION_STREAM_FIELD | |||||
| table | New Table | FORM_SUBMISSION_STREAM_FIELD | |||
FORM_SUBMISSION_STREAM_FIELD_MEDIA_LIST | |||||
| table | New Table | FORM_SUBMISSION_STREAM_FIELD_MEDIA_LIST | |||
FORM_SUBMISSION_STREAM_FIELD_TABLE_VOLUME_COLUMN | |||||
| table | New Table | FORM_SUBMISSION_STREAM_FIELD_TABLE_VOLUME_COLUMN | |||
FORM_TEMPLATE | |||||
| table | New Table | FORM_TEMPLATE | |||
FORM_TEMPLATE_FIELD | |||||
| table | New Table | FORM_TEMPLATE_FIELD | |||
FORM_TEMPLATE_FIELD_CONDITIONAL_ACTION | |||||
| table | New Table | FORM_TEMPLATE_FIELD_CONDITIONAL_ACTION | |||
FORM_TEMPLATE_FIELD_OPTION | |||||
| table | New Table | FORM_TEMPLATE_FIELD_OPTION | |||
FORM_TEMPLATE_SECTION | |||||
| table | New Table | FORM_TEMPLATE_SECTION | |||
Sprout Social
We have added a new column, followers_by_country, to the TIKTOK_PROFILE_ANALYTIC table.
We have added the following new columns to the INSTAGRAM_PROFILE_ANALYTIC table:
followers_by_age_genderfollowers_by_cityfollowers_by_country
We are gradually rolling out these changes to all connections.
TikTok Ads
We've added a new table, CREATIVE_HISTORY. The table syncs creatives data specific to upgraded Smart+ campaigns. Currently, the same data is also synced to the AD_HISTORY table, however, we will remove the duplicated data in the future.
Visma
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
GENERAL_LEDGER_TRANSACTION | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Primary Key Change | ledger_id 🔑 | ledger_id | No longer a primary key. | |
Workday Financial Management
We have added the following new tables to support the Workday Financial_Management module:
BUSINESS_PLAN_DETAILBUSINESS_PLAN_ENTRY_LINEBUSINESS_PLAN_ENTRY_LINE_WORKTAG
To sync these tables, enable the security domains necessary for the Financial Management module.
Improvements
Adobe Analytics Data Feed
Now, the following columns in each report suite's main data table contain human-readable values that we resolve from the Adobe lookup files:
first_hit_search_engineref_typevisit_search_engine
Previously, the values were raw numeric IDs.
The changes are consistent with how we sync matching non-prefixed and post_* columns (such as search_engine, post_search_engine, visit_ref_type, and first_hit_ref_type).
Assembled
We have added a new optional drop-down menu, Return Full Schedule, to the connection setup form. You can now enable this query parameter for the ACTIVITY table in your connection to retrieve data as per your requirement. The parameter returns all events, including overlapping ones. By default, the value is set to false. For more information, see our setup instructions. return_full_schedule is the REST API Config parameter.
Braze
We now support user profile exports configured with Azure Blob Storage. For more information, see our Braze documentation.
Jira
You can now authenticate your Jira connection using a service account. For more information, see our setup instructions.
SAP Concur
We've updated our sync strategy for the ALLOCATION table to improve data accuracy and consistency. We now sync the ALLOCATION table as a child table of both the ITEMIZATION and EXPENSE_ENTRY tables to handle known data discrepancies.
We have also changed the composite primary key of the ALLOCATION table. The new primary key consists of the allocation_id, itemization_id, and expense_entry_id columns. Previously, the primary key consisted of the allocation_id and itemization_id columns.
As part of this improvement, we will re-sync the REPORT endpoint to fix historical discrepancies in the ALLOCATION table. This re-sync will not impact your MAR usage. We are gradually rolling out this change to all existing connections.
SAP ERP on HANA
We have added a new HANA Database Connection mode to the connector. This mode connects Fivetran directly to the SAP HANA database via JDBC, without requiring the Fivetran NetWeaver API to be installed on your SAP system. To use this mode, select HANA Database Connection in the connection setup form and provide your HANA database host, port, username, password, and schema name. For more information, see SAP ERP on HANA.
Stripe
We've updated our sync strategy for the CARD_PAYMENTS_FEES_TRANSACTION_LEVEL_1 table. To ensure that we capture any updates or missing data in existing records, we have implemented the following:
- a daily 7-day lookback window
- a weekly 30-day lookback window
We are gradually rolling out this data accuracy and consistency improvement to all existing connections.
Veeva Vault
We now support a new authentication method, OAuth 2.0, for the Veeva Vault connector. To support this enhancement, we have added the following fields to the connection setup form:
- Client ID
- Client Secret
- OIDC Profile ID
- OAuth Token Service URL
- Vault DNS
- Scope
For more information, see our setup instructions.