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.
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.
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
Slack Admin Data
The Slack Admin Data connector is now generally available.
Read our Slack Admin Data connector documentation.
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
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.
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 | |||
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.
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.
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'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.
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 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.
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.
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.
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.
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.