January 2026
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.5.1 of the fivetran-connector-sdk PyPI package. This release adds the following:
- New deployment strategy for Connector SDK connections.
- Minor enhancements and improvements.
We have released version 2.5.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Updated testers to use DuckDB version 1.4.2
- Minor enhancements and improvements.
Lite Connectors
Lite connectors are now available for the following sources:
Partner SDK
Convex connector for Fivetran
You can now exclude Convex components, tables, and columns from your syncs on the Schema tab of your connection details page in the Fivetran dashboard.
For more information, see our Data Blocking documentation and the Convex connector documentation.
Schema changes
ADP Workforce Now
We have added the following new columns to the WORK_ASSIGNMENT_HISTORY table:
job_functionjob_function_effective_datejob_function_long_namejob_function_short_namejob_function_subdivisionType
ClickUp
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
VIEW_TASK | |||||
| table | New Table | VIEW_TASK | |||
Coupa
We have added the following new columns to the CONTRACT table:
auto_extend_end_date_for_renewalexternal_contract_idfill_with_counterpartyproxy_supplier_idstop_spend_based_on_max_valueuse_online_signingwhose_paper
We have added a new table, CONTRACT_CURRENT_PARALLEL_APPROVAL_MAPPING, to capture the relationship between the CONTRACT and APPROVAL tables.
Freshchat
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION_REPORT | |||||
| table | New Table | CONVERSATION_REPORT | |||
CSAT_REPORT | |||||
| table | New Table | CSAT_REPORT | |||
TEAM_PERFORMANCE_FIRST_RESPONSE_TIME | |||||
| table | New Table | TEAM_PERFORMANCE_FIRST_RESPONSE_TIME | |||
TEAM_PERFORMANCE_METRICS | |||||
| table | Discontinued Table | TEAM_PERFORMANCE_METRICS | |||
TEAM_PERFORMANCE_RESOLUTION_TIME | |||||
| table | New Table | TEAM_PERFORMANCE_RESOLUTION_TIME | |||
TEAM_PERFORMANCE_RESPONSE_TIME | |||||
| table | New Table | TEAM_PERFORMANCE_RESPONSE_TIME | |||
Freshdesk
We have updated the connector to automatically handle survey ID format changes when Freshdesk accounts migrate from the Default CSAT module to the Advanced CSAT module.
When your Freshdesk account uses the Advanced CSAT module, the following columns will change from numeric to UUID string format:
idcolumn in theSURVEYtablesurvey_idcolumn in theSURVEY_QUESTIONtablesurvey_idcolumn in theSATISFACTION_RATINGtable
The connector automatically detects which format your account uses and handles the data accordingly.
Friendbuy
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CLICK | |||||
| column | New Column | advocate_customer_id | |||
| column | New Column | advocate_email | |||
| column | New Column | channel | |||
| column | New Column | created_on | |||
| column | New Column | ip_address | |||
| column | New Column | user_agent | |||
DISTRIBUTED_ADVOCATE_REWARD | |||||
| column | New Column | advocate_email | |||
| column | New Column | channel | |||
| column | New Column | coupon_code | |||
| column | New Column | created_on | |||
| column | New Column | friend_email | |||
| column | New Column | friend_name | |||
PURCHASE | |||||
| column | New Column | advocate_customer_id | |||
| column | New Column | advocate_email | |||
| column | New Column | created_on | |||
| column | New Column | ip_address | |||
SHARE | |||||
| column | New Column | advocate_customer_id | |||
| column | New Column | advocate_name | |||
| column | New Column | ip_address | |||
| column | New Column | user_agent | |||
Front
The is_spammer column in the CONTACT table now returns NULL for all records because Front has discontinued this field in their API.
GitHub
We have removed the following tables:
PROJECTCARDCOLUMNISSUE_PROJECT_HISTORY
Google Search Console
We have added the following new prebuilt reports:
HOURLY_SITE_REPORT_BY_PAGEHOURLY_SITE_REPORT_BY_SITEHOURLY_PAGE_REPORTHOURLY_KEYWORD_SITE_REPORT_BY_PAGEHOURLY_KEYWORD_SITE_REPORT_BY_SITEHOURLY_KEYWORD_PAGE_REPORT
Additionally, we now support hour as a new dimension for custom reports.
Kustomer
We have added the following new columns to the KOBJECT table:
assigned_teamassigned_userstatus
Lob
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BILLING_GROUP | |||||
| table | New Table | BILLING_GROUP | |||
QR_CODE | |||||
| table | New Table | QR_CODE | |||
QR_CODE_SCAN | |||||
| table | New Table | QR_CODE_SCAN | |||
Outbrain
We've added the following columns to the CAMPAIGN_REPORT, GEOLOCATION_REPORT, PROMOTED_LINK_REPORT, PUBLISHER_REPORT, and SECTION_REPORT tables:
videoReachedFirstQvideoReachedSecondQvideoReachedThirdQvideoReachedCompletionvideoAvgViewDurationclicksOnVideovideoActiveCompletionsvideoActiveCompletionsPercentagevideoPlays
Salesforce
We've added a new table, ENTITY_PARTICLE. This table provides granular metadata for compound Salesforce fields, such as address and geolocation fields, breaking them down into their individual components.
Simplesat
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ANSWER | |||||
| column | Discontinued Column | answer_label | |||
| column | Discontinued Column | channel | |||
| column | Discontinued Column | ip_address | |||
| column | Discontinued Column | is_primary | |||
| column | Discontinued Column | rating | |||
| column | Discontinued Column | reason | |||
| column | Discontinued Column | session | |||
| column | Discontinued Column | survey_modified | |||
| column | Discontinued Column | survey_name | |||
| column | New Column | choice | |||
| column | New Column | choice_label | |||
| column | New Column | follow_up_answer | |||
| column | New Column | published_as_testimonial | |||
| column | New Column | question_id | |||
| column | New Column | response_id | |||
COLLABORATOR | |||||
| table | Discontinued Table | COLLABORATOR | |||
CUSTOMER | |||||
| table | Discontinued Table | CUSTOMER | |||
FOLLOW_UP_ANSWER | |||||
| table | Discontinued Table | FOLLOW_UP_ANSWER | |||
QUESTION | |||||
| column | Discontinued Column | answer_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | modified | |||
| column | Discontinued Column | title | |||
| column | Discontinued Column | type | |||
| column | New Column | choices | |||
| column | New Column | orders | |||
| column | New Column | rating_scale | |||
| column | New Column | required | |||
| column | New Column | survey_id | |||
| column | New Column | text | |||
QUESTION_RULE | |||||
| table | New Table | QUESTION_RULE | |||
RESPONSE | |||||
| table | New Table | RESPONSE | |||
RESPONSE_ANSWER | |||||
| table | New Table | RESPONSE_ANSWER | |||
RESPONSE_TAG | |||||
| table | New Table | RESPONSE_TAG | |||
RESPONSE_TEAM_MEMBER | |||||
| table | New Table | RESPONSE_TEAM_MEMBER | |||
SURVEY | |||||
| table | New Table | SURVEY | |||
TAGS | |||||
| table | Discontinued Table | TAGS | |||
TICKET | |||||
| table | Discontinued Table | TICKET | |||
Snyk
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AGGREGATED_ISSUE | |||||
| table | New Table | AGGREGATED_ISSUE | |||
AGGREGATED_ISSUE_EXPLOIT_DETAIL | |||||
| table | New Table | AGGREGATED_ISSUE_EXPLOIT_DETAIL | |||
AGGREGATED_ISSUE_EXPLOIT_DETAIL_MATURITY_LEVEL | |||||
| table | New Table | AGGREGATED_ISSUE_EXPLOIT_DETAIL_MATURITY_LEVEL | |||
AGGREGATED_ISSUE_IGNORE_REASON | |||||
| table | New Table | AGGREGATED_ISSUE_IGNORE_REASON | |||
AGGREGATED_ISSUE_INTRODUCED_THROUGH | |||||
| table | New Table | AGGREGATED_ISSUE_INTRODUCED_THROUGH | |||
AGGREGATED_ISSUE_PATCH | |||||
| table | New Table | AGGREGATED_ISSUE_PATCH | |||
AGGREGATED_ISSUE_PKG_INFO | |||||
| table | New Table | AGGREGATED_ISSUE_PKG_INFO | |||
AGGREGATED_ISSUE_PRIORITY_FACTOR | |||||
| table | New Table | AGGREGATED_ISSUE_PRIORITY_FACTOR | |||
AGGREGATED_ISSUE_SEVERITY | |||||
| table | New Table | AGGREGATED_ISSUE_SEVERITY | |||
JIRA_ISSUE | |||||
| table | New Table | JIRA_ISSUE | |||
Visma
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
JOURNAL_TRANSACTION_LINE | |||||
| column | Discontinued Column | index 🔑 | |||
| column | Primary Key Change | line_number | line_number 🔑 | New primary key. | |
SALES_ORDER | |||||
| column | Discontinued Column | branch_number | |||
| column | Discontinued Column | canceled | |||
| column | Discontinued Column | cash_account | |||
| column | Discontinued Column | cash_discount_date | |||
| column | Discontinued Column | commission_amount | |||
| column | Discontinued Column | commission_percent | |||
| column | Discontinued Column | commissionable_amount | |||
| column | Discontinued Column | contact_id | |||
| column | Discontinued Column | currency_id | |||
| column | Discontinued Column | customer_vat_zone_default_tax_category_description | |||
| column | Discontinued Column | customer_vat_zone_default_tax_category_number | |||
| column | Discontinued Column | customer_vat_zone_default_vat_category | |||
| column | Discontinued Column | customer_vat_zone_description | |||
| column | Discontinued Column | customer_vat_zone_id | |||
| column | Discontinued Column | due_date | |||
| column | Discontinued Column | exchange_rate | |||
| column | Discontinued Column | fob_point_description | |||
| column | Discontinued Column | fob_point_id | |||
| column | Discontinued Column | hold | |||
| column | Discontinued Column | insurance | |||
| column | Discontinued Column | invoice_date | |||
| column | Discontinued Column | invoice_nbr | |||
| column | Discontinued Column | invoice_separately | |||
| column | Discontinued Column | last_modified_date_time | |||
| column | Discontinued Column | location_country_id | |||
| column | Discontinued Column | location_id | |||
| column | Discontinued Column | location_name | |||
| column | Discontinued Column | order_type | |||
| column | Discontinued Column | orig_order_nbr | |||
| column | Discontinued Column | orig_order_type | |||
| column | Discontinued Column | owner_employee_id | |||
| column | Discontinued Column | owner_name | |||
| column | Discontinued Column | payment_method_id | |||
| column | Discontinued Column | payment_ref | |||
| column | Discontinued Column | post_period | |||
| column | Discontinued Column | preferred_warehouse_description | |||
| column | Discontinued Column | preferred_warehouse_id | |||
| column | Discontinued Column | print_note_on_external_documents | |||
| column | Discontinued Column | print_note_on_internal_documents | |||
| column | Discontinued Column | priority | |||
| column | Discontinued Column | project_cd | |||
| column | Discontinued Column | residential_delivery | |||
| column | Discontinued Column | sales_order_shipping_address_city | |||
| column | Discontinued Column | sales_order_shipping_address_country | |||
| column | Discontinued Column | sales_order_shipping_address_country_id | |||
| column | Discontinued Column | sales_order_shipping_address_country_name | |||
| column | Discontinued Column | sales_order_shipping_address_county_id | |||
| column | Discontinued Column | sales_order_shipping_address_county_name | |||
| column | Discontinued Column | sales_order_shipping_address_id | |||
| column | Discontinued Column | sales_order_shipping_address_line_1 | |||
| column | Discontinued Column | sales_order_shipping_address_line_2 | |||
| column | Discontinued Column | sales_order_shipping_address_override_address | |||
| column | Discontinued Column | sales_order_shipping_address_postal_code | |||
| column | Discontinued Column | sales_order_shipping_contact_attention | |||
| column | Discontinued Column | sales_order_shipping_contact_email | |||
| column | Discontinued Column | sales_order_shipping_contact_fax | |||
| column | Discontinued Column | sales_order_shipping_contact_id | |||
| column | Discontinued Column | sales_order_shipping_contact_name | |||
| column | Discontinued Column | sales_order_shipping_contact_override_contact | |||
| column | Discontinued Column | sales_order_shipping_contact_phone_1 | |||
| column | Discontinued Column | sales_order_shipping_contact_phone_2 | |||
| column | Discontinued Column | sales_order_shipping_contact_web | |||
| column | Discontinued Column | saturday_delivery | |||
| column | Discontinued Column | sched_shipment | |||
| column | Discontinued Column | ship_complete | |||
| column | Discontinued Column | ship_separately | |||
| column | Discontinued Column | ship_via_description | |||
| column | Discontinued Column | ship_via_id | |||
| column | Discontinued Column | shipping_terms_description | |||
| column | Discontinued Column | shipping_terms_id | |||
| column | Discontinued Column | so_billing_address_city | |||
| column | Discontinued Column | so_billing_address_country | |||
| column | Discontinued Column | so_billing_address_country_id | |||
| column | Discontinued Column | so_billing_address_country_name | |||
| column | Discontinued Column | so_billing_address_county_id | |||
| column | Discontinued Column | so_billing_address_county_name | |||
| column | Discontinued Column | so_billing_address_id | |||
| column | Discontinued Column | so_billing_address_line_1 | |||
| column | Discontinued Column | so_billing_address_line_2 | |||
| column | Discontinued Column | so_billing_address_override_address | |||
| column | Discontinued Column | so_billing_address_postal_code | |||
| column | Discontinued Column | so_billing_contact_attention | |||
| column | Discontinued Column | so_billing_contact_email | |||
| column | Discontinued Column | so_billing_contact_fax | |||
| column | Discontinued Column | so_billing_contact_id | |||
| column | Discontinued Column | so_billing_contact_name | |||
| column | Discontinued Column | so_billing_contact_override_contact | |||
| column | Discontinued Column | so_billing_contact_phone_1 | |||
| column | Discontinued Column | so_billing_contact_phone_2 | |||
| column | Discontinued Column | so_billing_contact_web | |||
| column | Discontinued Column | tax_total_in_base_currency | |||
| column | Discontinued Column | terms_description | |||
| column | Discontinued Column | terms_id | |||
| column | Discontinued Column | transaction_type_description | |||
| column | Discontinued Column | transaction_type_id | |||
| column | Discontinued Column | vat_exempt_total | |||
| column | Discontinued Column | vat_exempt_total_in_base_currency | |||
| column | Discontinued Column | vat_taxable_total | |||
| column | Discontinued Column | vat_taxable_total_in_base_currency | |||
| column | New Column | billing_address | |||
| column | New Column | billing_contact | |||
| column | New Column | branch_id | |||
| column | New Column | created_by | |||
| column | New Column | currency | |||
| column | New Column | custom_field | |||
| column | New Column | financial_information_cash_discount_date | |||
| column | New Column | financial_information_due_date | |||
| column | New Column | financial_information_invoice_date | |||
| column | New Column | financial_information_invoice_id | |||
| column | New Column | financial_information_invoice_separately | |||
| column | New Column | financial_information_post_period | |||
| column | New Column | financial_information_term_description | |||
| column | New Column | financial_information_term_id | |||
| column | New Column | freight_amount | |||
| column | New Column | freight_amount_in_base_currency | |||
| column | New Column | freight_cost | |||
| column | New Column | freight_cost_in_base_currency | |||
| column | New Column | freight_premium_amount | |||
| column | New Column | freight_premium_amount_in_base_currency | |||
| column | New Column | freight_tax_category_id | |||
| column | New Column | freight_volume | |||
| column | New Column | freight_weight | |||
| column | New Column | last_modified | |||
| column | New Column | location | |||
| column | New Column | order_total | |||
| column | New Column | origin_link | |||
| column | New Column | origin_order_id | |||
| column | New Column | origin_order_type | |||
| column | New Column | original_order_id | |||
| column | New Column | original_order_type | |||
| column | New Column | owner_internal_id | |||
| column | New Column | parent_customer_id | |||
| column | New Column | parent_customer_internal_id | |||
| column | New Column | parent_customer_name | |||
| column | New Column | payment_settings_cash_account_id | |||
| column | New Column | payment_settings_payment_method_description | |||
| column | New Column | payment_settings_payment_method_id | |||
| column | New Column | payment_settings_payment_reference | |||
| column | New Column | print_note_on_external_document | |||
| column | New Column | print_note_on_internal_document | |||
| column | New Column | project_description | |||
| column | New Column | project_id | |||
| column | New Column | project_internal_id | |||
| column | New Column | rot_rut_apartment | |||
| column | New Column | rot_rut_distributed_amount | |||
| column | New Column | rot_rut_distributed_automatically | |||
| column | New Column | rot_rut_distribution_amount | |||
| column | New Column | rot_rut_distribution_extra | |||
| column | New Column | rot_rut_distribution_line_id | |||
| column | New Column | rot_rut_distribution_personal_id | |||
| column | New Column | rot_rut_estate | |||
| column | New Column | rot_rut_material_cost_amount | |||
| column | New Column | rot_rut_organization_number | |||
| column | New Column | rot_rut_other_cost_amount | |||
| column | New Column | rot_rut_total_deductable_amount | |||
| column | New Column | rot_rut_type | |||
| column | New Column | rot_rut_work_price_amount | |||
| column | New Column | shipping_address_city | |||
| column | New Column | shipping_address_country_id | |||
| column | New Column | shipping_address_country_name | |||
| column | New Column | shipping_address_county_id | |||
| column | New Column | shipping_address_county_name | |||
| column | New Column | shipping_address_id | |||
| column | New Column | shipping_address_line_1 | |||
| column | New Column | shipping_address_line_2 | |||
| column | New Column | shipping_address_line_3 | |||
| column | New Column | shipping_address_override_Default | |||
| column | New Column | shipping_address_postal_code | |||
| column | New Column | shipping_contact_attention | |||
| column | New Column | shipping_contact_email | |||
| column | New Column | shipping_contact_fax | |||
| column | New Column | shipping_contact_id | |||
| column | New Column | shipping_contact_name | |||
| column | New Column | shipping_contact_overrides_default | |||
| column | New Column | shipping_contact_phone_1 | |||
| column | New Column | shipping_contact_phone_2 | |||
| column | New Column | shipping_fob_point_description | |||
| column | New Column | shipping_fob_point_id | |||
| column | New Column | shipping_insurance | |||
| column | New Column | shipping_intrastat_transaction_type_description | |||
| column | New Column | shipping_intrastat_transaction_type_id | |||
| column | New Column | shipping_preferred_warehouse_description | |||
| column | New Column | shipping_preferred_warehouse_id | |||
| column | New Column | shipping_priority | |||
| column | New Column | shipping_residential_delivery | |||
| column | New Column | shipping_rule | |||
| column | New Column | shipping_saturday_delivery | |||
| column | New Column | shipping_scheduled_date | |||
| column | New Column | shipping_ship_separately | |||
| column | New Column | shipping_ship_via_description | |||
| column | New Column | shipping_ship_via_id | |||
| column | New Column | shipping_term_description | |||
| column | New Column | shipping_term_id | |||
| column | New Column | status_details_cancelled | |||
| column | New Column | status_details_description | |||
| column | New Column | status_details_hold | |||
| column | New Column | type | |||
| column | New Column | use_replacement_cost_for_margin_and_profit | |||
| column | New Column | version | |||
SALES_ORDER_COMMISSION | |||||
| table | New Table | SALES_ORDER_COMMISSION | |||
SALES_ORDER_DISCOUNT | |||||
| table | New Table | SALES_ORDER_DISCOUNT | |||
SALES_ORDER_LINE | |||||
| column | Discontinued Column | alternate_id | |||
| column | Discontinued Column | branch_number | |||
| column | Discontinued Column | disc_unit_price | |||
| column | Discontinued Column | expiration_date | |||
| column | Discontinued Column | ext_price | |||
| column | Discontinued Column | index 🔑 | No longer a primary key. | ||
| column | Discontinued Column | inventory_number | |||
| column | Discontinued Column | invoice_nbr | |||
| column | Discontinued Column | line_description | |||
| column | Discontinued Column | line_nbr | |||
| column | Discontinued Column | lot_serial_nbr | |||
| column | Discontinued Column | manual_discount | |||
| column | Discontinued Column | mark_for_purchase_order | |||
| column | Discontinued Column | open_qty | |||
| column | Discontinued Column | project_task | |||
| column | Discontinued Column | project_task_cd | |||
| column | Discontinued Column | qty_on_shipments | |||
| column | Discontinued Column | requested_on | |||
| column | Discontinued Column | ship_complete | |||
| column | Discontinued Column | ship_on | |||
| column | Discontinued Column | sub_account_id | |||
| column | Discontinued Column | tax_category | |||
| column | Discontinued Column | unbilled_amount | |||
| column | Discontinued Column | unit_price_in_base_currency | |||
| column | Discontinued Column | uom | |||
| column | New Column | auto_create_issue | |||
| column | New Column | base_order_quantity | |||
| column | New Column | billed_quantity | |||
| column | New Column | custom_field | |||
| column | New Column | description | |||
| column | New Column | discount_code | |||
| column | New Column | discount_sequence_id | |||
| column | New Column | discounted_unit_price | |||
| column | New Column | excise_duty | |||
| column | New Column | extended_price | |||
| column | New Column | external_link | |||
| column | New Column | has_manual_discount | |||
| column | New Column | has_manual_price | |||
| column | Primary Key Change | id 🔑 | New primary key. | ||
| column | New Column | inventory_alternate_id | |||
| column | New Column | inventory_base_unit | |||
| column | New Column | inventory_id | |||
| column | New Column | invoice_line_number | |||
| column | New Column | invoice_number | |||
| column | New Column | invoice_type | |||
| column | New Column | is_rot_rut_deductible | |||
| column | New Column | kit_assembly_reference_number | |||
| column | New Column | line_total_before_discount | |||
| column | New Column | line_type | |||
| column | New Column | open_line | |||
| column | New Column | open_quantity | |||
| column | New Column | order_date | |||
| column | New Column | project_task_id | |||
| column | New Column | purchase_order_number | |||
| column | New Column | quantity_on_shipment | |||
| column | New Column | replacement_unit_cost | |||
| column | New Column | request_date | |||
| column | New Column | rot_rut_deductible_amount | |||
| column | New Column | rot_rut_item_type_description | |||
| column | New Column | rot_rut_item_type_id | |||
| column | New Column | rot_rut_work_type | |||
| column | New Column | sales_account_id | |||
| column | New Column | ship_date | |||
| column | New Column | shipping_rule | |||
| column | New Column | subaccount | |||
| column | New Column | supplier_id | |||
| column | New Column | supplier_price | |||
| column | New Column | tax_category_id | |||
| column | New Column | unit_of_measure | |||
| column | New Column | warehouse_location_description | |||
| column | New Column | warehouse_location_id | |||
SALES_ORDER_LINE_ALLOCATION | |||||
| table | New Table | SALES_ORDER_LINE_ALLOCATION | |||
SALES_ORDER_LINE_ATTACHMENT | |||||
| column | Discontinued Column | sales_order_line_index 🔑 | No longer a primary key. | ||
| column | Primary Key Change | sales_order_line_id 🔑 | New primary key. | ||
SALES_ORDER_PAYMENT | |||||
| table | New Table | SALES_ORDER_PAYMENT | |||
SALES_ORDER_ROT_RUT_DISTRIBUTION | |||||
| table | New Table | SALES_ORDER_ROT_RUT_DISTRIBUTION | |||
SALES_ORDER_SHIPMENT | |||||
| column | Discontinued Column | index 🔑 | No longer a primary key. | ||
| column | Discontinued Column | inventory_doc_type | |||
| column | Discontinued Column | inventory_ref_no | |||
| column | Discontinued Column | invoice_no | |||
| column | Discontinued Column | shipment_id | |||
| column | Discontinued Column | shipped_qty | |||
| column | Discontinued Column | shipped_volume | |||
| column | Discontinued Column | shipped_weight | |||
| column | Primary Key Change | id 🔑 | New primary key. | ||
| column | New Column | inventory_correction_document_type | |||
| column | New Column | inventory_correction_reference_id | |||
| column | New Column | inventory_document_type | |||
| column | New Column | inventory_reference_id | |||
| column | New Column | invoice_id | |||
| column | New Column | quantity | |||
| column | New Column | status | |||
| column | New Column | volume | |||
| column | New Column | weight | |||
SALES_ORDER_TAX | |||||
| table | New Table | SALES_ORDER_TAX | |||
Workday HCM
We have updated our Workday schema to support the Get Workers API v42.2. For connections created on or before January 5, 2026, we will implement these changes in a phased manner.
Effective January 5, 2026, we have made the following schema changes:
Added the following new tables:
COUNTRY_PERSONAL_INFORMATIONMILITARY_SERVICE_INCOMINGPERSON_DISABILITY_INCOMINGPERSONAL_INFORMATION_COMMON_DATAPERSONAL_INFORMATION_ETHNICITY_INCOMINGPERSONAL_INFORMATION_GENDER_IDENTITYPERSONAL_INFORMATION_PRONOUNPERSONAL_INFORMATION_SEXUAL_ORIENTATIONPERSONAL_INFORMATION_SEXUAL_ORIENTATION_AND_GENDER_IDENTITYRELATIVE_NAME_INCOMING
Be sure to trigger a re-sync to backfill the historical data for these tables.
Tables with the suffix,
_INCOMING, are new versions of existing tables. From January 5, 2026, through April 6, 2026, we will sync data to both the legacy tables and their corresponding new versions (with_INCOMINGsuffix).Renamed the following columns in the
PERSONAL_INFORMATIONtable:hukou_regiontohukou_region_codehukou_subregiontohukou_subregion_codehukou_typetohukou_type_codepersonnel_file_agencytopersonnel_file_agency_for_person
Renamed the
region_of_birth_codecolumn tocountry_region_of_birth, in thePERSONAL_INFORMATIONtable.Discontinued syncing the columns below in the
PERSONAL_INFORMATIONtable and synced them to the following tables instead:pronouncolumn to thePERSONAL_INFORMATION_PRONOUNtablesexual_orientationcolumn to thePERSONAL_INFORMATION_SEXUAL_ORIENTATIONtable
On April 6, 2026, we will implement the following changes:
Stop syncing data to the following legacy tables and rename them:
MILITARY_SERVICEtoMILITARY_SERVICE_BACKUP_2026-04-06PERSON_DISABILITYtoPERSON_DISABILITY_BACKUP_2026-04-06PERSONAL_INFORMATION_ETHNICITYtoPERSONAL_INFORMATION_ETHNICITY_BACKUP_2026-04-06RELATIVE_NAMEtoRELATIVE_NAME_BACKUP_2026-04-06
Rename the following tables:
MILITARY_SERVICE_INCOMINGtoMILITARY_SERVICEPERSON_DISABILITY_INCOMINGtoPERSON_DISABILITYPERSONAL_INFORMATION_ETHNICITY_INCOMINGtoPERSONAL_INFORMATION_ETHNICITYRELATIVE_NAME_INCOMINGtoRELATIVE_NAME
Stop syncing data into the following columns of the
PERSONAL_INFORMATIONtable and instead sync them to thePERSONAL_INFORMATION_COMMON_DATAtable:additional_nationalityblood_typecity_of_birthcity_of_birth_codecitizenship_statuscountry_of_birthcountry_region_of_birth(region_of_birth_codeinPERSONAL_INFORMATIONtable)date_of_birthdate_of_deathlast_medical_exam_datelast_medical_exam_valid_tomedical_exam_notesprimary_nationalityregion_of_birth
Stop syncing data into the following columns of the
PERSONAL_INFORMATIONtable and instead sync them to theCOUNTRY_PERSONAL_INFORMATIONtable:genderhispanic_or_latinohukou_localityhukou_postal_codehukou_region_code(hukou_regioninPERSONAL_INFORMATION)hukou_subregion_code(hukou_subregioninPERSONAL_INFORMATION)hukou_type_code(hukou_typeinPERSONAL_INFORMATION)local_hukoumarital_statusmarital_status_datenative_region_codenative_regionpersonnel_file_agency_for_person(personnel_file_agencyinPERSONAL_INFORMATION)political_affiliationreligionsocial_benefits_locality
Be sure to update your downstream queries and migrate to the new API version before April 6, 2026. You must perform a re-sync to backfill the historical data for the new tables.
For more information, see our Workday HCM connector documentation.
We have added the following new columns to the tables below:
hire_reason_descriptorandreason_reference_descriptorto theWORKERandWORKER_HISTORYtablesmarital_status_descriptorto thePERSONAL_INFORMATIONandPERSONAL_INFORMATION_HISTORYtablesethnicity_code_descriptorto thePERSONAL_INFORMATION_ETHNICITYandPERSONAL_INFORMATION_ETHNICITY_INCOMINGtables
Improvements
7shifts
We no longer re-import the SHIFT table.
Amazon DynamoDB
We no longer support selecting a pack mode at the table level and have removed the Select tables for packed mode radio button from the connection setup form. If pack modes are defined at the table level for your connection, the tables you have currently selected to sync using Packed mode will remain the same, but you can no longer change your table selections. We will sync the new tables using Unpacked mode. To make new selections, create separate connections for your Packed mode and Unpacked mode tables.
Canvas Data 2 by Instructure
We have improved data integrity in the ASSIGNMENT_SUBMISSION table by updating the data retrieval logic to prevent omissions.
CockroachDB
We now support the BYTES data type as a primary key column.
Firebase
We no longer support selecting a pack mode at the table level and have removed the Select tables to be synced in packed mode radio button from the connection setup form. If pack modes are defined at the table level for your connection, the tables you have currently selected to sync using Packed mode will remain the same, but you can no longer change your table selections. We will sync the new tables using Unpacked mode. To make new selections, create separate connections for your Packed mode and Unpacked mode tables.
HubSpot
HubSpot deprecated the folderId field in the MARKETING_EMAIL table and has introduced a replacement field, folderIdV2. For more information, see HubSpot's documentation.
To ensure a smooth transition, Fivetran will continue to populate both the folderId and folderIdV2 fields until January 28, 2026. After this date, we will no longer populate the folderId field.
We recommend updating your downstream processes to use folderIdV2 and safely dropping the folderId column from the destination after the deprecation date.
We've added three new tables to the HubSpot connector to support account activity tracking:
AUDIT_LOG- Contains a centralized audit log of all user actions within your HubSpot account, including CRM object creation, property value updates, security activity, and more. This table includes information about who performed the action (acting_user_user_id,acting_user_user_email), what action was performed (category,sub_category,action), and when it occurred (occurred_at).ACTIVITY_LOGIN- Tracks all user login attempts (both successful and unsuccessful) to your HubSpot account from the past 90 days. This table includes details such as login timestamp (login_at), whether the login succeeded (login_succeeded), IP address (ip_address), geographic location (location,country_code,region_code), and browser information (user_agent).ACTIVITY_SECURITY- Records security-related activities including CRM exports, user management changes, and integration installations. This table contains information about the type of security event (type), the user who performed the action (acting_user,user_id), when it occurred (created_at), and location details (ip_address,location,country_code,region_code).
These tables sync incrementally and require the account-info.security.read OAuth scope. You would need to re-auth to enable this scope. Please note that the AUDIT_LOG table is only available for Enterprise HubSpot accounts.
Lever
We have enabled soft delete for the following tables in Lever connector:
REQUISITION_OFFERREQUISITION_POSTING
We are gradually rolling out this change to all connections.
MongoDB
We no longer support selecting a pack mode at the table level and have removed the Select tables for packed mode radio button from the connection setup form. If pack modes are defined at the table level for your connection, the tables you have currently selected to sync using Packed mode will remain the same, but you can no longer change your table selections. We will sync the new tables using Unpacked mode. To make new selections, create separate connections for your Packed mode and Unpacked mode tables.
NetSuite SuiteAnalytics
We have updated the JDBC driver to version 8.10.184.0.
Oracle Fusion Cloud Applications
We have added a new toggle, Disable Effective Date Filtering, to the connection setup form to support the extraction of historical data without applying any filters for an effective date. You must set the toggle to ON if you want to capture the complete historical data without a predefined time period.
This configuration option is available only for new connections. Be sure to modify your configuration before creating a connection.
Recharge
We now incrementally sync the PAYMENT_METHOD table using webhook events. We are gradually rolling out this change to all connections.
The Trade Desk
We have added a new Report Templates selector to the setup form. You can now select platform-defined report templates during connector setup, and Fivetran will automatically create schedules for those templates via The Trade Desk API.
Note: The Trade Desk has a limit of 100 report schedules per partner account.
Upland Software
The Upland Software connector now supports API key authentication. To support this enhancement, we have made the following changes:
- Added a new drop-down menu, Authentication type, to the connection setup form. The drop-down menu allows you to select the authentication method of your choice.
- Added a new field, API key, to the connection setup form. The field allows you to specify your API key.
- Added two new parameters,
auth_typeandapi_key, to the Fivetran REST API.
For more information, see our setup instructions.
Webconnex
We have implemented pagination for the COUPON table.