May 2026
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.8.2 of the fivetran-connector-sdk PyPI package. This release includes the following updates:
- Introduced support for Python-native log levels:
DEBUG,ERROR, andCRITICAL. INFOandWARNINGare already supported and work the same across both Python and Java-style levels.- We recommend using Python-native log levels in all new connector code.
- The Java-style levels
FINEandSEVEREare now deprecated. Uselog.debug()in place oflog.fine(), andlog.error()orlog.critical()in place oflog.severe(). - Existing connectors using Java-style levels continue to work without any modification.
- Minor enhancements and improvements.
- For more information, see our Connector SDK Logging Reference.
fivetran-api-playground PyPI package
We have released version 1.1.6 of the fivetran-api-playground PyPI package. This release adds the following:
- Adds rate limiting support via the
--rate-limitflag to simulate real-worldHTTP 429 Too Many Requestsresponses. - Adds
--capacityflag to configure the maximum burst size of the token bucket. - Adds
X-RateLimit-Limit,X-RateLimit-Remaining, andX-RateLimit-Resetheaders to all responses when rate limiting is enabled. - Adds
Retry-Afterheader to HTTP 429 responses indicating when the next request can be made.
Lite Connectors
Lite connectors are now available for the following sources:
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.
Salesforce Formula Fields — Improved discovery and reliability
We have updated the Quickstart formula fields logic to use the salesforce_formula_utils dbt package, which also enables formula fields for Hybrid Deployment destinations. Customers now have the option to run all formula fields or none. Formula field models that fail with subsequent errors are automatically paused. Customers can unpause them by triggering a full refresh, which will re-enable all formula fields.
Type Locking
The Type Locking feature is now available for Connector SDK and function connectors. See our Type Locking documentation to learn more.
New connectors
Db2 for z/OS
Our Db2 for z/OS connector is now in beta. For more information, see our Db2 for z/OS connector documentation.
Slack Admin Data
The Slack Admin Data connector is now generally available.
Read our Slack Admin Data connector documentation.
Schema changes
AdRoll
We have added new metric columns to the ALL_ADS, ALL_ADGROUPS, ALL_CAMPAIGNS, and ALL_ADVERTISABLES report types. These columns contain additional metrics returned by the AdRoll reporting API.
New columns
averageOrderValueclickROAScpccpmdailyBounceRatedailyEngagedVisitorCostdailyEngagedVisitorsdailyNewVisitorCostdailyNewVisitorsdailyReturnVisitorsdeviceFrequencyemailBouncedemailDeliveryRateemailMarkedSpamemailScheduledemailSentConfirmedemailSentUnconfirmedemailUniqueClickemailUniqueClickRateemailUniqueMarkedSpamemailUniqueOpenemailUniqueOpenRateemailUniqueUnsubscribeRateemailUniqueUnsubscribersemailUnsubscribersfrequencyinfluencedRevenueinfluencedThroughsrevenueroassendssmsClickssmsSentDeliveredtotalUniqueHHsReacheduniqueHHSiteVisitsvideoCompletionRatevideoFiftyPercentvideoHundredPercentvideoImpressionsvideoSeventyFivePercentvideoTwentyFivePercentvideoViewsviewROAS
The following existing columns are deprecated in the AdRoll API:
roi— useroasinsteadclickROI— useclickROASinsteadviewROI— useviewROASinstead
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
Due to Amazon deprecating V2 Suggested Keyword, we've updated our connector to use the new endpoints that replace it.
The old endpoint:
- /v2/sp/adGroups/{adGroupId}/suggested/keywords/extended
- /v2/sp/asins/{asin}/suggested/keywords
The new endpoints (for more details, see Amazon Ads documentation):
- /sp/targets/keywords/recommendations
We have added the following columns to the AD_GROUP_SUGGESTED_KEYWORD and ASIN_SUGGESTED_KEYWORD tables:
rec_idsearch_term_impression_ranksearch_term_impression_sharetranslationuser_selected_keyword
We've discontinued support for the match_type and state columns from the AD_GROUP_SUGGESTED_KEYWORD table:
match_typestate
We've discontinued support for the match_type column from the ASIN_SUGGESTED_KEYWORD table.
Amazon Selling Partner
We have removed the SUBSCRIBE_AND_SAVE_FORECAST_REPORT and SUBSCRIBE_AND_SAVE_PERFORMANCE_REPORT tables.
Apple App Store
We've added a new table, APP_STORE_IN_APP_PURCHASE. The table contains in-app purchase metadata for each app, including the purchase type, state, review note, and sharing options.
ClickUp
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TIME_ENTRY_TASK_TAG | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| column | Discontinued Column | task_id | |||
| column | New Column | time_entry_id | |||
Contrast Security
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SINGLE_SCAN_RESULT | |||||
| table | New Table | SINGLE_SCAN_RESULT | New table split from the VULNERABILITY table. | ||
Coupa
We have removed the RECEIPT table.
We have removed the receipt_id column from the INVENTORY_TRANSACTION table.
We have added the following new tables:
BUSINESS_ENTITYBUSINESS_ENTITY_ACCOUNT_OWNERBUSINESS_ENTITY_ADDRESS_MAPPINGBUSINESS_ENTITY_ALTERNATE_NAMEBUSINESS_ENTITY_EXTERNAL_REFERENCEBUSINESS_ENTITY_RELATIONSHIP
We are gradually rolling out these new tables to all existing connections.
We have added the following new columns to the TAGGING table:
document_iddocument_type
We have added the following new table:
INVOICE_EMAIL
Facebook Ads
We've added a new table, AD_ACTIVITY. The table contains a log of changes made to ad objects within an ad account, including the actor, object, and event type for each change.
Fortnox
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSET_TYPE | |||||
| table | New Table | ASSET_TYPE | |||
ATTENDANCE_TRANSACTION | |||||
| table | New Table | ATTENDANCE_TRANSACTION | |||
COMPANY_SETTING | |||||
| table | New Table | COMPANY_SETTING | |||
COST_CENTER | |||||
| table | New Table | COST_CENTER | |||
EMPLOYEE | |||||
| table | New Table | EMPLOYEE | |||
EXPENSE | |||||
| table | New Table | EXPENSE | |||
FINANCIAL_YEAR | |||||
| table | New Table | FINANCIAL_YEAR | |||
INCOMING_GOOD | |||||
| table | New Table | INCOMING_GOOD | |||
INVOICE_ACCRUAL | |||||
| table | New Table | INVOICE_ACCRUAL | |||
LABEL | |||||
| table | New Table | LABEL | |||
LOCKED_PERIOD | |||||
| table | New Table | LOCKED_PERIOD | |||
PRICE | |||||
| table | New Table | PRICE | |||
PRODUCTION_ORDER | |||||
| table | New Table | PRODUCTION_ORDER | |||
PURCHASE_ORDER | |||||
| table | New Table | PURCHASE_ORDER | |||
SALARY_TRANSACTION | |||||
| table | New Table | SALARY_TRANSACTION | |||
STOCK_BALANCE | |||||
| table | New Table | STOCK_BALANCE | |||
STOCK_POINT | |||||
| table | New Table | STOCK_POINT | |||
STOCK_TAKING | |||||
| table | New Table | STOCK_TAKING | |||
SUPPLIER_INVOICE_ACCRUAL | |||||
| table | New Table | SUPPLIER_INVOICE_ACCRUAL | |||
SUPPLIER_INVOICE_FILE_CONNECTION | |||||
| table | New Table | SUPPLIER_INVOICE_FILE_CONNECTION | |||
VOUCHER_SERIES | |||||
| table | New Table | VOUCHER_SERIES | |||
Freshservice
We've added support for custom columns in the CHANGE table. Custom fields from the Freshservice changes API are now synced as individual columns prefixed with custom_ (for example, custom_change_category, custom_deployment_date).
We have added support for asset type-specific fields in the ASSET table. Fields from the Freshservice asset types API are now synced as individual columns prefixed with type_field_ (for example, type_field_serial_number_18000680618, type_field_warranty_months_18000680618). The column names are dynamic and vary based on the asset type.
We have added a new table, WORKSPACE. The table contains the workspaces (or, for Freshservice for MSPs, clients) configured on the account.
We have added a new column, workspace_id, to the SERVICE_GROUP table.
Google Search Console
We have added two new columns, warnings and errors, to the SITEMAP table.
Jira
We now sync archived projects for Jira Cloud connections. This feature is not available for Jira on-premise. Archived projects are included in the PROJECT table alongside active projects.
We have added three new columns to the PROJECT table:
archivedarchived_datearchived_by_id.
Kantata
We've added a new table, COST_RATE. The table contains hourly cost rates for account members in specific currencies.
LinkedIn Ad Analytics
We have added the following new columns to the CAMPAIGN_HISTORY table:
total_budget_amounttotal_budget_currencyCode
We've added a new table, CAMPAIGN_GROUP_ALLOWED_CAMPAIGN_TYPE_HISTORY. The table contains the allowed campaign types associated with each campaign group.
Mailchimp
We have added a new table, CAMPAIGN_VARIATE_COMBINATION_UNSUBSCRIBE, to track multivariate campaign combination-level unsubscribes.
Maxio Chargify
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PREVIEW_CREDIT | |||||
| column | Discontinued Column | preview_performa_invoice_uid 🔑 | |||
| column | Primary Key Change | preview_performa_invoice_subscription_id 🔑 | Added to primary key. | ||
PREVIEW_CUSTOM_FIELD | |||||
| column | Discontinued Column | preview_performa_invoice_uid 🔑 | |||
| column | Primary Key Change | preview_performa_invoice_subscription_id 🔑 | Added to primary key. | ||
PREVIEW_DISCOUNT | |||||
| column | Primary Key Change | preview_performa_invoice_subscription_id | preview_performa_invoice_subscription_id 🔑 | Added to primary key. | |
| column | Primary Key Change | preview_performa_invoice_uid 🔑 | preview_performa_invoice_uid | ||
PREVIEW_DISCOUNT_LINE_ITEM | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
PREVIEW_LINE_ITEM | |||||
| column | Discontinued Column | preview_performa_invoice_uid 🔑 | |||
| column | Primary Key Change | preview_performa_invoice_subscription_id 🔑 | Added to primary key. | ||
PREVIEW_PAYMENT | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
PREVIEW_PERFORMA_INVOICE | |||||
| column | Primary Key Change | subscription_id | subscription_id 🔑 | Added to primary key. | |
| column | Primary Key Change | uid 🔑 | uid | No longer a primary key. | |
PREVIEW_TAXES | |||||
| column | Discontinued Column | preview_performa_invoice_uid 🔑 | |||
| column | Primary Key Change | preview_performa_invoice_subscription_id 🔑 | Added to primary key. | ||
PREVIEW_TAXES_LINE_ITEM | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
TRANSACTION | |||||
| table | New Table | TRANSACTION | |||
TRANSACTION_TAXATION | |||||
| table | New Table | TRANSACTION_TAXATION | |||
TRANSACTION_TAXATION_TAX_RULES | |||||
| table | New Table | TRANSACTION_TAXATION_TAX_RULES | |||
OpenAI
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ADMIN_API_KEY | |||||
| table | New Table | ADMIN_API_KEY | |||
AUDIO_VOICE_CONSENT | |||||
| table | New Table | AUDIO_VOICE_CONSENT | |||
AUDIT_LOG | |||||
| table | New Table | AUDIT_LOG | |||
BATCH | |||||
| table | New Table | BATCH | |||
CERTIFICATE | |||||
| table | New Table | CERTIFICATE | |||
CHAT_COMPLETION | |||||
| table | New Table | CHAT_COMPLETION | |||
CHAT_COMPLETION_CHOICE | |||||
| table | New Table | CHAT_COMPLETION_CHOICE | |||
CHAT_COMPLETION_CHOICE_MESSAGE_ANNOTATION | |||||
| table | New Table | CHAT_COMPLETION_CHOICE_MESSAGE_ANNOTATION | |||
CHAT_COMPLETION_CHOICE_MESSAGE_TOOL_CALL | |||||
| table | New Table | CHAT_COMPLETION_CHOICE_MESSAGE_TOOL_CALL | |||
CHAT_COMPLETION_MESSAGE | |||||
| table | New Table | CHAT_COMPLETION_MESSAGE | |||
CHAT_COMPLETION_MESSAGE_CONTENT_PART | |||||
| table | New Table | CHAT_COMPLETION_MESSAGE_CONTENT_PART | |||
CHATKIT_THREAD | |||||
| table | New Table | CHATKIT_THREAD | |||
CHATKIT_THREAD_ITEM | |||||
| table | New Table | CHATKIT_THREAD_ITEM | |||
CHATKIT_THREAD_ITEM_ATTACHMENT | |||||
| table | New Table | CHATKIT_THREAD_ITEM_ATTACHMENT | |||
CHATKIT_THREAD_ITEM_CONTENT | |||||
| table | New Table | CHATKIT_THREAD_ITEM_CONTENT | |||
CHATKIT_THREAD_ITEM_TASK | |||||
| table | New Table | CHATKIT_THREAD_ITEM_TASK | |||
CONTAINER | |||||
| table | New Table | CONTAINER | |||
CONTAINER_FILE | |||||
| table | New Table | CONTAINER_FILE | |||
CONTAINER_NETWORK_POLICY_ALLOWED_DOMAIN | |||||
| table | New Table | CONTAINER_NETWORK_POLICY_ALLOWED_DOMAIN | |||
EVAL | |||||
| table | New Table | EVAL | |||
EVAL_RUN | |||||
| table | New Table | EVAL_RUN | |||
EVAL_RUN_OUTPUT_ITEM | |||||
| table | New Table | EVAL_RUN_OUTPUT_ITEM | |||
EVAL_RUN_OUTPUT_ITEM_RESULT | |||||
| table | New Table | EVAL_RUN_OUTPUT_ITEM_RESULT | |||
EVAL_RUN_OUTPUT_ITEM_SAMPLE_INPUT | |||||
| table | New Table | EVAL_RUN_OUTPUT_ITEM_SAMPLE_INPUT | |||
EVAL_RUN_OUTPUT_ITEM_SAMPLE_OUTPUT | |||||
| table | New Table | EVAL_RUN_OUTPUT_ITEM_SAMPLE_OUTPUT | |||
EVAL_RUN_PER_MODEL_USAGE | |||||
| table | New Table | EVAL_RUN_PER_MODEL_USAGE | |||
EVAL_RUN_PER_TESTING_CRITERIA_RESULT | |||||
| table | New Table | EVAL_RUN_PER_TESTING_CRITERIA_RESULT | |||
EVAL_TESTING_CRITERIA | |||||
| table | New Table | EVAL_TESTING_CRITERIA | |||
EVAL_TESTING_CRITERIA_LABEL | |||||
| table | New Table | EVAL_TESTING_CRITERIA_LABEL | |||
EVAL_TESTING_CRITERIA_PASSING_LABEL | |||||
| table | New Table | EVAL_TESTING_CRITERIA_PASSING_LABEL | |||
FILE | |||||
| table | New Table | FILE | |||
FINE_TUNING_JOB | |||||
| table | New Table | FINE_TUNING_JOB | |||
FINE_TUNING_JOB_CHECKPOINT | |||||
| table | New Table | FINE_TUNING_JOB_CHECKPOINT | |||
FINE_TUNING_JOB_CHECKPOINT_PERMISSION | |||||
| table | New Table | FINE_TUNING_JOB_CHECKPOINT_PERMISSION | |||
FINE_TUNING_JOB_EVENT | |||||
| table | New Table | FINE_TUNING_JOB_EVENT | |||
FINE_TUNING_JOB_INTEGRATION | |||||
| table | New Table | FINE_TUNING_JOB_INTEGRATION | |||
FINE_TUNING_JOB_INTEGRATION_TAG | |||||
| table | New Table | FINE_TUNING_JOB_INTEGRATION_TAG | |||
FINE_TUNING_JOB_RESULT_FILE | |||||
| table | New Table | FINE_TUNING_JOB_RESULT_FILE | |||
GROUPS | |||||
| table | New Table | GROUPS | |||
GROUPS_USER | |||||
| table | New Table | GROUPS_USER | |||
INVITE | |||||
| table | New Table | INVITE | |||
INVITE_PROJECT | |||||
| table | New Table | INVITE_PROJECT | |||
PROJECT_GROUP | |||||
| table | New Table | PROJECT_GROUP | |||
PROJECT_GROUP_ROLE | |||||
| table | New Table | PROJECT_GROUP_ROLE | |||
PROJECT_ROLE | |||||
| table | New Table | PROJECT_ROLE | |||
PROJECT_ROLE_PERMISSION | |||||
| table | New Table | PROJECT_ROLE_PERMISSION | |||
PROJECT_SERVICE_ACCOUNT | |||||
| table | New Table | PROJECT_SERVICE_ACCOUNT | |||
PROJECT_USER_ROLE | |||||
| table | New Table | PROJECT_USER_ROLE | |||
ROLE | |||||
| table | New Table | ROLE | |||
ROLE_PERMISSION | |||||
| table | New Table | ROLE_PERMISSION | |||
SKILL | |||||
| table | New Table | SKILL | |||
SKILL_VERSION | |||||
| table | New Table | SKILL_VERSION | |||
USERS_ROLE | |||||
| table | New Table | USERS_ROLE | |||
USERS_ROLE_PERMISSION | |||||
| table | New Table | USERS_ROLE_PERMISSION | |||
VECTOR_STORE | |||||
| table | New Table | VECTOR_STORE | |||
VECTOR_STORE_FILE | |||||
| table | New Table | VECTOR_STORE_FILE | |||
VIDEO | |||||
| table | New Table | VIDEO | |||
Pardot
We've added a new table, LIST_EMAIL_LIST.
Prive
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PRODUCT_SUBSCRIPTION_OFFER_OPTION | |||||
| table | New Table | PRODUCT_SUBSCRIPTION_OFFER_OPTION | To backfill the historical records, trigger a re-sync. | ||
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 a 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 a primary key. | |
| column | Primary Key Change | date_start 🔑 | date_start | No longer a 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 🔑 | Primary key 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 a primary key. | |
| column | Primary Key Change | date_start 🔑 | date_start | No longer a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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.
Salesforce Marketing Cloud
We've added a new table, SMS_SUBSCRIPTION_LOG.
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 | |||
Shopify
We have added a new table, CUSTOMER_SEGMENT_MEMBER.
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 have added two new columns, advertiser_account_type and company_name_editable, to the ADVERTISER table.
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.
We have added the following new tables:
REQUISITIONREQUISITION_AD_HOC_ADDRESS_REPLACEMENTREQUISITION_AD_HOC_ADDRESS_REPLACEMENT_ADDRESS_LINEREQUISITION_AD_HOC_ADDRESS_REPLACEMENT_SUBMUNICIPALITYREQUISITION_AD_HOC_ADDRESS_REPLACEMENT_SUBREGIONREQUISITION_ATTACHMENTREQUISITION_COMMUNICATION_METHOD_USAGEREQUISITION_DELIVERABLES_LINEREQUISITION_DELIVERABLES_LINE_CLOSE_STATUSREQUISITION_DELIVERABLES_LINE_PROJECT_PHASEREQUISITION_DELIVERABLES_LINE_SPLITREQUISITION_DELIVERABLES_LINE_SPLIT_WORKTAGREQUISITION_DELIVERABLES_LINE_WORKTAGREQUISITION_GOODS_LINE_SPLITREQUISITION_GOODS_LINE_SPLIT_WORKTAGREQUISITION_ITEM_REQUEST_LINEREQUISITION_ITEM_REQUEST_LINE_CLOSE_STATUSREQUISITION_ITEM_REQUEST_LINE_WORKTAGREQUISITION_SERVICE_REQUEST_LINEREQUISITION_SERVICE_REQUEST_LINE_CLOSE_STATUSREQUISITION_SERVICE_REQUEST_LINE_SPLITREQUISITION_SERVICE_REQUEST_LINE_SPLIT_WORKTAGREQUISITION_SERVICE_REQUEST_LINE_WORKTAG
We are gradually rolling out this change to all existing connections.
We have added a new table, SUPPLIER_INVOICE_LINE_WORKTAG. We are gradually rolling out this change to all existing connections.
Xero
We've added the following new tables:
JOURNAL_CASHJOURNAL_CASH_LINEJOURNAL_CASH_LINE_HAS_TRACKING_CATEGORY
We are gradually rolling out this change to all existing connections.
YouTube Analytics
We've added support for system-managed reports. System-managed reports are automatically generated by YouTube and are available exclusively to Content Owners. If you haven't entered a Content Owner ID, we don't sync these tables.
We've added the following new tables:
SYSTEM_MANAGED_CONTENT_OWNER_ASSETSYSTEM_MANAGED_CONTENT_OWNER_ACTIVE_CLAIMSSYSTEM_MANAGED_CONTENT_OWNER_VIDEO_METADATASYSTEM_MANAGED_CONTENT_OWNER_AD_REVENUE_RAWSYSTEM_MANAGED_CONTENT_OWNER_ASSET_AD_REVENUE_RAWSYSTEM_MANAGED_CONTENT_OWNER_MUSIC_ASSET_RED_REVENUE_RAWSYSTEM_MANAGED_CONTENT_OWNER_NON_MUSIC_ASSET_RED_REVENUE_RAW
You can enable or disable each table on the Schema tab of your YouTube Analytics connection.
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.
We now capture deletes for the MESSAGE_VARIATION table.
Calendly
We have added a new drop-down menu, Calendly plan, to the connection setup form. You can now specify your account plan type when configuring your connection. The Calendly API uses user-based rate limiting. We now proactively apply these rate limits in our API calls when retrieving your data. This improvement will help prevent the 429 error we encounter when hitting rate limits during syncs. For more information, see our setup instructions.
HappyFox
We have changed the sync strategy for the TICKET table and its child tables. We now incrementally sync them to capture new records and updates.
High-Volume Agent Db2 for i
The High-Volume Agent Db2 for i connector now supports the XML, DATALINK, BOOLEAN, ROWID, BINARY-DECIMAL, and DISTINCT data types. To use these new data types, upgrade your High-Volume Agent to version 6.2.0/3 or later.
Jira
You can now authenticate your Jira connection using a service account. For more information, see our setup instructions.
rocketlane
We have added support to select EU as one of the API server region.
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.
ShipMonk
We have updated our sync strategy for the RECEIVING table. We now re-import the table during every sync.
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.