December 2025
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.4.2 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Increased gRPC maximum inbound message size from 32MB to 128MB to support larger operations.
- Minor enhancements and improvements.
We have released version 2.4.1 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Logging improvements for better user experience.
- Minor enhancements and improvements.
- Updated tester - improved debugger performance.
fivetran-connector-sdk PyPI package
We have released version 2.4.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Minor enhancements and improvements.
fivetran-api-playground PyPI package
We have released version 1.1.2 of the fivetran-api-playground PyPI package. This release adds the following:
- Minor improvements and bug fixes.
- Updated dependencies.
We have released version 1.1.3 of the fivetran-api-playground PyPI package. This release adds the following:
- Upgrades the flask library dependency to 3.1.2.
- Upgrades the faker library dependency to 38.2.0.
Lite Connectors
Lite connectors are now available for the following sources:
New Destinations
Oracle
Oracle is an object-relational database management system created by the Oracle Corporation.
Read our Oracle destination documentation.
Partner SDK
ClickHouse destination is in beta
The ClickHouse destination is now in beta. For more information, see the ClickHouse destination documentation.
Row Filtering
Row filtering is now generally available and supported by all connectors except Lite connectors.
To learn how to use row filtering and see the list of supported connectors, see our Row Filtering documentation.
Sunset connectors
Height
We have sunset our Height connector.
We have deleted all existing Height connections. Effective December 3, 2025, we will no longer support the creation of new Height connections.
Sunset destinations
OneLake
We have sunset our OneLake destination. Effective December 19, 2025, you can no longer create any new OneLake destinations. However, if you are an existing OneLake user, you can create OneLake destinations until March 20, 2026. We will end support for all existing OneLake destinations on March 20, 2026. To continue managing your tables in OneLake, we recommend using our Managed Data Lake Service with OneLake integration.
Transformations for dbt Core
Updated dbt Quickstart packages
We have updated the Quickstart packages for the following connectors:
- Jira to version 1.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by January 19, 2026.
- Klaviyo to version 1.2.1. We are gradually rolling out this change. All Quickstart transformations will be updated by January 19, 2026.
- SAP ERP on HANA to version 0.5.1. We are gradually rolling out this change. All Quickstart transformations will be updated by January 18, 2026.
- Shopify to version 1.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by January 19, 2026.
- Xero to version 1.1.1. We are gradually rolling out this change. All Quickstart transformations will be updated by January 18, 2026.
Unstructured file replication
We now support the Unstructured File Replication feature for the following connectors:
We have added support for Unstructured File Replication for our Salesforce connector. You can now sync files managed in Salesforce Files, which are stored in ContentVersion. For more information, see our Salesforce documentation.
We now support file replication for all archive files. For more information, see our Unstructured File Replication documentation.
Schema changes
ADP Workforce Now
We have added a new column, voluntary_indicator, to the WORK_ASSIGNMENT_HISTORY table.
Akeneo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSET | |||||
| table | New Table | ASSET | |||
ASSET_FAMILY | |||||
| table | New Table | ASSET_FAMILY | |||
ASSET_FAMILY_PRODUCT_LINK_RULE | |||||
| table | New Table | ASSET_FAMILY_PRODUCT_LINK_RULE | |||
ASSET_FAMILY_TRANSFORMATION | |||||
| table | New Table | ASSET_FAMILY_TRANSFORMATION | |||
ATTRIBUTE_TABLE_CONFIGURATION_OPTION | |||||
| table | New Table | ATTRIBUTE_TABLE_CONFIGURATION_OPTION | |||
Amazon DSP
We have added two new tables, BID_ADJUSTMENT and REACH_AND_FREQUENCY. We are gradually rolling out this change to all connections.
Amazon Selling Partner
We have added a new table, FBA_RETURNS_REPORT, to the connector. We are gradually rolling out this change to all existing customers.
Ashby
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
APPLICATION_FEEDBACK | |||||
| column | Discontinued Column | custom_submitted_values_* | |||
APPLICATION_FEEDBACK_SUBMITTED_VALUE | |||||
| table | New Table | APPLICATION_FEEDBACK_SUBMITTED_VALUE | |||
APPLICATION_HISTORY | |||||
| table | New Table | APPLICATION_HISTORY | |||
APPLICATION_HISTORY_ALLOWED_ACTION | |||||
| table | New Table | APPLICATION_HISTORY_ALLOWED_ACTION | |||
Assembled
We have added the following new tables:
AGENT_STATE_HANDLE_TIMES_DAILY_REPORTAGENT_STATE_HANDLE_TIMES_HOURLY_REPORTAGENT_TICKET_STATS_DAILY_REPORTAGENT_TICKET_STATS_HOURLY_REPORTFORECAST_VS_ACTUAL
We are gradually rolling out this change to all existing connections.
Braze
We have added a new column, enabled, to the CAMPAIGN and CANVAS tables.
Chargebee Product Catalog 2.0
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
RAMP | |||||
| table | New Table | RAMP | |||
Checkout.com
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INSTRUMENT_BANK_ACCOUNT | |||||
| column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
| column | Primary Key Change | fingerprint_token 🔑 | fingerprint_token | No longer a primary key. | |
| column | Primary Key Change | id | id 🔑 | Added to primary key. | |
INSTRUMENT_CARD | |||||
| column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
| column | Primary Key Change | fingerprint_token 🔑 | fingerprint_token | No longer a primary key. | |
| column | Primary Key Change | id | id 🔑 | Added to primary key. | |
Coupa
We have added a new column, req_title, to the REQUISITION_HEADER table.
We have added a new column, version, to the ORDER_HEADER table.
Cube
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DRILLDOWN | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
Cvent
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EVENT_ROLE_ASSIGNMENT | |||||
| table | New Table | EVENT_ROLE_ASSIGNMENT | |||
EVENT_TRANSACTION | |||||
| column | New Column | batch_number | |||
| column | New Column | billing_address1 | |||
| column | New Column | billing_address2 | |||
| column | New Column | billing_address3 | |||
| column | New Column | billing_city | |||
| column | New Column | billing_country_code | |||
| column | New Column | billing_postal_code | |||
| column | New Column | billing_region | |||
| column | New Column | billing_region_code | |||
| column | New Column | cc_expiration_date | |||
| column | New Column | journal_number | |||
| column | New Column | name_on_credit_card | |||
| column | New Column | reference_number | |||
EVENT_TRANSACTION_ORDER | |||||
| table | New Table | EVENT_TRANSACTION_ORDER | |||
VIDEO_VIEW | |||||
| table | New Table | VIDEO_VIEW | |||
Discourse
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
POST | |||||
| column | New Column | deleted_by_avatar_template | |||
| column | New Column | deleted_by_id | |||
| column | New Column | deleted_by_name | |||
| column | New Column | deleted_by_username | |||
Exact Online
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TRANSACTION_LINE | |||||
| column | New Column | amount_dc | |||
| column | New Column | currency | |||
Facebook Pages
We've added the following new tables as replacements for deprecated impressions metrics:
DAILY_PAGE_METRICS_BY_PAID_ORGANIC(alternative forpage_impressions_paid)LIFETIME_POST_METRICS_BY_FOLLOWERS(alternative forpost_impressions_fans)LIFETIME_POST_METRICS_BY_PAID_ORGANIC(alternative forpost_impressions_paidandpost_impressions_organic)
These tables replace certain impressions metrics that were deprecated from the Graph API on November 15, 2025. Learn more about these changes in the Facebook Graph API changelog.
Factorial
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ATS_JOB_POSTING_ID | |||||
| table | New Table | ATS_JOB_POSTING_ID | |||
ATTENDANCE | |||||
| column | Discontinued Column | automatic_clock_in | |||
| column | Discontinued Column | automatic_clock_out | |||
| column | Discontinued Column | observations | |||
| column | New Column | clock_in_with_second | |||
| column | New Column | company_id | |||
| column | New Column | created_at | |||
| column | New Column | date | |||
| column | New Column | in_source | |||
| column | New Column | location_type | |||
| column | New Column | minutes | |||
| column | New Column | observation | |||
| column | New Column | out_source | |||
| column | New Column | reference_date | |||
| column | New Column | updated_at | |||
| column | New Column | workplace_id | |||
CANDIDATE | |||||
| column | Discontinued Column | source | |||
| column | New Column | company_id | |||
| column | New Column | consent_expiration_date | |||
| column | New Column | consent_given_at | |||
| column | New Column | consent_to_talent_pool | |||
| column | New Column | gender | |||
| column | New Column | inactive_since | |||
| column | New Column | personal_url | |||
| column | New Column | phone_number | |||
| column | New Column | score | |||
| column | New Column | source_id | |||
COMPANY | |||||
| table | Discontinued Table | COMPANY | |||
COMPENSATION | |||||
| column | New Column | currency | |||
| column | New Column | minimum_amount_of_hours | |||
| column | New Column | minimum_amount_of_hours_in_cents | |||
| column | New Column | time_condition | |||
CONTRACT | |||||
| column | Discontinued Column | level | |||
| column | Discontinued Column | role | |||
| column | New Column | annual_working_time_distribution | |||
| column | New Column | bank_holiday_treatment | |||
| column | New Column | company_id | |||
| column | New Column | contracts_es_tariff_group_id | |||
| column | New Column | created_at | |||
| column | New Column | has_trial_period | |||
| column | New Column | job_catalog_level_id | |||
| column | New Column | max_legal_yearly_hours | |||
| column | New Column | max_work_days_in_row | |||
| column | New Column | max_work_minutes_per_day | |||
| column | New Column | maximum_weekly_hours | |||
| column | New Column | min_rest_hours_in_row | |||
| column | New Column | min_rest_minutes_between_days | |||
| column | New Column | updated_at | |||
| column | New Column | working_time_percentage_in_cents | |||
CONTRACT_COMPENSATION | |||||
| table | Discontinued Table | CONTRACT_COMPENSATION | |||
DOCUMENT | |||||
| column | Discontinued Column | url | |||
| column | New Column | author_id | |||
| column | New Column | content_type | |||
| column | New Column | deleted_at | |||
| column | New Column | extension | |||
| column | New Column | file_size | |||
| column | New Column | is_company_document | |||
| column | New Column | is_management_document | |||
| column | New Column | is_pending_assignment | |||
| column | New Column | leave_id | |||
| column | New Column | signature_status | |||
| column | New Column | signees | |||
| column | New Column | space | |||
EMPLOYEE | |||||
| column | Discontinued Column | tax_id | |||
| column | Discontinued Column | timeoff_policy_id | |||
| column | New Column | access_id | |||
| column | New Column | active | |||
| column | New Column | address_line_1 | |||
| column | New Column | address_line_2 | |||
| column | New Column | age_number | |||
| column | New Column | attendable | |||
| column | New Column | birth_name | |||
| column | New Column | birthplace | |||
| column | New Column | city | |||
| column | New Column | country | |||
| column | New Column | country_of_birth | |||
| column | New Column | disability_percentage_cents | |||
| column | New Column | identifier_expiration_date | |||
| column | New Column | is_terminating | |||
| column | New Column | login_email | |||
| column | New Column | personal_email | |||
| column | New Column | phone_number | |||
| column | New Column | postal_code | |||
| column | New Column | preferred_name | |||
| column | New Column | pronouns | |||
| column | New Column | seniority_calculation_date | |||
| column | New Column | state | |||
EMPLOYEE_TEAM | |||||
| table | Discontinued Table | EMPLOYEE_TEAM | |||
EVENT | |||||
| table | Discontinued Table | EVENT | |||
FOLDER | |||||
| column | Discontinued Column | created_at | |||
| column | Discontinued Column | updated_at | |||
| column | New Column | parent_folder_id | |||
| column | New Column | space | |||
JOB_POSTING | |||||
| column | Discontinued Column | active_applications_count | |||
| column | Discontinued Column | allow_internal_apply | |||
| column | Discontinued Column | allow_referral | |||
| column | Discontinued Column | applications_count | |||
| column | Discontinued Column | gender_requirement | |||
| column | Discontinued Column | new_editor | |||
| column | Discontinued Column | personal_url_requirement | |||
| column | Discontinued Column | salary_permission | |||
| column | New Column | company_id | |||
| column | New Column | contract_type | |||
| column | New Column | preview_token | |||
| column | New Column | published_at | |||
| column | New Column | url | |||
LEAVE | |||||
| column | New Column | company_id | |||
| column | New Column | employee_full_name | |||
| column | New Column | hours_amount_in_cents | |||
| column | New Column | leave_type_name | |||
| column | New Column | reason | |||
| column | New Column | start_time | |||
LEAVE_TYPE | |||||
| column | New Column | payable | |||
LEGAL_ENTITIES | |||||
| column | New Column | tin | |||
LOCATION | |||||
| column | New Column | company_id | |||
| column | New Column | latitude | |||
| column | New Column | longitude | |||
| column | New Column | main | |||
| column | New Column | radius | |||
| column | New Column | siret | |||
LOCATION_COMPANY_HOLIDAY | |||||
| table | Discontinued Table | LOCATION_COMPANY_HOLIDAY | |||
POLICIES | |||||
| column | Discontinued Column | allowance_incidences | |||
| column | Discontinued Column | created_at | |||
| column | Discontinued Column | default_allowance_id | |||
| column | Discontinued Column | updated_at | |||
POST | |||||
| column | Discontinued Column | allow_comment_and_reaction | |||
| column | Discontinued Column | author_id | |||
| column | Discontinued Column | ends_at | |||
| column | Discontinued Column | location | |||
| column | Discontinued Column | reactions_count | |||
| column | Discontinued Column | starts_at | |||
| column | Discontinued Column | target_id | |||
| column | Discontinued Column | type | |||
| column | New Column | allow_comments_and_reactions | |||
SHIFT_MANAGEMENT | |||||
| column | Discontinued Column | work_area_id | |||
| column | New Column | company_id | |||
| column | New Column | default_shift_title | |||
| column | New Column | local_end_at | |||
| column | New Column | local_start_at | |||
| column | New Column | locations_work_area_id | |||
| column | New Column | name | |||
| column | New Column | timezone | |||
SUPPLEMENT | |||||
| column | Discontinued Column | created_by_access_id | |||
| column | Discontinued Column | description_entity | |||
| column | Discontinued Column | validated | |||
| column | New Column | company_id | |||
| column | New Column | created_at | |||
| column | New Column | currency | |||
| column | New Column | description | |||
| column | New Column | equivalent_minutes_in_cents | |||
| column | New Column | legal_entity_id | |||
| column | New Column | minutes_in_cents | |||
| column | New Column | raw_minutes_in_cents | |||
SUPPLEMENT_EMPLOYEE_OBSERVATION | |||||
| table | New Table | SUPPLEMENT_EMPLOYEE_OBSERVATION | |||
TASK | |||||
| column | New Column | author_employee_id | |||
| column | New Column | company_id | |||
| column | New Column | completed_by_id | |||
| column | New Column | created_at | |||
| column | New Column | status | |||
| column | New Column | updated_at | |||
TASK_FILE | |||||
| column | New Column | content_type | |||
| column | New Column | created_at | |||
TEAM_EMPLOYEE | |||||
| table | New Table | TEAM_EMPLOYEE | |||
WORKPLACE | |||||
| column | Discontinued Column | address_line_1 | |||
| column | Discontinued Column | address_line_2 | |||
| column | Discontinued Column | city | |||
| column | Discontinued Column | company_id | |||
| column | Discontinued Column | country | |||
| column | Discontinued Column | main | |||
| column | Discontinued Column | payroll_policy_id | |||
| column | Discontinued Column | phone_number | |||
| column | Discontinued Column | postal_code | |||
| column | Discontinued Column | state | |||
| column | Discontinued Column | timezone | |||
| column | New Column | archived_at | |||
| column | New Column | location_id | |||
Fillout
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SUBMISSION | |||||
| column | New Column | login_email | |||
Fivetran Platform Connector
The Fivetran Platform Connector no longer captures internal system columns, such as _fivetran_updated_cols, _fivetran_op_type, _fivetran_rowid_old, and _fivetran_earliest, in the DESTINATION_COLUMN table.
See our System Columns and Tables documentation for more details.
Fortnox
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ABSENCE_TRANSACTION | |||||
| table | New Table | ABSENCE_TRANSACTION | |||
ASSET | |||||
| table | New Table | ASSET | |||
Gladly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION_EXPORT_REPORT | |||||
| column | New Column | assisted_handoff | |||
| column | New Column | billable_resolution | |||
| column | New Column | sidekick_assisted_handoff_time | |||
| column | New Column | sidekick_conversation_channel | |||
| column | New Column | sidekick_resolved_time | |||
| column | New Column | sidekick_start_time | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION_CUSTOM_ATTRIBUTE | |||||
| table | New Table | CONVERSATION_CUSTOM_ATTRIBUTE | |||
CONVERSATION_CUSTOM_ATTRIBUTE_FREEFORM_TOPIC | |||||
| table | New Table | CONVERSATION_CUSTOM_ATTRIBUTE_FREEFORM_TOPIC | |||
Gmail
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
MESSAGE_PAYLOAD_SUB_PART_BODY | |||||
| table | New Table | MESSAGE_PAYLOAD_SUB_PART_BODY | |||
Google Ads
We have added 3 new metadata tables for audiences:
AUDIENCECOMBINED_AUDIENCECUSTOM_AUDIENCE
We have added the following columns to the AD_GROUP_CRITERION_HISTORY table:
audience_idcombined_audience_id
We will gradually roll out this change to all existing connections. Re-sync the AD_GROUP_CRITERION_HISTORY table to populate the new columns with data.
Google Play
Due to changes introduced by Google Play, we've made the following updates:
- We added the
sales_channelcolumn to theEARNINGSandSALEStables. - We updated the data type of the
product_typecolumn in theEARNINGStable from integer to string. - We renamed the
base_plan_idcolumn tobase_plan_or_purchase_option_idin theEARNINGSandSALEStables. - We renamed the
product_idcolumn topackage_idin theEARNINGSandSALEStables.
Harvest
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TIME_ENTRY | |||||
| column | New Column | approval_status | |||
HubSpot
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CART | |||||
| table | New Table | CART | |||
CART_CONTACT | |||||
| table | New Table | CART_CONTACT | |||
CART_DISCOUNT | |||||
| table | New Table | CART_DISCOUNT | |||
CART_LINE_ITEM | |||||
| table | New Table | CART_LINE_ITEM | |||
CART_ORDER | |||||
| table | New Table | CART_ORDER | |||
CART_PROPERTY_HISTORY | |||||
| table | New Table | CART_PROPERTY_HISTORY | |||
CART_QUOTE | |||||
| table | New Table | CART_QUOTE | |||
CART_TASK | |||||
| table | New Table | CART_TASK | |||
CART_TICKET | |||||
| table | New Table | CART_TICKET | |||
DISCOUNT | |||||
| table | New Table | DISCOUNT | |||
DISCOUNT_DEAL | |||||
| table | New Table | DISCOUNT_DEAL | |||
DISCOUNT_INVOICE | |||||
| table | New Table | DISCOUNT_INVOICE | |||
DISCOUNT_LINE_ITEM | |||||
| table | New Table | DISCOUNT_LINE_ITEM | |||
DISCOUNT_ORDER | |||||
| table | New Table | DISCOUNT_ORDER | |||
DISCOUNT_PAYMENT | |||||
| table | New Table | DISCOUNT_PAYMENT | |||
DISCOUNT_PROPERTY_HISTORY | |||||
| table | New Table | DISCOUNT_PROPERTY_HISTORY | |||
DISCOUNT_QUOTE | |||||
| table | New Table | DISCOUNT_QUOTE | |||
FEE | |||||
| table | New Table | FEE | |||
FEE_INVOICE | |||||
| table | New Table | FEE_INVOICE | |||
FEE_PAYMENT | |||||
| table | New Table | FEE_PAYMENT | |||
FEE_PROPERTY_HISTORY | |||||
| table | New Table | FEE_PROPERTY_HISTORY | |||
FEE_QUOTE | |||||
| table | New Table | FEE_QUOTE | |||
PAYMENT | |||||
| table | New Table | PAYMENT | |||
PAYMENT_COMPANY | |||||
| table | New Table | PAYMENT_COMPANY | |||
PAYMENT_CONTACT | |||||
| table | New Table | PAYMENT_CONTACT | |||
PAYMENT_DEAL | |||||
| table | New Table | PAYMENT_DEAL | |||
PAYMENT_INVOICE | |||||
| table | New Table | PAYMENT_INVOICE | |||
PAYMENT_LINE_ITEM | |||||
| table | New Table | PAYMENT_LINE_ITEM | |||
PAYMENT_PROPERTY_HISTORY | |||||
| table | New Table | PAYMENT_PROPERTY_HISTORY | |||
PAYMENT_QUOTE | |||||
| table | New Table | PAYMENT_QUOTE | |||
SUBSCRIPTION | |||||
| table | New Table | SUBSCRIPTION | |||
SUBSCRIPTION_COMPANY | |||||
| table | New Table | SUBSCRIPTION_COMPANY | |||
SUBSCRIPTION_CONTACT | |||||
| table | New Table | SUBSCRIPTION_CONTACT | |||
SUBSCRIPTION_DEAL | |||||
| table | New Table | SUBSCRIPTION_DEAL | |||
SUBSCRIPTION_FEEDBACK_SUBMISSION | |||||
| table | New Table | SUBSCRIPTION_FEEDBACK_SUBMISSION | |||
SUBSCRIPTION_INVOICE | |||||
| table | New Table | SUBSCRIPTION_INVOICE | |||
SUBSCRIPTION_LINE_ITEM | |||||
| table | New Table | SUBSCRIPTION_LINE_ITEM | |||
SUBSCRIPTION_ORDER | |||||
| table | New Table | SUBSCRIPTION_ORDER | |||
SUBSCRIPTION_PAYMENT | |||||
| table | New Table | SUBSCRIPTION_PAYMENT | |||
SUBSCRIPTION_PROPERTY_HISTORY | |||||
| table | New Table | SUBSCRIPTION_PROPERTY_HISTORY | |||
SUBSCRIPTION_QUOTE | |||||
| table | New Table | SUBSCRIPTION_QUOTE | |||
SUBSCRIPTION_TICKET | |||||
| table | New Table | SUBSCRIPTION_TICKET | |||
TAX | |||||
| table | New Table | TAX | |||
TAX_INVOICE | |||||
| table | New Table | TAX_INVOICE | |||
TAX_PAYMENT | |||||
| table | New Table | TAX_PAYMENT | |||
TAX_PROPERTY_HISTORY | |||||
| table | New Table | TAX_PROPERTY_HISTORY | |||
TAX_QUOTE | |||||
| table | New Table | TAX_QUOTE | |||
Impact Brand
We have added the following new tables:
PERFORMANCE_BY_DAYPERFORMANCE_BY_PARTNER
We are gradually rolling out these changes to all existing connections.
Intercom
We have added the following new columns to the CONVERSATION_HISTORY table:
conversation_rating_contact_external_idconversation_rating_contact_idsource_author_emailsource_author_namesource_redacted
We have added the following columns to the CONTACT_HISTORY table:
referrerutm_campaignutm_contentutm_mediumutm_sourceutm_term
These columns capture UTM marketing attribution parameters to help track campaign performance using a last-touch attribution model.
Lob
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
LETTER | |||||
| column | New Column | campaign_id | |||
Medallia Agile Research
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SURVEY_QUESTION_SUB_QUESTION | |||||
| table | New Table | SURVEY_QUESTION_SUB_QUESTION | |||
SURVEY_QUESTION_SUB_QUESTION_RESPONSE | |||||
| table | New Table | SURVEY_QUESTION_SUB_QUESTION_RESPONSE | |||
Open Exchange Rates
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
HISTORICAL_RATE | |||||
| table | New Table | HISTORICAL_RATE | |||
Pardot
We've added the following new tables:
ENGAGEMENT_STUDIO_PROGRAMLIFECYCLE_STAGE: It contains lifecycle stage definitions for the steps of a sales journey in Account Engagement, including Visitor, Prospect, Marketing Qualified Lead (MQL), and Sales Qualified Lead (SQL) stages.LIFECYCLE_HISTORY: The table contains records of prospect transitions between lifecycle stages, allowing you to track when prospects move through your sales funnel.
Partnerize
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSION | |||||
| table | New Table | CONVERSION | |||
CONVERSION_ITEM | |||||
| table | New Table | CONVERSION_ITEM | |||
Pinterest Organic
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PIN_ANALYTIC_DAILY_METRIC | |||||
| table | Discontinued Table | PIN_ANALYTIC_DAILY_METRIC | |||
PIN_ANALYTIC_MOBILE_DAILY_METRIC | |||||
| table | New Table | PIN_ANALYTIC_MOBILE_DAILY_METRIC | |||
PIN_ANALYTIC_TABLET_DAILY_METRIC | |||||
| table | New Table | PIN_ANALYTIC_TABLET_DAILY_METRIC | |||
PIN_ANALYTIC_WEB_DAILY_METRIC | |||||
| table | New Table | PIN_ANALYTIC_WEB_DAILY_METRIC | |||
PIN_ANALYTICS | |||||
| table | Discontinued Table | PIN_ANALYTICS | |||
PIN_ANALYTICS_MOBILE | |||||
| table | New Table | PIN_ANALYTICS_MOBILE | |||
PIN_ANALYTICS_TABLET | |||||
| table | New Table | PIN_ANALYTICS_TABLET | |||
PIN_ANALYTICS_WEB | |||||
| table | New Table | PIN_ANALYTICS_WEB | |||
Ramp
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BILL | |||||
| table | New Table | BILL | |||
BILL_ACCOUNTING_FIELD_SELECTION | |||||
| table | New Table | BILL_ACCOUNTING_FIELD_SELECTION | |||
BILL_INVENTORY_LINE_ITEM | |||||
| table | New Table | BILL_INVENTORY_LINE_ITEM | |||
BILL_INVENTORY_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||||
| table | New Table | BILL_INVENTORY_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||
BILL_INVOICE_URL | |||||
| table | New Table | BILL_INVOICE_URL | |||
BILL_LINE_ITEM | |||||
| table | New Table | BILL_LINE_ITEM | |||
BILL_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||||
| table | New Table | BILL_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||
BUSINESS_ENTITY | |||||
| table | New Table | BUSINESS_ENTITY | |||
BUSINESS_ENTITY_ACCOUNT | |||||
| table | New Table | BUSINESS_ENTITY_ACCOUNT | |||
BUSINESS_ENTITY_LOCATION | |||||
| table | New Table | BUSINESS_ENTITY_LOCATION | |||
MERCHANT | |||||
| table | New Table | MERCHANT | |||
PURCHASE_ORDER | |||||
| table | New Table | PURCHASE_ORDER | |||
PURCHASE_ORDER_ACCOUNTING_FIELD_SELECTION | |||||
| table | New Table | PURCHASE_ORDER_ACCOUNTING_FIELD_SELECTION | |||
PURCHASE_ORDER_BILL | |||||
| table | New Table | PURCHASE_ORDER_BILL | |||
PURCHASE_ORDER_LINE_ITEM | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM | |||
PURCHASE_ORDER_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM_ACCOUNTING_FIELD_SELECTION | |||
PURCHASE_ORDER_TRANSACTION | |||||
| table | New Table | PURCHASE_ORDER_TRANSACTION | |||
REIMBURSEMENT | |||||
| column | New Column | merchant_id | |||
VENDOR | |||||
| table | New Table | VENDOR | |||
VENDOR_CONTACT | |||||
| table | New Table | VENDOR_CONTACT | |||
Rocketlane
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PHASE | |||||
| table | New Table | PHASE | |||
RESOURCE_ALLOCATION | |||||
| table | New Table | RESOURCE_ALLOCATION | |||
RESOURCE_ALLOCATION_TASK | |||||
| table | New Table | RESOURCE_ALLOCATION_TASK | |||
SPACE | |||||
| table | New Table | SPACE | |||
SPACE_DOCUMENT | |||||
| table | New Table | SPACE_DOCUMENT | |||
TIME_OFF | |||||
| table | New Table | TIME_OFF | |||
TIMEOFF_USER_NOTIFICATION | |||||
| table | New Table | TIMEOFF_USER_NOTIFICATION | |||
ServiceTitan
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
APPOINTMENT_ASSIGNMENT | |||||
| column | New Column | active | |||
INVOICE | |||||
| column | New Column | active | |||
JOB_TYPE | |||||
| column | New Column | active | |||
PAYMENT | |||||
| column | New Column | active | |||
TikTok Ads
We've added support for syncing GMV Max Campaigns.
As part of the update, we've added the GMV_MAX_CAMPAIGN_HISTORY metadata table. We are gradually rolling out this change to all TikTok connections, and the table's MAR will be free for the first 30 days.
UKG Pro Workforce Management
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DEVICE | |||||
| table | New Table | DEVICE | |||
DEVICE_GROUP | |||||
| table | New Table | DEVICE_GROUP | |||
DEVICE_STATUS | |||||
| table | New Table | DEVICE_STATUS | |||
MANAGER | |||||
| table | New Table | MANAGER | |||
SCHEDULE_PATTERN | |||||
| table | New Table | SCHEDULE_PATTERN | |||
SCHEDULE_PATTERN_ITEM_AVAILABILITY_TEMPLATE_SEGMENT | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_AVAILABILITY_TEMPLATE_SEGMENT | |||
SCHEDULE_PATTERN_ITEM_PAY_CODE_EDIT_TEMPLATE_COMMENT_NOTE | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_PAY_CODE_EDIT_TEMPLATE_COMMENT_NOTE | |||
SCHEDULE_PATTERN_ITEM_PAY_CODE_EDIT_TEMPLATE_LABOR_CATEGORY_ENTRY | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_PAY_CODE_EDIT_TEMPLATE_LABOR_CATEGORY_ENTRY | |||
SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_COMMENT_NOTE | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_COMMENT_NOTE | |||
SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_SEGMENT | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_SEGMENT | |||
SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_SEGMENT_LABOR_CATEGORY_ENTRY | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SCHEDULE_TAG_TEMPLATE_SEGMENT_LABOR_CATEGORY_ENTRY | |||
SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_COMMENT_NOTE | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_COMMENT_NOTE | |||
SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT | |||
SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_LABOR_CATEGORY_ENTRY | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_LABOR_CATEGORY_ENTRY | |||
SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_PROFILE | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_PROFILE | |||
SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_TAG | |||||
| table | New Table | SCHEDULE_PATTERN_ITEM_SHIFT_TEMPLATE_SEGMENT_TAG | |||
TIME_OFF_REQUEST_MANAGER | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER | |||
TIME_OFF_REQUEST_MANAGER_APPROVAL_INFO_REVIEWER | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_APPROVAL_INFO_REVIEWER | |||
TIME_OFF_REQUEST_MANAGER_APPROVAL_PERIOD | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_APPROVAL_PERIOD | |||
TIME_OFF_REQUEST_MANAGER_COMMENT_NOTE | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_COMMENT_NOTE | |||
TIME_OFF_REQUEST_MANAGER_COMMENT_NOTE_DETAIL | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_COMMENT_NOTE_DETAIL | |||
TIME_OFF_REQUEST_MANAGER_PERIOD | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_PERIOD | |||
TIME_OFF_REQUEST_MANAGER_POSITION_DETAIL | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_POSITION_DETAIL | |||
TIME_OFF_REQUEST_MANAGER_POSITION_DETAIL_PRIMARY_JOB | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_POSITION_DETAIL_PRIMARY_JOB | |||
TIME_OFF_REQUEST_MANAGER_REQUEST_CHANGE | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_REQUEST_CHANGE | |||
TIME_OFF_REQUEST_MANAGER_REQUEST_CHANGE_COMMENT_NOTE | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_REQUEST_CHANGE_COMMENT_NOTE | |||
TIME_OFF_REQUEST_MANAGER_VALID_STATUS | |||||
| table | New Table | TIME_OFF_REQUEST_MANAGER_VALID_STATUS | |||
Workday Financial Management
We have added a new column, allowed_worktag_code, to the REVENUE_CATEGORY_ALLOWED_WORKTAGS and SALES_ITEM_ALLOWED_WORKTAG tables.
We have added a new column, organization_role_descriptor, to the ORGANIZATION_ROLE table.
We have added two new columns, type_descriptor and sub_type_descriptor, to the ORGANIZATION table.
We have added a new column, resource_category, to the PURCHASE_ORDER_SERVICE_LINE table.
We have added a new column, default_ledger_account_code, to the ACCOUNT_POSTING_RULE table.
We have added a new column, account_ledger_code, to the ACCOUNT_POSTING_RULE_CONDITION table.
We've added the following columns to the PURCHASE_ORDER table:
purchase_order_document_statuspayment_statusinvoice_statusreceiving_statusshipping_statustracking_status
Workday HCM
We have added a new column, time_off_plan_descriptor, to the TIME_OFF_PLAN_BALANCE table.
We have added a new column, management_level_descriptor, to the following tables:
POSITION_JOB_PROFILEWORKER_POSITIONWORKER_POSITION_HISTORY
We have added two new columns, primary_termination_category_descriptor and primary_termination_reason_descriptor, to the WORKER and WORKER_HISTORY tables.
Xactly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ATTAINMENT_MEASURE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | attainment_measure_id 🔑 | New primary key. | ||
ATTAINMENT_MEASURE_CRITERIA | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | attainment_measure_criteria_id 🔑 | New primary key. | ||
BUSINESS_GROUP | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | business_group_id 🔑 | New primary key. | ||
CO_ITEM_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | comp_order_assignment_id 🔑 | New primary key. | ||
COMMISSION | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | commission_id 🔑 | New primary key. | ||
COMP_ORDER_ITEM | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | comp_order_item_id 🔑 | New primary key. | ||
COMP_ORDER_ITEM_DETAIL | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | comp_order_item_detail_id 🔑 | New primary key. | ||
CREDIT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | credit_id 🔑 | New primary key. | ||
CREDIT_ADJUSTMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | credit_adjustment_id 🔑 | New primary key. | ||
CREDIT_HELD | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | credit_held_id 🔑 | New primary key. | ||
CREDIT_TOTAL | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | credit_totals_id 🔑 | New primary key. | ||
CREDIT_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | credit_type_id 🔑 | New primary key. | ||
CURRENCY_RATE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | currency_rate_id 🔑 | New primary key. | ||
DRAW | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | draw_id 🔑 | New primary key. | ||
DRAW_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | draw_assignment_id 🔑 | New primary key. | ||
EMP_STATUS_CODE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | emp_status_code_id 🔑 | New primary key. | ||
ORDER_STAGE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | order_stage_id 🔑 | New primary key. | ||
ORDER_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | order_type_id 🔑 | New primary key. | ||
PART_USER_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | part_user_assignment_id 🔑 | New primary key. | ||
PARTICIPANT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | participant_id 🔑 | New primary key. | ||
PAYMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | payment_id 🔑 | New primary key. | ||
PERIOD | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | period_id 🔑 | New primary key. | ||
PERIOD_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | period_type_id 🔑 | New primary key. | ||
PLAN | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | plan_id 🔑 | New primary key. | ||
PLAN_APPROVAL | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | plan_approval_id 🔑 | New primary key. | ||
PLAN_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | plan_assignment_id 🔑 | New primary key. | ||
PLAN_RULE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | planrules_id 🔑 | New primary key. | ||
POS_HIERARCHY | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | pos_hierarchy_id 🔑 | New primary key. | ||
POS_HIERARCHY_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | pos_hierarchy_type_id 🔑 | New primary key. | ||
POS_PART_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | pos_part_assignment_id 🔑 | New primary key. | ||
POS_REL_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | pos_rel_type_id 🔑 | New primary key. | ||
POS_TITLE_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | pos_title_assignment_id 🔑 | New primary key. | ||
POSITION | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | position_id 🔑 | New primary key. | ||
POSITION_HISTORY | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | position_id 🔑 | New primary key. | ||
QUOTA | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | quota_id 🔑 | New primary key. | ||
QUOTA_ASSIGNMENT | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | quota_assignment_id 🔑 | New primary key. | ||
QUOTA_RELATIONSHIP | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | quota_relationship_id 🔑 | New primary key. | ||
QUOTA_TOTAL | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | quota_totals_id 🔑 | New primary key. | ||
RATE_TABLE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | rate_table_id 🔑 | New primary key. | ||
RATE_TABLE_TIER | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | rate_table_tier_id 🔑 | New primary key. | ||
RATE_TIER_VALUE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | rate_tier_values_id 🔑 | New primary key. | ||
ROLE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | role_id 🔑 | New primary key. | ||
RULE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | rule_id 🔑 | New primary key. | ||
TITLE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | title_id 🔑 | New primary key. | ||
UNIT_TYPE | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | unit_type_id 🔑 | New primary key. | ||
USERS | |||||
| column | Discontinued Column | id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | user_id 🔑 | New primary key. | ||
Zip
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INVOICE_APPROVAL | |||||
| table | New Table | INVOICE_APPROVAL | |||
INVOICE_LINE_ITEM | |||||
| column | New Column | amortization_schedule_end_date | |||
| column | New Column | amortization_schedule_name | |||
| column | New Column | amortization_schedule_start_date | |||
INVOICE_LINE_ITEM_ATTRIBUTE | |||||
| table | New Table | INVOICE_LINE_ITEM_ATTRIBUTE | |||
INVOICE_LINE_ITEM_TAX_CODE | |||||
| table | New Table | INVOICE_LINE_ITEM_TAX_CODE | |||
TAX_CODE | |||||
| table | New Table | TAX_CODE | |||
Improvements
We now support shortcuts for tables in the OneLake Lakehouse. This feature is currently available only for the ADLS storage provider.
For more details, see our Managed Data Lake Service documentation.
Adobe Commerce
Our Adobe Commerce connector is now generally available. Read our Adobe Commerce connector documentation.
Appcues
We have made the following changes to the Appcues connector:
- Removed the Email field from the connection setup form
- Discontinued the
emailparameter from the Fivetran REST API
Assembled
We have updated our sync strategy to fix a bug where we didn't sync some records in the TIME_OFF_UPDATE and TIME_OFF_REQUEST tables.
Autodesk BIM 360 & Construction Cloud
We have renamed our Autodesk BIM 360 connector to Autodesk BIM 360 & Construction Cloud. This name change applies to the Fivetran dashboard and our documentation.
Azure Blob Storage
We have added a new feature, Dynamically extract tables. You can now define a single regex pattern with a named capture group (?<table>...) to automatically extract table names from file paths. This feature automatically creates and maps destination tables based on your file naming patterns, eliminating the need for manual intervention.
To support this feature, we have made the following changes to the connection setup form:
- Added a new option, File mapping, that allows you to choose between Define per table and Dynamically extract tables.
- Added a new field, Table extraction pattern, to specify your own regex pattern.
- Added a new button, Preview, to validate the specified regex pattern.
Key benefits include:
- Simplified configuration: Avoids repetitive setup for multiple entities.
- Automatic table creation: Captures new entities as they appear in your source, without additional configuration.
For more information, see our Dynamic Table Mapping tutorial and setup instructions.
We are gradually rolling out this change to all existing connections.
CockroachDB
We have made the following improvements to the CockroachDB connector:
- We now support syncing the BIT and VARBIT data types from your source. In your destination, these data types will appear as a STRING.
- We now support syncing the ARRAY data type from your source. All Fivetran supported data types are supported as array data types. In your destination, the ARRAY data type will appear as a JSON array.
Databricks destination
We now support loading data to tables with Liquid Clustering enabled.
Expensify
We now perform a rollback sync with every sync with a 3-month rollback window to capture updates for the EXPENSE table.
Facebook Ads
The Facebook Ads connector now uses a minimum 9-day rollback period for shorter attribution windows (1-day and 7-day) to ensure Meta's conversion data has adequate time to stabilize. This ensures we sync all data updates during this stabilization period.
Previously, the connector calculated the rollback window based on the largest configured attribution window. Now, we calculate the rollback window as follows:
- With a maximum 1-day attribution window, the connector fetches data from the last 9 days instead of just 1 day
- With a maximum 7-day attribution window, the connector now fetches data from the last 9 days instead of just 7 days
- With a maximum 28-day attribution window, the connector continues to fetch data from the last 28 days (unchanged)
This change will be gradually rolled out to Facebook Ads connections with 1-day or 7-day attribution windows, ensuring improved data quality with minimal impact on sync time.
We now support the following fields in our custom report tables:
objective_resultsobjective_result_ratecost_per_result
When the
objective_resultsfield is selected in a custom report, it is represented in the schema as a child table with the suffix_objective_results(for example,your_report_name_objective_results). This child table contains the following columns:Primary Key Columns:
_fivetran_id- Unique identifier of the parent recorddate- Date of the report aggregation (for aggregations Day, Lifetime)week- Week of the report aggregation (for aggregation Week)month- Month of the report aggregation (for aggregation Month)indicator- Type of objective result (for example,link_click,post_engagement,lead)attribution_window- Attribution window for the result (for example,1d_click,7d_click,28d_click)- Level ID column - The ID of the level being reported on (the column name depends on the report level:
ad_id,adset_id,campaign_id, oraccount_id)
Data Columns:
value- Numeric value of the objective result
Facebook Pages
We have upgraded our Facebook Pages connector to version 24.0 of the Graph API. We are gradually rolling out this update to all connections. For more information, see Graph API's changelog.
Gong
We have changed the sync strategy for the CALL and TRANSCRIPT tables to capture updates and deletes. We now re-import the CALL table once a week and the TRANSCRIPT table once a month.
HubSpot
We have added support for the following HubSpot APIs:
We are gradually rolling out this improvement to all existing connections.
Instagram Business
We have upgraded our Instagram connector to version 24.0 of the Graph API. We are gradually rolling out this change to all existing connections. For more information, see Graph API's changelog.
Klaviyo
Our Klaviyo connector now supports source naming feature. For more information, see our setup instructions.
You can now create custom reports using the Klaviyo Reporting API. For more information, see our documentation. For instructions on creating custom reports, see our setup guide.
Oracle Fusion Cloud Applications
You can now select the frequency for capturing deletes for your Oracle Fusion Cloud Applications connections. We have added a new optional drop-down menu, Delete Capture Frequency, to the connection setup forms. For more information, see our documentation.
PagerDuty
We have fixed a bug where we didn't sync the PAUSED_INCIDENT_REPORTING_ALERT table.
Pinterest Ads
We now explicitly specify report status filters when requesting account analytics reports from Pinterest. This ensures we consistently retrieve data for all relevant report statuses, including active, paused, archived, and other status types.
This improvement enhances data completeness and reliability for your analytics tables. For more information, see our Pinterest Ads documentation.
PostgreSQL
We have unified the JSON structure for range types. For more information, see our Sync PostgreSQL Range Data Types documentation.
We now support decoding extension types in both text and binary formats. For more information, see our Sync PostgreSQL Extension Data Types documentation.
We have disabled Query-Based (XMIN) extensions for connections using PostgreSQL versions 16 and 17 to prevent potential data integrity issues. A feature introduced in PostgreSQL 16, involving page freezing during non-freeze operations, may result in missed updates. For more information, contact our support team.
Reltio
Our Reltio connector is now generally available. Read our Reltio connector documentation.
Sage Intacct
We will re-import the PCBINVDETAIL and PCBINVSUMMARY tables without incremental updates.
The following tables will be synced incrementally:
AFFILIATEENTITYPROJECTCONTRACTPROJECTCONTRACTLINEPROJECTCONTRACTLINEENTRYPROJECTCONTRACTTYPE
Monthly Active Rows (MAR) for these tables will be free until December 31, 2025.
We are gradually rolling out this change to all existing connections starting on December 8, 2025.
SFTP
We have added a new feature, Dynamically extract tables. You can now define a single regex pattern with a named capture group, (?<table>...), to automatically extract table names from file paths. This feature automatically creates and maps destination tables based on your file naming patterns, eliminating the need for manual intervention.
To support this feature, we have made the following changes to the connection setup form:
- Added a new option, File mapping, that allows you to choose between Define per table and Dynamically extract tables.
- Added a new field, Table extraction pattern, to specify your own regex pattern.
- Added a new button, Preview, to validate the specified regex pattern.
Key benefits include:
- Simplified configuration: Avoids repetitive setup for multiple entities.
- Automatic table creation: Captures new entities as they appear in your source, without additional configuration.
For more information, see our Dynamic Table Mapping tutorial and setup instructions.
We are gradually rolling out this change to all existing connections.
SISTRIX
You can now specify the country whose data you want to sync. To support this enhancement, we have made the following changes:
- Added a new drop-down menu, Country, to the connection setup form
- Added a new parameter,
country, to the Fivetran REST API
Splash
We now re-import the EVENT table and its child tables daily to capture updates and deletes.
SQL Server
The Binary Log Reader incremental sync method for our SQL Server connector is now generally available. This proprietary method reads your database's transaction log files in their original binary format. For more information, see our SQL Server - Binary Log Reader documentation.
UKG Pro
We have updated the sync strategy for the COMPENSATION table. We now re-import the table during every sync. Previously, we incrementally synced the table.
Veeva Vault
Our Veeva Vault connector is now generally available.
Read our Veeva Vault connector documentation.
Vitally
We now incrementally sync the CONVERSATION table and its child tables, and we no longer capture deletes for this table.
Workday Financial Management
We have changed our sync strategy for the CURRENCY_CONVERSION_RATE table. We now incrementally sync the table for improved sync performance.
REST API Improvements
User role update restriction
You can no longer change your account role either through the Update a User endpoint or in the dashboard.