April 2026

Connector SDK

`fivetran-connector-sdk` PyPI package

We have released version 2.8.0 of the fivetran-connector-sdk PyPI package. This release includes the following updates:

Improved overall performance and stability.
Better user experience with enhanced logging.
Updated testers that now support Transactional Checkpoint.
Minor enhancements and improvements.

Lite Connectors

Lite connectors are now available for the following sources:

National Heavy Vehicle Regulator

Logs

AWS CloudWatch

We have deprecated the Access Key authentication method for CloudWatch. Use the IAM Role authentication method instead.

Schema fetch optimisation

Fixed-schema connectors

We've implemented a new mechanism to fetch source schema quicker when creating a new connection. Now, instead of deriving the schema from source data, we use fixed schema models. This allows you to see the schema blocking and hashing screen almost immediately after creating a new connection.

As a result of this improvement, you may see empty tables and columns in the Schema tab of existing connections that have not yet synced to your destination.

Schema changes

Asana

We've added a new table, TASK_DEPENDENCY. The table contains task dependency relationships, linking tasks to the tasks they depend on.

We have added support for reference-type custom fields in the TASK, PROJECT, and PORTFOLIO tables. Values from these fields now appear as dynamic custom_* columns containing the GID(s) of the referenced objects.

Braze

We have added the following three new columns to the MESSAGE_VARIATION table:

action
image_url
large_image_url

We've added the is_sms_fallback column to the SMS_EVENT table.

Campfire

Effective April 1, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to resolve the data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

4 total changes • 4 possible breaking changes

Table/column	Change type	New name	Notes
`BALANCE_SHEET`
column	Primary Key Change	`start_date` 🔑	Added to primary key.
`CASH_FLOW`
column	Primary Key Change	`start_date` 🔑	Added to primary key.
`INCOME_STATEMENT`
column	Primary Key Change	`start_date` 🔑	Added to primary key.
`TRAIL_BALANCE`
column	Primary Key Change	`start_date` 🔑	Added to primary key.

Cin7 Core

Effective April 15, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`PRODUCT_AVAILABILITY`
column	Primary Key Change	`product_id` 🔑	`product_id`	No longer primary key
column	Primary Key Change		`_fivetran_id` 🔑	New primary key

Criteo Retail Media

Effective April 7, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

4 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`REPORT_CAMPAIGN`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	Discontinued Column	`hour`
`REPORT_LINE_ITEM`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	Discontinued Column	`hour`

Factbird

Effective April 1, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`ANDON_CALL`
table	New Table	`ANDON_CALL`
`ANDON_CALL_TAG`
table	New Table	`ANDON_CALL_TAG`

HubSpot

We've added a new table, LEAD_DEAL. The table contains associations between leads and deals.

Intercom

We've added a new table, CONVERSATION_SOURCE_ATTACHMENT_HISTORY.

Kantata

We have added a new column, status, to the STORY table.

We have added custom field columns to the WORKSPACE_RESOURCE table.

Klaviyo

We have added a new table, PUSH_TOKEN.

We have added the following new mobile push subscription columns to the PERSON table:

SUBSCRIPTIONS_MOBILE_PUSH_MARKETING_CONSENT
SUBSCRIPTIONS_MOBILE_PUSH_MARKETING_TIMESTAMP
SUBSCRIPTIONS_MOBILE_PUSH_MARKETING_METHOD
SUBSCRIPTIONS_MOBILE_PUSH_MARKETING_METHOD_DETAIL
SUBSCRIPTIONS_MOBILE_PUSH_MARKETING_CAN_RECEIVE_PUSH_MARKETING

Mailchimp

We've added a new table, CAMPAIGN_REPORT.

We've added a new table, CAMPAIGN_CLICK_REPORT.

Microsoft Advertising

We've added a new table, CONVERSION_GOAL_HISTORY. The table contains historical records of conversion goals defined in Microsoft Advertising. We are gradually rolling out these changes to all existing connections.

You can populate the new table with data for free until April 13, 2026. Exclude the table from your connection schema before that date if you don't want it to count toward paid MAR.

We've added the SEARCH_CAMPAIGN_CHANGE_HISTORY_REPORT reporting table. We are gradually rolling out this change to all existing connections.

You can populate the new table with data for free until May 5, 2026. Exclude the table from your connection's schema before that date if you don't want the table's usage to count toward paid MAR.

See Microsoft documentation for more details.

Oracle Fusion Field Service

Effective April 9, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

10 total changes • 10 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`RESOURCE_DESCENDANT`
column	Primary Key Change	`resource_id` 🔑	`resource_id`	No longer primary key
column	Primary Key Change	`resource_internal_id`	`resource_internal_id` 🔑	Added to primary key
`RESOURCE_DESCENDANT_INVENTORY`
column	Discontinued Column	`resource_descendant_resource_id` 🔑		No longer primary key
column	Primary Key Change		`resource_descendant_internal_id` 🔑	New primary key
`RESOURCE_DESCENDANT_WORK_SCHEDULE`
column	Discontinued Column	`resource_descendant_resource_id` 🔑		No longer primary key
column	Primary Key Change		`resource_descendant_internal_id` 🔑	New primary key
`RESOURCE_DESCENDANT_WORK_SKILL`
column	Discontinued Column	`resource_descendant_resource_id` 🔑		No longer primary key
column	Primary Key Change		`resource_descendant_internal_id` 🔑	New primary key
`RESOURCE_DESCENDANT_WORK_ZONE`
column	Discontinued Column	`resource_descendant_resource_id` 🔑		No longer primary key
column	Primary Key Change		`resource_descendant_internal_id` 🔑	New primary key

Pendo

We have added the following new tables:

SEGMENT_HISTORY
SEGMENT_FILTER
SEGMENT_PIPELINE
SEGMENT_DEPENDENT_METADATA

We are gradually rolling out this change to all existing connections.

Rakuten Advertising

Effective April 2, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`REPORT`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	New Column		`consumer_country`
column	New Column		`transaction_id`

Ramp

Effective April 9, 2026 we use a new April 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`BILL`
column	New Column			`status_summary`

Square

We have added the two new columns, device_detail_device_id and device_detail_device_installation_id, to the PAYMENT table.

SurveyMonkey

We have added a new column, tag_data, to the RESPONSE_ANSWER table.

TikTok Ads

We now support additional metrics for basic custom reports. For a full list of available metrics visit TikTok API documentation.

We've added a new table, LOCATION. The table contains available ad delivery locations for each advertiser, including region hierarchy (country, province, city, district), area type, and age targeting support.

Workday HCM

As part of the phased rollout announced in January 2026, we have implemented the following schema changes for connections set up on or before January 5, 2026:

Stopped syncing data into the following legacy tables:
- MILITARY_SERVICE
- PERSON_DISABILITY
- PERSONAL_INFORMATION_ETHNICITY
- RELATIVE_NAME
Renamed the following legacy tables:
- MILITARY_SERVICE to MILITARY_SERVICE_BACKUP
- PERSON_DISABILITY to PERSON_DISABILITY_BACKUP
- PERSONAL_INFORMATION_ETHNICITY to PERSONAL_INFORMATION_ETHNICITY_BACKUP
- RELATIVE_NAME to RELATIVE_NAME_BACKUP
Renamed the following new tables:
- MILITARY_SERVICE_INCOMING to MILITARY_SERVICE
- PERSON_DISABILITY_INCOMING to PERSON_DISABILITY
- PERSONAL_INFORMATION_ETHNICITY_INCOMING to PERSONAL_INFORMATION_ETHNICITY
- RELATIVE_NAME_INCOMING to RELATIVE_NAME
Stopped syncing data into the following columns of the PERSONAL_INFORMATION table, which are now available in the COUNTRY_PERSONAL_INFORMATION and PERSONAL_INFORMATION_COMMON_DATA tables:
- additional_nationality
- blood_type
- city_of_birth
- city_of_birth_code
- citizenship_status
- country_of_birth
- country_region_of_birth
- date_of_birth
- date_of_death
- gender
- hispanic_or_latino
- hukou_locality
- hukou_postal_code
- hukou_region_code
- hukou_subregion_code
- hukou_type_code
- last_medical_exam_date
- last_medical_exam_valid_to
- local_hukou
- marital_status
- marital_status_date
- medical_exam_notes
- native_region
- native_region_code
- personnel_file_agency_for_person
- political_affiliation
- primary_nationality
- region_of_birth
- religion
- social_benefits_locality

Be sure to update your downstream queries to reflect these changes. To backfill historical data for the renamed tables, re-sync them.

Xero

We have added a new column, tracking_category_option_id, to the following tables: -BANK_TRANSACTION_LINE_ITEM_HAS_TRACKING_CATEGORY -INVOICE_LINE_ITEM_HAS_TRACKING_CATEGORY -MANUAL_JOURNAL_LINE_HAS_TRACKING_CATEGORY -OVERPAYMENT_LINE_ITEM_HAS_TRACKING_CATEGORY -PURCHASE_ORDER_LINE_ITEM_HAS_TRACKING_CATEGORY

We have added a new column, account_id, to the following tables:

BANK_TRANSACTION_LINE_ITEMS
CREDIT_NOTE_LINE_ITEM
INVOICE_LINE_ITEM
OVERPAYMENT_LINE_ITEM
PREPAYMENT_LINE_ITEM
PURCHASE_ORDER_LINE_ITEM
RECEIPT_LINE_ITEM
REPEATING_INVOICE_LINE_ITEM

Improvements

Amazon S3

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Azure Blob Storage

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Box

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

ClickUp

We now support syncing sprint tasks in the TASK table.

Collibra

We now sync data for both active and disabled users into the USERS table. Previously, we synced only active users into this table.

Consensus Demo Automation Platform

Fixed an issue in the TRACK_DEMO_BOARD table where certain fields were left empty due to an invalid extraction path. This fix ensures that external_opportunity_id, external_opportunity_name, external_account_id, and external_account_name are now extracted and filled as expected.

Dropbox

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Email

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

FTP

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Google Cloud Storage

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Google Drive

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Managed Data Lake Service

We have improved how we handle BIGDECIMAL data for Managed Data Lake Service destinations. If a column’s precision is up to 38 and the scale is up to 10, we now preserve the original precision and scale when converting the data type to DECIMAL. Previously, we converted such columns to DECIMAL(38, 10) regardless of the source definition. This change applies only to new columns; existing columns remain unchanged.

We are gradually rolling out this improvement to all existing destinations.

Microsoft Dynamics 365 Business Central

The Microsoft Dynamics 365 Business Central connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

PostgreSQL destination

We now sync binary columns to PostgreSQL destinations as the native bytea type. Previously, we stored binary data as base64-encoded or text strings, which required an explicit DECODE cast when querying. We are gradually rolling out this change to all existing destinations.

Row filtering support for boolean data type

Row filtering now supports the boolean data type. You can filter rows by boolean column values using the Equal To and Not Equal To operators, as well as Is NULL and Is not NULL.

For more information, see our row filtering documentation.

S3-Compatible Storage

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Samsara

We have added OAuth 2.0 as a new authentication method for the Samsara connector. 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.
Added two new fields, App ID and App secret, to the connection setup form. These fields appear only when you select OAuth 2.0 authentication and allow you to provide your OAuth 2.0 app credentials.
Renamed the Access Token field to API token.
Added the following parameters to the Fivetran REST API:
- auth_type
- app_id
- app_secret

For more information, see our setup instructions.

SAP ERP on HANA

A new version of the Fivetran NetWeaver API is now available for download: v1900313.

Improvements in Fivetran NetWeaver API v1900313:

We improved the segregation of database schemas in a source and fixed a bug where the table type was determined wrongly due to a reference to the wrong schema.

SFTP

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

SharePoint

We now allow you to update the primary key column after the initial sync when using the Upsert file using custom primary key option.

Zoho CRM

We have added support for the Zoho Japan (JP) data center. For more information, see our setup instructions.

April 2026

Connector SDK

fivetran-connector-sdk PyPI package

Lite Connectors

Logs

AWS CloudWatch

Schema fetch optimisation

Fixed-schema connectors

Schema changes

Asana

Braze

Campfire

Cin7 Core

Criteo Retail Media

Factbird

HubSpot

Intercom

Kantata

Klaviyo

Mailchimp

Microsoft Advertising

Oracle Fusion Field Service

Pendo

Rakuten Advertising

Ramp

Square

SurveyMonkey

TikTok Ads

Workday HCM

Xero

Improvements

Amazon S3

Azure Blob Storage

Box

ClickUp

Collibra

Consensus Demo Automation Platform

Dropbox

Email

FTP

Google Cloud Storage

Google Drive

Managed Data Lake Service

Microsoft Dynamics 365 Business Central

PostgreSQL destination

Row filtering support for boolean data type

S3-Compatible Storage

Samsara

SAP ERP on HANA

SFTP

SharePoint

Zoho CRM

`fivetran-connector-sdk` PyPI package