October 2024

Coalesce Orchestration

You can now use Coalesce* Orchestration to trigger transformation runs from Fivetran. This feature is now available in Beta.

* Coalesce is a trademark of Coalesce Automation, Inc. All rights therein are reserved to Coalesce Automation, Inc. Fivetran Transformations is not a product or service of or endorsed by Coalesce Automation, Inc.

Connector SDK

`fivetran-connector-sdk` PyPI package

We have released version 0.10.24.1 of the PyPI package. This release provides improved error logging and updated testers for fivetran debug.

Lite Connectors

Lite connectors are now available for the following sources:

Hybrid Deployment support

The following Lite connectors now support the Hybrid Deployment model:

Proxy Agent

The Fivetran Proxy Agent connection method is now available for the Azure uksouth (London) region. The Proxy Agent allows you to connect Fivetran to your database securely. Installed behind your firewall, it initiates communication with Fivetran, eliminating the need for other complicated networking options.

Transformations for dbt Core

Multi-Connector Quickstart transformations

You can now add multi-connector Quickstart transformations for the following data model types:

Select the relevant package provided the supported connectors have already been created.
Select the relevant connectors from the list of available connectors.
Select the schedule: Integrated or Custom.
Click Save. The transformation will be created and run by the dbt-runner.

Updated dbt Quickstart package

We have updated the Quickstart package for the Zendesk Support connector to version 0.18.0.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

Schema changes

Aha!

Effective October 24, 2024 we use a new November 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made the following schema changes to improve schema usability and also added new tables.

133 total changes • 0 possible breaking changes

Table/column	Change type	New name
`EPIC`
column	New Column	`assigned_to_user`
column	New Column	`attachments`
column	New Column	`comments_count`
column	New Column	`created_by_user_id`
column	New Column	`description_attachments`
column	New Column	`description_body`
column	New Column	`description_created_at`
column	New Column	`description_id`
column	New Column	`description_updated_at`
column	New Column	`due_date`
column	New Column	`duration_source`
column	New Column	`epic_links`
column	New Column	`epic_only_original_estimate`
column	New Column	`epic_only_remaining_estimate`
column	New Column	`epic_only_work_done`
column	New Column	`features`
column	New Column	`full_tags`
column	New Column	`goals`
column	New Column	`initial_estimate`
column	New Column	`initiative_reference_num`
column	New Column	`integration_fields`
column	New Column	`master_feature_only_original_estimate`
column	New Column	`master_feature_only_remaining_estimate`
column	New Column	`master_feature_only_work_done`
column	New Column	`original_estimate`
column	New Column	`owner_created_at`
column	New Column	`owner_email`
column	New Column	`owner_id`
column	New Column	`owner_name`
column	New Column	`owner_updated_at`
column	New Column	`position`
column	New Column	`product_id`
column	New Column	`progress`
column	New Column	`progress_source`
column	New Column	`project_created_at`
column	New Column	`project_id`
column	New Column	`project_name`
column	New Column	`project_product_line`
column	New Column	`project_reference_prefix`
column	New Column	`project_url`
column	New Column	`project_workspace_type`
column	New Column	`release_created_at`
column	New Column	`release_id`
column	New Column	`release_integration_fields`
column	New Column	`release_name`
column	New Column	`release_parking_lot`
column	New Column	`release_product_id`
column	New Column	`release_reference_num`
column	New Column	`release_resource`
column	New Column	`release_url`
column	New Column	`remaining_estimate`
column	New Column	`score`
column	New Column	`score_facts`
column	New Column	`start_date`
column	New Column	`status_changed_on`
column	New Column	`tags`
column	New Column	`time_tracking_events`
column	New Column	`updated_at`
column	New Column	`use_feature_estimates`
column	New Column	`work_done`
column	New Column	`work_units`
column	New Column	`workflow_status_color`
column	New Column	`workflow_status_complete`
column	New Column	`workflow_status_id`
column	New Column	`workflow_status_name`
column	New Column	`workflow_status_position`
`EPIC_CUSTOM_FIELD`
table	New Table	`EPIC_CUSTOM_FIELD`
`EPIC_WORKFLOW_STATUS_TIME`
table	New Table	`EPIC_WORKFLOW_STATUS_TIME`
`FEATURE`
column	New Column	`created_by_user_id`
column	New Column	`description_attachment`
column	New Column	`description_body`
column	New Column	`description_created_at`
column	New Column	`description_id`
column	New Column	`description_updated_at`
column	New Column	`due_date`
column	New Column	`epic_reference_num`
column	New Column	`feature_only_original_estimate`
column	New Column	`feature_only_remaining_estimate`
column	New Column	`feature_only_work_done`
column	New Column	`goal_id`
column	New Column	`initial_estimate`
column	New Column	`initiative_id`
column	New Column	`initiative_reference_num`
column	New Column	`original_estimate`
column	New Column	`position`
column	New Column	`progress`
column	New Column	`progress_source`
column	New Column	`release_id`
column	New Column	`release_reference_num`
column	New Column	`remaining_estimate`
column	New Column	`requirement_id`
column	New Column	`score`
column	New Column	`start_date`
column	New Column	`status_changed_on`
column	New Column	`updated_at`
column	New Column	`use_requirements_estimates`
column	New Column	`work_done`
column	New Column	`work_units`
column	New Column	`workflow_id`
`FEATURE_CUSTOM_FIELD`
table	New Table	`FEATURE_CUSTOM_FIELD`
`PRODUCT`
column	New Column	`capacity_planning_enabled`
column	New Column	`children`
column	New Column	`custom_fields`
column	New Column	`default_capacity_units`
column	New Column	`description_body`
column	New Column	`description_created_at`
column	New Column	`description_id`
column	New Column	`description_updated_at`
column	New Column	`enhanced_capacity_planning_enabled`
column	New Column	`has_epics`
column	New Column	`has_ideas`
column	New Column	`has_master_features`
column	New Column	`parent_id`
column	New Column	`product_line_type`
column	New Column	`resource`
column	New Column	`updated_at`
column	New Column	`url`
`TASK`
column	New Column	`body`
column	New Column	`comments_count`
column	New Column	`created_by_user_id`
column	New Column	`position`
column	New Column	`product_id`
column	New Column	`resource`
column	New Column	`taskable_id`
column	New Column	`taskable_name`
column	New Column	`taskable_reference_num`
column	New Column	`taskable_resource`
column	New Column	`taskable_type`
column	New Column	`taskable_url`
column	New Column	`updated_at`
column	New Column	`url`
`TASK_ASSIGNED_TO_USER`
table	New Table	`TASK_ASSIGNED_TO_USER`
`TASK_ATTACHMENT`
table	New Table	`TASK_ATTACHMENT`

Chargebee Product Catalog 2.0

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

This schema change is required due to a data integrity issue in the INVOICE_LINE_ITEM table.

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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`INVOICE_LINE_ITEM`
column	Primary Key Change		`invoice_id`	`invoice_id` 🔑	Added to primary key.

Collibra

Effective October 17, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to enhance the usability and efficiency of the connector schema.

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.

6 total changes • 6 possible breaking changes

Table/column	Change type	Old name	Notes
`ASSET_TAG`
table	Deprecated Table	`ASSET_TAG`	Data now available in the `TAGS` table.
`ASSIGNMENT_ATTRIBUTE_TYPE`
table	Deprecated Table	`ASSIGNMENT_ATTRIBUTE_TYPE`	Child table of the `ASSIGNMENT_COMPLEX_RELATION_TYPE` table.
`ASSIGNMENT_COMPLEX_RELATION_TYPE`
table	Deprecated Table	`ASSIGNMENT_COMPLEX_RELATION_TYPE`	Data now available in the `COMPLEX_RELATION_TYPE` table.
`ASSIGNMENT_DOMAIN`
table	Deprecated Table	`ASSIGNMENT_DOMAIN`	Data now available in the `ASSET_TYPE` table.
`ASSIGNMENT_LEG_TYPE`
table	Deprecated Table	`ASSIGNMENT_LEG_TYPE`	Child table of the `ASSIGNMENT_COMPLEX_RELATION_TYPE` table.
`ASSIGNMENT_RELATION_TYPE`
table	Deprecated Table	`ASSIGNMENT_RELATION_TYPE`	Data now available in the `RELATION_TYPE` table.

commercetools

Effective October 1, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are required to 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	New name	Notes
`PRODUCT_VARIANT_ATTRIBUTE`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_IMAGE`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_PRICE_TIER`
column	Primary Key Change	`product_id` 🔑	New primary key.
`PRODUCT_VARIANT_PRICES`
column	Primary Key Change	`product_id` 🔑	New primary key.

Crossbeam

Effective October 17, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made these schema changes to introduce a feature enhancement.

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.

11 total changes • 3 possible breaking changes

Table/column	Change type	New name
`OVERLAP_ACCOUNT`
table	New Table	`OVERLAP_ACCOUNT`
`OVERLAP_ACCOUNT_PARTNER_POPULATION`
table	New Table	`OVERLAP_ACCOUNT_PARTNER_POPULATION`
`OVERLAP_ACCOUNT_PARTNER_SOURCE_DATA`
table	New Table	`OVERLAP_ACCOUNT_PARTNER_SOURCE_DATA`
`OVERLAP_ACCOUNT_POPULATION`
table	New Table	`OVERLAP_ACCOUNT_POPULATION`
`OVERLAP_LEAD`
table	New Table	`OVERLAP_LEAD`
`OVERLAP_LEAD_PARTNER_POPULATION`
table	New Table	`OVERLAP_LEAD_PARTNER_POPULATION`
`OVERLAP_LEAD_PARTNER_SOURCE_DATA`
table	New Table	`OVERLAP_LEAD_PARTNER_SOURCE_DATA`
`OVERLAP_LEAD_POPULATION`
table	New Table	`OVERLAP_LEAD_POPULATION`
`PARTNER_RECORD`
table	Deprecated Table
`PARTNER_RECORD_POPULATION`
table	Deprecated Table
`RECORD_PARTNER_POPULATION`
table	Deprecated Table

Cvent

Effective October 1, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to add new tables.

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
`ATTENDEE_ANSWER_VALUE`
table	New Table		`ATTENDEE_ANSWER_VALUE`
`ATTENDEE_QUESTION`
column	Deprecated Column	`value`
`QUESTION_VALUE`
table	New Table		`QUESTION_VALUE`

dbt Cloud

Effective October 10, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made the following schema changes to introduce a feature enhancement.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`ACCOUNT`
table	New Table	`ACCOUNT`
`AUDIT_LOG_EVENT`
table	New Table	`AUDIT_LOG_EVENT`

Dropbox Sign

Effective October 21, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made this schema change to improve the schema 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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`SIGNATURE_RESPONSE`
column	Primary Key Change			`_fivetran_id` 🔑	Added to the primary key

Facebook Ads

The BASIC_AD_ACTION_VALUES prebuilt report is now the child table of the BASIC_AD prebuilt report.

Facebook Pages

We removed the following metrics since Facebook has deprecated them for all API versions on September 16, 2024, according to Facebook's changelog:

page_impressions_organic_v2
page_impressions_organic_unique_v2
page_impressions_by_story_type
page_impressions_by_story_type_unique
page_impressions_by_city_unique
page_impressions_by_country_unique
page_impressions_by_locale_unique
page_impressions_by_age_gender_unique
page_impressions_viral_frequency_distribution
page_consumptions_unique
page_consumptions_by_consumption_type
page_consumptions_by_consumption_type_unique
page_places_checkin_total
page_places_checkin_total_unique
page_negative_feedback
page_negative_feedback_unique
page_negative_feedback_by_type
page_negative_feedback_by_type_unique
page_fans_online
page_fans_online_per_day
page_call_phone_clicks_logged_in_unique
page_get_directions_clicks_logged_in_unique
page_website_clicks_logged_in_unique
page_tab_views_login_top_unique
page_tab_views_login_top
page_tab_views_logout_top
page_posts_impressions_organic
page_posts_impressions_organic_unique
post_impressions_by_story_type
post_impressions_by_story_type_unique
post_engaged_users
post_negative_feedback
post_negative_feedback_unique
post_negative_feedback_by_type
post_negative_feedback_by_type_unique
post_engaged_fan
post_clicks_unique
post_clicks_by_type_unique

We also removed the following DAILY PAGE METRIC CATEGORIES because there are no metrics anymore that belong to those categories:

BY_CONSUMPTION_TYPE
BY_FREQUENCY_DISTRIBUTION
BY_PROFILE_TAB
BY_STORY_TYPE

We also removed the following reporting tables because there are no metrics anymore that belong to those tables:

PAGE_METRICS_BY_AGE_GENDER
PAGE_METRICS_BY_CONSUMPTION_TYPE
PAGE_METRICS_BY_FREQUENCY_DISTRIBUTION
PAGE_METRICS_BY_PROFILE_TAB
PAGE_METRICS_BY_STORY_TYPE
PAGE_METRICS_BY_TIME
PAGE_METRICS_BY_TYPE
POST_METRICS_BY_STORY_TYPE

Fivetran Platform Connector

We have added the new CONNECTOR_SDK_LOG table. The Fivetran Platform Connector now syncs Connector SDK logs to this table.

We have added a new nullable column, connector_id, to the DESTINATION_SCHEMA_METADATA, DESTINATION_TABLE_METADATA, and DESTINATION_COLUMN_METADATA tables in the Metadata Sharing section. This column, going forward, will be populated with the ID of the connector that each schema, table, or column belongs to.

Flexport

Effective October 23, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made these schema changes to improve schema 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.

413 total changes • 136 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADDRESS`
table	Deprecated Table	`ADDRESS`
`BOOKING`
column	Deprecated Column	`consignee_entity_name`
column	Deprecated Column	`consignee_entity_object`
column	Deprecated Column	`consignee_entity_ref`
column	Rename Column	`ocean_booking_container_counts_forty_five_ft_hc`	`ocean_booking_container_count_forty_five_ft_hc`
column	Rename Column	`ocean_booking_container_counts_forty_ft`	`ocean_booking_container_count_forty_ft`
column	Rename Column	`ocean_booking_container_counts_forty_ft_hc`	`ocean_booking_container_count_forty_ft_hc`
column	Rename Column	`ocean_booking_container_counts_object`	`ocean_booking_container_count_object`
column	Rename Column	`ocean_booking_container_counts_twenty_ft`	`ocean_booking_container_count_twenty_ft`
column	Deprecated Column	`shipper_entity_name`
column	Deprecated Column	`shipper_entity_object`
column	Deprecated Column	`shipper_entity_ref`
column	New Column		`air_booking_destination_port_address_city`
column	New Column		`air_booking_destination_port_address_country`
column	New Column		`air_booking_destination_port_address_country_code`
column	New Column		`air_booking_destination_port_address_object`
column	New Column		`air_booking_destination_port_address_ref`
column	New Column		`air_booking_destination_port_address_state`
column	New Column		`air_booking_destination_port_address_street`
column	New Column		`air_booking_destination_port_address_street_2`
column	New Column		`air_booking_destination_port_address_timezone`
column	New Column		`air_booking_destination_port_address_unlocode`
column	New Column		`air_booking_destination_port_address_zip`
column	New Column		`air_booking_destination_port_name`
column	New Column		`air_booking_destination_port_object`
column	New Column		`air_booking_origin_port_address_city`
column	New Column		`air_booking_origin_port_address_country`
column	New Column		`air_booking_origin_port_address_country_code`
column	New Column		`air_booking_origin_port_address_ref`
column	New Column		`air_booking_origin_port_address_state`
column	New Column		`air_booking_origin_port_address_street`
column	New Column		`air_booking_origin_port_address_street_2`
column	New Column		`air_booking_origin_port_address_timezone`
column	New Column		`air_booking_origin_port_address_unlocode`
column	New Column		`air_booking_origin_port_address_zip`
column	New Column		`destination_address_city`
column	New Column		`destination_address_country`
column	New Column		`destination_address_country_code`
column	New Column		`destination_address_ref`
column	New Column		`destination_address_state`
column	New Column		`destination_address_street`
column	New Column		`destination_address_street_2`
column	New Column		`destination_address_timezone`
column	New Column		`destination_address_unlocode`
column	New Column		`destination_address_zip`
column	New Column		`ocean_booking_destination_port_address_city`
column	New Column		`ocean_booking_destination_port_address_country`
column	New Column		`ocean_booking_destination_port_address_country_code`
column	New Column		`ocean_booking_destination_port_address_object`
column	New Column		`ocean_booking_destination_port_address_ref`
column	New Column		`ocean_booking_destination_port_address_state`
column	New Column		`ocean_booking_destination_port_address_street`
column	New Column		`ocean_booking_destination_port_address_street_2`
column	New Column		`ocean_booking_destination_port_address_timezone`
column	New Column		`ocean_booking_destination_port_address_unlocode`
column	New Column		`ocean_booking_destination_port_address_zip`
column	New Column		`ocean_booking_origin_port_address_city`
column	New Column		`ocean_booking_origin_port_address_country`
column	New Column		`ocean_booking_origin_port_address_country_code`
column	New Column		`ocean_booking_origin_port_address_ref`
column	New Column		`ocean_booking_origin_port_address_state`
column	New Column		`ocean_booking_origin_port_address_street`
column	New Column		`ocean_booking_origin_port_address_street_2`
column	New Column		`ocean_booking_origin_port_address_timezone`
column	New Column		`ocean_booking_origin_port_address_unlocode`
column	New Column		`ocean_booking_origin_port_address_zip`
column	New Column		`origin_address_city`
column	New Column		`origin_address_country`
column	New Column		`origin_address_country_code`
column	New Column		`origin_address_ref`
column	New Column		`origin_address_state`
column	New Column		`origin_address_street`
column	New Column		`origin_address_street_2`
column	New Column		`origin_address_timezone`
column	New Column		`origin_address_unlocode`
column	New Column		`origin_address_zip`
`BOOKING_AIR_BOOKING_DESTINATION_PORT_DETAIL`
table	New Table		`BOOKING_AIR_BOOKING_DESTINATION_PORT_DETAIL`
`BOOKING_AIR_BOOKING_ORIGIN_PORT_DETAIL`
table	New Table		`BOOKING_AIR_BOOKING_ORIGIN_PORT_DETAIL`
`BOOKING_AIR_PRODUCT_DESCRIPTION (new table name: BOOKING_AIR_BOOKING_PRODUCT_DESCRIPTION)`
table	Rename Table	`BOOKING_AIR_PRODUCT_DESCRIPTION`	`BOOKING_AIR_BOOKING_PRODUCT_DESCRIPTION`
`BOOKING_CARGO_LITHIUM_BATTERY_PACKING_TYPE`
table	New Table		`BOOKING_CARGO_LITHIUM_BATTERY_PACKING_TYPE`
`BOOKING_CARGO_SHIPPING_UNIT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`booking_id`	`booking_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`BOOKING_DESCRIPTION`
table	Deprecated Table	`BOOKING_DESCRIPTION`
`BOOKING_OCEAN_BOOKING_DESTINATION_PORT_DETAIL`
table	New Table		`BOOKING_OCEAN_BOOKING_DESTINATION_PORT_DETAIL`
`BOOKING_OCEAN_BOOKING_ORIGIN_PORT_DETAIL`
table	New Table		`BOOKING_OCEAN_BOOKING_ORIGIN_PORT_DETAIL`
`BOOKING_OCEAN_BOOKING_PRODUCT_DESCRIPTION`
table	New Table		`BOOKING_OCEAN_BOOKING_PRODUCT_DESCRIPTION`
`COMMERCIAL_INVOICE`
column	New Column		`updated_at`
`COMMERCIAL_INVOICE_INVOLVED_PARTY`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`commercial_invoice_id`	`commercial_invoice_id` 🔑	Added to primary key.
column	Rename Column	`mailing_city`	`address_city`
column	Rename Column	`mailing_country`	`address_country`
column	Rename Column	`mailing_country_code`	`address_country_code`
column	Rename Column	`mailing_object`	`address_object`
column	Rename Column	`mailing_ref`	`address_ref`
column	Rename Column	`mailing_state`	`address_state`
column	Rename Column	`mailing_street_address`	`address_street`
column	Rename Column	`mailing_street_address_2`	`address_street_2`
column	Rename Column	`mailing_timezone`	`address_timezone`
column	Rename Column	`mailing_unlocode`	`address_unlocode`
column	Rename Column	`mailing_zip`	`address_zip`
column	Primary Key Change		`index` 🔑	New primary key.
`COMMERCIAL_INVOICE_LINE_ITEM`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`commercial_invoice_id`	`commercial_invoice_id` 🔑	Added to primary key.
column	New Column		`country_of_origin`
column	Primary Key Change		`id` 🔑	New primary key.
`COMMERCIAL_INVOICE_MANUFACTURER_ADDRESS`
table	New Table		`COMMERCIAL_INVOICE_MANUFACTURER_ADDRESS`
`COMPANY_ENTITY`
column	New Column		`mailing_address_city`
column	New Column		`mailing_address_country`
column	New Column		`mailing_address_country_code`
column	New Column		`mailing_address_object`
column	New Column		`mailing_address_ref`
column	New Column		`mailing_address_state`
column	New Column		`mailing_address_street`
column	New Column		`mailing_address_street_2`
column	New Column		`mailing_address_timezone`
column	New Column		`mailing_address_unlocode`
column	New Column		`mailing_address_zip`
`COMPANY_ENTITY_VAT_NUMBER`
table	New Table		`COMPANY_ENTITY_VAT_NUMBER`
`CONTAINER`
column	New Column		`empty_container_pickup_date`
column	New Column		`empty_ready_date`
column	New Column		`reference_code`
`CONTAINER_ITEM`
column	Primary Key Change	`container_id`	`container_id` 🔑	Added to primary key.
`CONTAINER_LEG_DATE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`container_leg_id`	`container_leg_id` 🔑	Added to primary key.
column	New Column		`actual_discharge_date`
column	Primary Key Change		`index` 🔑	New primary key.
`DETAIL`
table	Deprecated Table	`DETAIL`
`HS`
table	Deprecated Table	`HS`
`INVOICE`
column	Deprecated Column	`issuer_name`
column	Deprecated Column	`issuer_ref`
column	Deprecated Column	`recipient_name`
column	Deprecated Column	`recipient_ref`
column	Deprecated Column	`shipment_id`
column	New Column		`exchange_rate`
column	New Column		`invoice_type`
column	New Column		`quote_currency_code`
column	New Column		`service_level`
column	New Column		`shipment_link`
`INVOICE_CREDIT_MEMO`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Deprecated Column	`category`
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Deprecated Column	`reason`
column	Deprecated Column	`reasons`
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_CREDIT_MEMO_CATEGORY`
table	New Table		`INVOICE_CREDIT_MEMO_CATEGORY`
`INVOICE_CREDIT_MEMO_REASON`
table	New Table		`INVOICE_CREDIT_MEMO_REASON`
`INVOICE_LINE_ITEM (new table name: )`
table	Rename Table	`INVOICE_ITEM`
`LOCATION`
column	Deprecated Column	`contacts_ref_type`
column	New Column		`address_city`
column	New Column		`address_country`
column	New Column		`address_country_code`
column	New Column		`address_object`
column	New Column		`address_ref`
column	New Column		`address_state`
column	New Column		`address_street`
column	New Column		`address_street_2`
column	New Column		`address_timezone`
column	New Column		`address_unlocode`
column	New Column		`address_zip`
`PORT`
column	New Column		`address_city`
column	New Column		`address_country`
column	New Column		`address_country_code`
column	New Column		`address_object`
column	New Column		`address_ref`
column	New Column		`address_state`
column	New Column		`address_street`
column	New Column		`address_street_2`
column	New Column		`address_timezone`
column	New Column		`address_unlocode`
column	New Column		`address_zip`
`PORT_DETAIL`
table	New Table		`PORT_DETAIL`
`PRODUCT_CLASSIFICATION`
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.
column	New Column		`object`
`PRODUCT_CLASSIFICATION_CODE`
column	Rename Column	`hs_code` 🔑	`code`	No longer primary key.
column	Deprecated Column	`product_classification_id` 🔑		No longer primary key.
column	Primary Key Change		`index` 🔑	New primary key.
column	Primary Key Change		`product_classification_index` 🔑	New primary key.
column	Primary Key Change		`product_id` 🔑	New primary key.
`PRODUCT_PROPERTY`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PRODUCT_SUPPLIER`
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.
`PURCHASE_ORDER`
column	Deprecated Column	`buyer_id`
column	Rename Column	`freight_paymnet_term`	`freight_payment_term`
column	Rename Column	`line_itemlink`	`line_item_link`
column	Rename Column	`line_itemobject`	`line_item_object`
column	Deprecated Column	`line_itemref_type`
column	Deprecated Column	`seller_id`
column	New Column		`destination_port_address_city`
column	New Column		`destination_port_address_country`
column	New Column		`destination_port_address_country_code`
column	New Column		`destination_port_address_object`
column	New Column		`destination_port_address_ref`
column	New Column		`destination_port_address_state`
column	New Column		`destination_port_address_street`
column	New Column		`destination_port_address_street_2`
column	New Column		`destination_port_address_timezone`
column	New Column		`destination_port_address_unlocode`
column	New Column		`destination_port_address_zip`
column	New Column		`origin_address_city`
column	New Column		`origin_address_country`
column	New Column		`origin_address_country_code`
column	New Column		`origin_address_object`
column	New Column		`origin_address_ref`
column	New Column		`origin_address_state`
column	New Column		`origin_address_street`
column	New Column		`origin_address_street_2`
column	New Column		`origin_address_timezone`
column	New Column		`origin_address_unlocode`
column	New Column		`origin_address_zip`
column	New Column		`origin_port_address_city`
column	New Column		`origin_port_address_country`
column	New Column		`origin_port_address_country_code`
column	New Column		`origin_port_address_object`
column	New Column		`origin_port_address_ref`
column	New Column		`origin_port_address_state`
column	New Column		`origin_port_address_street`
column	New Column		`origin_port_address_street_2`
column	New Column		`origin_port_address_timezone`
column	New Column		`origin_port_address_unlocode`
column	New Column		`origin_port_address_zip`
`PURCHASE_ORDER_DESTINATION_ADDRESS`
table	New Table		`PURCHASE_ORDER_DESTINATION_ADDRESS`
`PURCHASE_ORDER_DESTINATION_PORT_DETAIL`
table	New Table		`PURCHASE_ORDER_DESTINATION_PORT_DETAIL`
`PURCHASE_ORDER_LINE_ITEM`
column	Deprecated Column	`assigned_party_name`
column	Deprecated Column	`assigned_party_object`
column	Deprecated Column	`assigned_party_ref`
column	Deprecated Column	`country_code`
column	Deprecated Column	`hs_code`
column	Deprecated Column	`product_id`
column	Deprecated Column	`supplier`
column	New Column		`cargo_ready_date`
column	New Column		`destination_port_address_city`
column	New Column		`destination_port_address_country`
column	New Column		`destination_port_address_country_code`
column	New Column		`destination_port_address_object`
column	New Column		`destination_port_address_ref`
column	New Column		`destination_port_address_state`
column	New Column		`destination_port_address_street`
column	New Column		`destination_port_address_street_2`
column	New Column		`destination_port_address_timezone`
column	New Column		`destination_port_address_unlocode`
column	New Column		`destination_port_address_zip`
column	New Column		`destination_port_object`
column	New Column		`origin_address_city`
column	New Column		`origin_address_country`
column	New Column		`origin_address_country_code`
column	New Column		`origin_address_object`
column	New Column		`origin_address_ref`
column	New Column		`origin_address_state`
column	New Column		`origin_address_street`
column	New Column		`origin_address_street_2`
column	New Column		`origin_address_timezone`
column	New Column		`origin_address_unlocode`
column	New Column		`origin_address_zip`
column	New Column		`origin_location_city`
column	New Column		`origin_location_country`
column	New Column		`origin_location_country_code`
column	New Column		`origin_location_object`
column	New Column		`origin_location_ref`
column	New Column		`origin_location_state`
column	New Column		`origin_location_street`
column	New Column		`origin_location_street_2`
column	New Column		`origin_location_timezone`
column	New Column		`origin_location_unlocode`
column	New Column		`origin_location_zip`
column	New Column		`origin_port_address_city`
column	New Column		`origin_port_address_country`
column	New Column		`origin_port_address_country_code`
column	New Column		`origin_port_address_ref`
column	New Column		`origin_port_address_state`
column	New Column		`origin_port_address_street`
column	New Column		`origin_port_address_street_2`
column	New Column		`origin_port_address_timezone`
column	New Column		`origin_port_address_unlocode`
column	New Column		`origin_port_address_zip`
column	New Column		`origin_port_object`
column	New Column		`product_sku`
`PURCHASE_ORDER_LINE_ITEM_DESTINATION_ADDRESS`
table	New Table		`PURCHASE_ORDER_LINE_ITEM_DESTINATION_ADDRESS`
`PURCHASE_ORDER_LINE_ITEM_DESTINATION_PORT_DETAIL`
table	New Table		`PURCHASE_ORDER_LINE_ITEM_DESTINATION_PORT_DETAIL`
`PURCHASE_ORDER_LINE_ITEM_HS_CODE`
table	New Table		`PURCHASE_ORDER_LINE_ITEM_HS_CODE`
`PURCHASE_ORDER_LINE_ITEM_MEASUREMENT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`purchase_order_line_item_id`	`purchase_order_line_item_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PURCHASE_ORDER_LINE_ITEM_ORIGIN_PORT_DETAIL`
table	New Table		`PURCHASE_ORDER_LINE_ITEM_ORIGIN_PORT_DETAIL`
`PURCHASE_ORDER_LINE_ITEM_PRODUCT_CLASSIFICATION`
table	Deprecated Table	`PURCHASE_ORDER_LINE_ITEM_PRODUCT_CLASSIFICATION`
`PURCHASE_ORDER_LINE_ITEM_PRODUCT_PROPERTY`
table	Deprecated Table	`PURCHASE_ORDER_LINE_ITEM_PRODUCT_PROPERTY`
`PURCHASE_ORDER_ORIGIN_PORT_DETAIL`
table	New Table		`PURCHASE_ORDER_ORIGIN_PORT_DETAIL` 🔑
`PURCHASE_ORDER_PARTY`
column	Primary Key Change	`company_entity_id` 🔑	`company_entity_id`	No longer primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PURCHASE_ORDER_PARTY_CONTACT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Deprecated Column	`purchase_order_party_company_entity_id`
column	Deprecated Column	`purchase_order_party_purchase_order_id`
column	Primary Key Change		`index` 🔑	New primary key.
column	Primary Key Change		`purchase_order_id` 🔑	Added to primary key.
column	Primary Key Change		`purchase_order_party_index` 🔑	New primary key.
`SHIPMENT`
column	New Column		`accepted_quote_amount`
column	New Column		`accepted_quote_currency_code`
column	New Column		`dangerous_goods_is_dangerous`
column	New Column		`freight_cost`
column	New Column		`main_freight_services_level`
column	New Column		`on_time_delivery_date`
column	New Column		`quoted_delivery_date_from`
column	New Column		`quoted_delivery_date_to`
column	New Column		`quoted_transit_time_days_max`
column	New Column		`quoted_transit_time_days_min`
column	New Column		`wants_214_filing`
column	New Column		`wants_ftz_entry`
`SHIPMENT_BUYER`
column	Deprecated Column	`mailing_city`
column	Deprecated Column	`mailing_country`
column	Deprecated Column	`mailing_country_code`
column	Deprecated Column	`mailing_object`
column	Deprecated Column	`mailing_ref`
column	Deprecated Column	`mailing_state`
column	Deprecated Column	`mailing_street_address`
column	Deprecated Column	`mailing_street_address_2`
column	Deprecated Column	`mailing_timezone`
column	Deprecated Column	`mailing_unlocode`
column	Deprecated Column	`mailing_zip`
column	Deprecated Column	`name`
column	Deprecated Column	`object`
column	Deprecated Column	`ref`
column	Primary Key Change	`shipment_id`	`shipment_id` 🔑	Added to primary key.
`SHIPMENT_CONSIGNEE`
table	New Table		`SHIPMENT_CONSIGNEE`
`SHIPMENT_DANGERIOUS_GOODS_CLASSIFICATION (new table name: SHIPMENT_DANGEROUS_GOODS_CLASSIFICATION)`
table	Rename Table	`SHIPMENT_DANGERIOUS_GOODS_CLASSIFICATION`	`SHIPMENT_DANGEROUS_GOODS_CLASSIFICATION`
`SHIPMENT_ENTITY`
table	Deprecated Table	`SHIPMENT_ENTITY`
`SHIPMENT_IMPORTERS_RECORD`
column	Deprecated Column	`mailing_city`
column	Deprecated Column	`mailing_country`
column	Deprecated Column	`mailing_country_code`
column	Deprecated Column	`mailing_object`
column	Deprecated Column	`mailing_ref`
column	Deprecated Column	`mailing_state`
column	Deprecated Column	`mailing_street_address`
column	Deprecated Column	`mailing_street_address_2`
column	Deprecated Column	`mailing_timezone`
column	Deprecated Column	`mailing_unlocode`
column	Deprecated Column	`mailing_zip`
column	Deprecated Column	`name`
column	Deprecated Column	`object`
column	Deprecated Column	`ref`
column	Primary Key Change	`shipment_id`	`shipment_id` 🔑	Added to primary key.
`SHIPMENT_ITEM`
column	New Column		`additional_quantity`
column	New Column		`country_of_origin`
column	New Column		`package_quantity`
column	New Column		`reference`
column	New Column		`total_units_unit_of_measure`
`SHIPMENT_LEG`
column	Deprecated Column	`container_leg_link`
column	Deprecated Column	`container_leg_object`
column	Deprecated Column	`destination_object`
column	Deprecated Column	`destination_place_object`
column	Deprecated Column	`destination_terminal`
column	Rename Column	`ocean_leg_container_legs_link`	`ocean_leg_container_leg_link`
column	Deprecated Column	`ocean_leg_container_legs_object`
column	Deprecated Column	`origin_object`
column	Deprecated Column	`origin_place_object`
column	Deprecated Column	`origin_terminal_object`
column	Rename Column	`rail_leg_container_legs_link`	`rail_leg_container_leg_link`
column	Deprecated Column	`rail_leg_container_legs_object`
column	Deprecated Column	`rail_leg_object`
column	New Column		`air_leg_pieces`
column	New Column		`destination_place_address_city`
column	New Column		`destination_place_address_country`
column	New Column		`destination_place_address_country_code`
column	New Column		`destination_place_address_object`
column	New Column		`destination_place_address_ref`
column	New Column		`destination_place_address_state`
column	New Column		`destination_place_address_street`
column	New Column		`destination_place_address_street_2`
column	New Column		`destination_place_address_timezone`
column	New Column		`destination_place_address_unlocode`
column	New Column		`destination_place_address_zip`
column	New Column		`destination_terminal_address_city`
column	New Column		`destination_terminal_address_country`
column	New Column		`destination_terminal_address_country_code`
column	New Column		`destination_terminal_address_object`
column	New Column		`destination_terminal_address_ref`
column	New Column		`destination_terminal_address_state`
column	New Column		`destination_terminal_address_street`
column	New Column		`destination_terminal_address_street_2`
column	New Column		`destination_terminal_address_timezone`
column	New Column		`destination_terminal_address_unlocode`
column	New Column		`destination_terminal_address_zip`
column	New Column		`origin_place_address_city`
column	New Column		`origin_place_address_country`
column	New Column		`origin_place_address_country_code`
column	New Column		`origin_place_address_object`
column	New Column		`origin_place_address_ref`
column	New Column		`origin_place_address_state`
column	New Column		`origin_place_address_street`
column	New Column		`origin_place_address_street_2`
column	New Column		`origin_place_address_timezone`
column	New Column		`origin_place_address_unlocode`
column	New Column		`origin_place_address_zip`
column	New Column		`origin_terminal_address_city`
column	New Column		`origin_terminal_address_country`
column	New Column		`origin_terminal_address_country_code`
column	New Column		`origin_terminal_address_object`
column	New Column		`origin_terminal_address_ref`
column	New Column		`origin_terminal_address_state`
column	New Column		`origin_terminal_address_street`
column	New Column		`origin_terminal_address_street_2`
column	New Column		`origin_terminal_address_timezone`
column	New Column		`origin_terminal_address_unlocode`
column	New Column		`origin_terminal_address_zip`
column	New Column		`trucking_leg_container_leg_link`
`SHIPMENT_LEG_DESTINATION_PLACE_DETAIL`
table	New Table		`SHIPMENT_LEG_DESTINATION_PLACE_DETAIL`
`SHIPMENT_LEG_DESTINATION_TAG`
table	New Table		`SHIPMENT_LEG_DESTINATION_TAG`
`SHIPMENT_LEG_ORIGIN_PLACE_DETAIL`
table	New Table
`SHIPMENT_LEG_ORIGIN_TAG`
table	New Table
`SHIPMENT_SELLER`
table	New Table		`SHIPMENT_SELLER`
`SHIPMENT_SHIPPER`
table	New Table		`SHIPMENT_SHIPPER`
`TAGS`
table	Deprecated Table	`TAGS`
`VAT_NUMBER`
table	Deprecated Table	`VAT_NUMBER`

Freshchat

Effective October 28, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are necessary due to changes in the source API.

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 • 1 possible breaking changes

Table/column	Change type	New name
`CONVERSATION`
column	New Column	`user_id`
`CONVERSATION_USER`
table	Deprecated Table

Google Display & Video 360

We removed the FILTER_ANONYMOUS_INVENTORY_MODELING dimension and stopped supporting the following metrics for the YOUTUBE report as they have become incompatible with it in the Bid Manager API:

Metric	Label
`METRIC_TOTAL_MEDIA_COST_ADVERTISER`	`Total Media Cost (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPAPC_ADVERTISER`	`Total Media Cost eCPA (PC) (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPAPC_PARTNER`	`Total Media Cost eCPA (PC) (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPAPC_USD`	`Total Media Cost eCPA (PC) (USD)`
`METRIC_TOTAL_MEDIA_COST_ECPAPV_ADVERTISER`	`Total Media Cost eCPA (PV) (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPAPV_PARTNER`	`Total Media Cost eCPA (PV) (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPAPV_USD`	`Total Media Cost eCPA (PV) (USD)`
`METRIC_TOTAL_MEDIA_COST_ECPA_ADVERTISER`	`Total Media Cost eCPA (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPA_PARTNER`	`Total Media Cost eCPA (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPA_USD`	`Total Media Cost eCPA (USD)`
`METRIC_TOTAL_MEDIA_COST_ECPCV_ADVERTISER`	`Total Video Media Cost eCPCV (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPCV_PARTNER`	`Total Video Media Cost eCPCV (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPCV_USD`	`Total Video Media Cost eCPCV (USD)`
`METRIC_TOTAL_MEDIA_COST_ECPC_ADVERTISER`	`Total Media Cost eCPC (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPC_PARTNER`	`Total Media Cost eCPC (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPC_USD`	`Total Media Cost eCPC (USD)`
`METRIC_TOTAL_MEDIA_COST_ECPM_ADVERTISER`	`Total Media Cost eCPM (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPM_PARTNER`	`Total Media Cost eCPM (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_ECPM_USD`	`Total Media Cost eCPM (USD)`
`METRIC_TOTAL_MEDIA_COST_PARTNER`	`Total Media Cost (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_USD`	`Total Media Cost (USD)`
`METRIC_TOTAL_MEDIA_COST_VIEWABLE_ECPM_ADVERTISER`	`Total Media Cost Viewable eCPM (Advertiser Currency)`
`METRIC_TOTAL_MEDIA_COST_VIEWABLE_ECPM_PARTNER`	`Total Media Cost Viewable eCPM (Partner Currency)`
`METRIC_TOTAL_MEDIA_COST_VIEWABLE_ECPM_USD`	`Total Media Cost Viewable eCPM (USD)`

Greenhouse

We have renamed the USER table to USERS. For more information, see our Schema information

Height

We added a new BOOLEAN column, deleted, to the USER table. The deleted column indicates whether a user was deleted in Height.

We added a new STRING column, name, to the LIST table. The name column indicates the name of a list in Height.

These changes are available for all Height connectors.

HubSpot

We have added the following new same object association tables:

COMPANY_COMPANY
CONTACT_CONTACT
DEAL_DEAL
TICKET_TICKET

We have added a new column, category. This column is a part of the composite primary key for all the standard and custom association tables.

We have migrated the custom object association tables from V3 to V4 of HubSpot's Associations API. As part of this migration, we have done the following:

Added a new column, type_id, to the custom object association tables and removed the type column from them. The new column is a part of the composite primary key. It is also a foreign key to the ASSOCIATION_TYPE table.
Added the category column of the ASSOCIATION_TYPE table to its composite primary key.
Replaced the [CUSTOM_OBJECT]_TO_EMAIL table with a new table, [CUSTOM_OBJECT]_TO_ENGAGEMENT, to store all 7 types of engagement associations. In the new table, you can identify the type of engagement association by the engagement_type column.
Created a backup of the existing custom object association tables in your destination to avoid data loss. The backup table names are in the following format: [TABLE_NAME]\_BACKUP\_[DATE].
Synced the new custom object association tables, including their history, into your destination.

NOTE: The custom object association table migration is applicable only to connectors created before November 21, 2023 and it does not contribute towards your MAR.

Integral Ad Science

Effective October 21, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We're making these schema changes to ensure data integrity.

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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`REPORT`
column	Primary Key Change			`ad_server_placement_id` 🔑	Added to primary key.

Jira

We now sync the description column in the FIELD table. Description of the following fields are available:

system, custom for Jira Cloud instances
custom for Jira On-Premises instances

We are gradually rolling out this feature to all connections.

NOTE: To fetch field description data, Fivetran needs the Administer Jira global permission granted.

Jira Align

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made the following schema change to resolve a duplicate fields error.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`STRATEGY`
column	New Column			`theme_id`

Khoros Care

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to introduce a feature enhancement.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`CONVERSATION_ACTION_HISTORY_REPORT`
table	New Table

LaunchDarkly

Effective October 18, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are required to 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.

7 total changes • 7 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`FEATURE_FLAG`
column	Primary Key Change	`project_key`	`project_key` 🔑	Added to primary key.
`FEATURE_FLAG_ENIVORNMENT_PRODUCTION_TARGET`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.
`FEATURE_FLAG_ENIVORNMENT_TEST_TARGET`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.
`FEATURE_FLAG_EXPERIMENT`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.
`FEATURE_FLAG_EXPERIMENT_ENVIRONMENT`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.
`FEATURE_FLAG_TAG`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.
`FEATURE_FLAG_VARIATION`
column	Primary Key Change		`feature_flag_project_key` 🔑	New primary key.

LinkedIn Ad Analytics

We have added the responseId column to the LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS table.

We have changed the composite primary key of the LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS table. The new composite key is a combination of the leadFormResponseId, responseId, and index columns.

Notion

Effective October 29, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes for more efficient data management and retrieval.

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 • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`BLOCK_CHILDREN_DATABASE`
table	New Table		`BLOCK_CHILDREN_DATABASE`
`BLOCK_CHILDREN_PAGE`
table	New Table	`NULL`	`BLOCK_CHILDREN_PAGE`
`BLOCK_COMMENT`
table	New Table		`BLOCK_COMMENT`
`BLOCK_DATABASE`
table	New Table		`BLOCK_DATABASE`
`BLOCK_PAGE`
table	New Table		`BLOCK_PAGE`
`BLOCK_PARENT`
table	Deprecated Table	`BLOCK_PARENT`		Data now available in the `BLOCK_DATABASE`, `BLOCK_PAGE`, `BLOCK_PARENT_DATABASE`, `BLOCK_PARENT_PAGE`, `BLOCK_CHILDREN_DATABASE`, `BLOCK_CHILDREN_PAGE` tables.
`BLOCK_PARENT_DATABASE`
table	New Table		`BLOCK_PARENT_DATABASE`
`BLOCK_PARENT_PAGE`
table	New Table		`BLOCK_PARENT_PAGE`
`COMMENT`
table	Deprecated Table	`COMMENT`		Data now available in the `BLOCK_COMMENT`, `PAGE_COMMENT`.
`PAGE_COMMENT`
table	New Table		`PAGE_COMMENT`

Persona

Effective October 21, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made the following schema changes to improve schema 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.

5 total changes • 5 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CASE_ACCOUNT (new table name: CASE_ACCOUNT)`
table	Rename Table	`CASES_ACCOUNT_DATA`	`CASE_ACCOUNT`
column	Primary Key Change		`case_id` 🔑	New primary key.
`CASE_INQUIRY (new table name: CASE_INQUIRY)`
table	Rename Table	`CASES_INQUIRY_DATA`	`CASE_INQUIRY`
column	Primary Key Change		`case_id` 🔑	New primary key.
`TRANSACTION`
column	Rename Column	`tag`	`tags`

PowerReviews Enterprise

Effective October 28, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to improve schema 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
`SPECIFIC_MODERATION_OBSERVATION`
table	Deprecated Table	`SPECIFIC_MODERATION_OBSERVATION`		Data now available in the `specific_moderation_question_observation` and `specific_moderation_review_observation` tables.
`SPECIFIC_MODERATION_QUESTION_OBSERVATION`
table	New Table		`SPECIFIC_MODERATION_QUESTION_OBSERVATION`
`SPECIFIC_MODERATION_REVIEW_OBSERVATION`
table	New Table		`SPECIFIC_MODERATION_REVIEW_OBSERVATION`

Proofpoint Security Awareness

Effective October 30, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made the following schema changes to adhere to standard naming conventions.

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
`KNOWLEDGE_ASSESMENT (new table name: KNOWLEDGE_ASSESSMENT)`
table	Rename Table	`KNOWLEDGE_ASSESMENT`	`KNOWLEDGE_ASSESSMENT`
`PHISH_ALRAM (new table name: PHISH_ALARM)`
table	Rename Table	`PHISH_ALRAM`	`PHISH_ALARM`
`PHISHING_EXTENTEND (new table name: PHISHING_EXTENDED)`
table	Rename Table	`PHISHING_EXTENTEND`	`PHISHING_EXTENDED`
`TRAINING_ENROLLEMENT (new table name: TRAINING_ENROLLMENT)`
table	Rename Table	`TRAINING_ENROLLEMENT`	`TRAINING_ENROLLMENT`

Reply.io

Effective October 16, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made these schema changes to improve schema 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.

2 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name
`CONTACT`
column	Deprecated Column	`custom_field`
`CONTACT_CUSTOM_FIELD`
table	New Table		`CONTACT_CUSTOM_FIELD`

Revel Systems

Effective October 16, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to improve schema 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 • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`APPLIED_DISCOUNT`
table	Deprecated Table	`APPLIED_DISCOUNT`		Data now available in the `ORDER_ITEM_APPLIED_DISCOUNT` and `ORDER_APPLIED_DISCOUNT` tables.
`EMPLOYEE`
column	Rename Column	`end`	`ends`
`ORDER_APPLIED_DISCOUNT`
table	New Table		`ORDER_APPLIED_DISCOUNT`
`ORDER_APPLIED_SERVICE_FEE`
table	New Table		`ORDER_APPLIED_SERVICE_FEE`
`ORDER_APPLIED_TAX`
table	New Table		`ORDER_APPLIED_TAX`
`ORDER_ITEM_APPLIED_DISCOUNT`
table	New Table		`ORDER_ITEM_APPLIED_DISCOUNT`
`ORDER_ITEM_APPLIED_SERVICE_FEE`
table	Deprecated Table	`ORDER_ITEM_APPLIED_SERVICE_FEE`		Data now available in the `ORDER_APPLIED_SERVICE_FEE` and `ORDER_ITEM_SERVICE_FEE` tables.
`ORDER_ITEM_APPLIED_TAX`
table	Deprecated Table	`ORDER_ITEM_APPLIED_TAX`		Data now available in the `ORDER_APPLIED_TAX` and `ORDER_ITEM_TAX` tables.
`ORDER_ITEM_SERVICE_FEE`
table	New Table		`ORDER_ITEM_SERVICE_FEE`
`ORDER_ITEM_TAX`
table	New Table		`ORDER_ITEM_TAX`

Rocketlane

Effective October 21, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made these schema changes to efficiently manage and retrieve data.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`PROJECT_FIELD`
column	New Column	`label`
`TASK_FIELD`
column	New Column	`label`

RTB House

Effective October 28, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to improve schema 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.

5 total changes • 5 possible breaking changes

Table/column	Change type	Old name	Notes
`CONVERSION`
table	Deprecated Table	`CONVERSION`	Data now available in the `CONVERSION_ATTRIBUTED`, `CONVERSION_POST_VIEW`, `CONVERSION_ALL_POST_CLICK`, and `CONVERSION_ALL` tables.
`RTB_STAT`
table	Deprecated Table	`RTB_STAT`	Data now available in the `RTB_STAT_POST_VIEW`, `RTB_STAT_ALL_POST`, `RTB_STAT_ALL_CONVERSIONS`, `RTB_STAT_ATTRIBUTED` and `RTB_STAT_BRANDING` tables.
`RTB_SUMMARY_STAT`
table	Deprecated Table	`RTB_SUMMARY_STAT`	Data now available in the `RTB_SUMMARY_STAT_POST_VIEW`, `RTB_SUMMARY_STAT_ALL_POST` and `RTB_SUMMARY_STAT_BRANDING` tables.
`TOP_HOSTS_STAT`
table	Deprecated Table	`TOP_HOSTS_STAT`	Data now available in the `TOP_HOSTS_STAT_IMPS` and `TOP_HOSTS_STAT_CLICK` tables.
`TOP_IN_APPS_STAT`
table	Deprecated Table	`TOP_IN_APPS_STAT`	Data now available in the `TOP_IN_APPS_STAT_IMPS`, and `TOP_IN_APPS_STAT_CLICK` tables.

Sailthru

We have added the is_real_open column to the ES_CAMPAIGN_OPENS and ES_TRIGGERED_OPENS tables.

We have added the is_real_click column to the ES_CAMPAIGN_CLICKS and ES_TRIGGERED_CLICKS tables.

We have added the client_id column to the ES_FLOW table.

For more information, see Sailthru's Email Event Stream Data Sets documentation.

Salesforce

We now exclude the AccountUserTerritory2View table from the Schema page of your Fivetran dashboard. We do not support this table due to sync performance issues. Previously, you could select it from the Schema page, but the table was not being synced.

SAP Business ByDesign

We've changed the data type of the InvoiceTermsInvoicingBlockingReasonCode field in the SALES_ORDER table from INTEGER to STRING.

ServiceTitan

Effective October 24, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

These schema changes are required due to primary key issues and reserved keywords being used as column names.

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.

6 total changes • 6 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`APPOINTMENT`
column	Rename Column	`end`	`ends`
`CALL`
column	Primary Key Change	`lead_call_id`	`lead_call_id` 🔑	Added to primary key.
`INVENTORY_BILL_ITEM`
column	Rename Column	`order` 🔑	`orders` 🔑	Primary key has been renamed.
`INVOICE_ITEM`
column	Rename Column	`order`	`orders`
`PROJECT_STATUS`
column	Rename Column	`order`	`orders`
`PROJECT_SUB_STATUS`
column	Rename Column	`order`	`orders`

Stripe

We have changed the primary keys of the following tables:

For the INVOICE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the invoice_id, invoice_line_item_id, and tax_rate_id columns. Previously, the primary key was a combination of the invoice_id and tax_rate_id columns.
For the CREDIT_NOTE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the credit_note_id, credit_note_line_item_id, and tax_rate_id columns. Previously, the primary key was a combination of the credit_note_line_item_id, and tax_rate_id columns.
For the UPCOMING_INVOICE_LINE_ITEM_TAX_RATE table, the new composite is a combination of the subscription_id, tax_rate_id, and upcoming_invoice_line_item_id columns. Previously, the primary key was a combination of the subscription_id, and tax_rate_id columns.

Stripe has deprecated the tax_info_* column. As a result, we have removed it from the CUSTOMER table and replaced it with a new CUSTOMER_TAX table. For more information, see Stripe's documentation.

Swoogo

Effective October 8, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made these schema changes to introduce a feature enhancement.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name	Notes
`CONTACT`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.
`SESSION`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.

Effective October 8, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made these schema changes to introduce a feature enhancement.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name	Notes
`EVENT`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.
`REGISTRANT`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.

Talkwalker

Effective October 14, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made these schema changes to 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.

5 total changes • 5 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`COLLECTOR_DATA`
column	Primary Key Change	`indexed`	`indexed` 🔑	Added to primary key.
`COLLECTOR_DATA_COLLECTION`
column	Primary Key Change		`indexed` 🔑	New primary key.
`COLLECTOR_DATA_SOURCE_TYPE`
column	Primary Key Change		`indexed` 🔑	New primary key.
`COLLECTOR_DATA_TOKEN_CONTENT`
column	Primary Key Change		`indexed` 🔑	New primary key.
`COLLECTOR_DATA_TOKEN_TITLE`
column	Primary Key Change		`indexed` 🔑	New primary key.

TikTok Ads

We added a new table, IMAGE_HISTORY. Until November 22, 2024, all usage for this table will count towards free MAR.

For more information, see the TikTok API documentation.

Transcend

Effective October 30, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made these schema changes because of the Transcend API changes.

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	Notes
`ASSESSMENT`
table	Deprecated Table	`ASSESSMENT`	Transcend no longer supports the table.
`ASSESSMENT_TEMPLATE`
table	Deprecated Table	`ASSESSMENT_TEMPLATE`	Transcend no longer supports the table.

Upland Software

Effective October 30, 2024 we use a new October 2024 . Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We've made the following schema changes to resolve a schema usability issue.

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 • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`PROFILE_CLICK`
table	Deprecated Table	`PROFILE_CLICK`		Data now available in the `WEB_CLICK` table.
`WEB_CLICK`
table	New Table		`WEB_CLICK`

Workday HCM

We have renamed the existing JOB_REQUISITION table to JOB_REQUISITION_BACKUP_2024_10_28. We will stop syncing data to the JOB_REQUISITION_BACKUP_2024_10_28 table after October 28, 2024.

We have renamed the JOB_REQUISITION_INCOMING table to JOB_REQUISITION. Be sure to update your queries.

Zoho CRM

We have changed the data type of the quantity field in the QUOTE_PRODUCT table to DOUBLE.

Improvements

Alchemer

The Alchemer connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Amazon DynamoDB

The DynamoDB connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

AuthO

We have updated our sync strategy and have implemented key-based pagination for the ORGANIZATION table.

Azure Cosmos DB for NoSQL

The Azure Cosmos DB for NoSQL connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Azure Data Lake Storage

We now support automatic schema migration of Delta Lake tables in Databricks. For more information about configuring automatic schema migration, see our setup instructions.

You can no longer modify the following fields in the Azure Data Lake Storage setup form after you create the destination:

Storage Account Name
Container Name
Prefix Path

Azure Synapse

Azure Synapse destinations now support the Hybrid Deployment model. We are gradually rolling out this feature to all existing destinations. For more information, see our setup guide.

Braze

We have added a new field, Historical Sync Time Frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connector, you can edit the connection details and set the time frame value. We have also added support for the historic_sync_time_frame field for connectors created using the Create a Connector endpoint. For more information, see our REST API config.

Historical sync limits apply to the following tables:

ATTRIBUTION_EVENT
CAMPAIGN_CONTROL_ENROLLMENT_EVENT
CAMPAIGN_CONVERSION_EVENT
CANVAS_CONVERSION_EVENT
CANVAS_ENTRY_EVENT
CANVAS_EXIT_EVENT
CANVAS_EXPERIMENT_STEP_CONVERSION_EVENT
CANVAS_EXPERIMENT_STEP_ENTRY_EVENT
CONTENT_CARD_EVENT
CUSTOM_EVENT
EMAIL_EVENT
IN_APP_MESSAGE_EVENT
LOCATION_EVENT
NEWSFEED_CARD_EVENT
NEWSFEED_IMPRESSION_EVENT
PURCHASE_EVENT
PUSH_NOTIFICATION_EVENT
RANDOM_BUCKET_NUMBER_EVENT
SESSION_EVENT
SMS_EVENT
SUBSCRIPTION_EVENT
UNINSTALL_EVENT
WEBHOOK_EVENT
WHATSAPP_EVENT

Buildium

We have changed the sync strategy of the LEASE table. We now re-import the table in every sync to capture updates and deletes. Previously, we incrementally synced this table.

Confluence

We have changed the sync strategy of the PAGE_VERSION table and its child tables. We now re-import the tables in every sync to capture updates and deletes. Previously, we incrementally synced these tables.

Connector List Filter Update

We added a new design for Connector List Filter on Connector Page.

Connector List

Coupa

We now capture deletes for the parent tables. We use the _fivetran_deleted column to capture the deletes for these tables. To avoid longer sync times, we perform weekly incremental syncs on Saturdays to capture deletes.

Databricks

Our Databricks connector is now available in BETA.

Read our Databricks connector documentation.

Eloqua

You can now limit the amount of historical data you want to sync for the CONTACT_ACTIVITY and custom object tables. We have added a new optional drop-down menu, Historical Sync Limit, to the connector setup form. We have also added a new config parameter, historical_sync_limit, to the REST API config. For more information, see our documentation.

Fivetran Platform Connector

The group-level Fivetran Platform Connector is now automatically paused when it is the only active connector in the group. This means that if there are other connectors in the group, but all of them are paused, we pause the group-level Fivetran Platform Connector.

We unpause the automatically-paused group-level Fivetran Platform Connector once there is at least one active connector present in the group.

Gladly

We now incrementally sync the CUSTOMER and CONVERSATION tables.

Gong

The Gong connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Google Ads

We now support the CAMPAIGN_SEARCH_TERM_INSIGHT resource as a custom report.

NOTE: The Google Ads API limits the sync speed of the CAMPAIGN_SEARCH_TERM_INSIGHT report.

Greenhouse

We now sync the following webhook events through the incrementally sync. Previously, we synced them through our webhooks.

Webhook	Updated parent table
CANDIDATE HIRED	`APPLICATION_HISTORY`
JOB CREATED	`JOB_HISTORY`
JOB UPDATED	`JOB_HISTORY`
OFFER CREATED	`OFFER_HISTORY`
OFFER UPDATED	`OFFER_HISTORY`

The data previously fetched from these events will now be synced through our incrementally sync.

NOTE: This change applies only to the integrations created after 2024-07-24.

Harvest

We now re-import the TIME_ENTRY table once a week to capture deletes.

High-Volume Agent Db2 for i

Our High-Volume Agent Db2 for i connector is now generally available. See our High-Volume Agent Db2 for i connector documentation.

Intercom

When a re-sync is triggered, we now set the _fivetran_active column to false for the following tables:

CONTACT_HISTORY
CONVERSATION_HISTORY
CONTACT
CONTACT_COMPANY
CONTACT_SEGMENT
CONTACT_SUBSCRIPTION
CONTACT_TAG
CONTACT_SOCIAL_PROFILE
CONVERSATION
CONVERSATION_ADMIN
CONVERSATION_CONTACT
CONVERSATION_PART
CONVERSATION_PART_ATTACHMENT
CONVERSATION_TAG
CONVERSATION_TOPIC_HISTORY

We set the _fivetran_active column to false before re-syncing the rows in the listed tables.

Jira

You can now exclude the following tables from your syncs:

USER
USER_GROUP
PROJECT_ROLE
PROJECT_ROLE_ACTOR

On your connector details page, go to the Schema tab and deselect the tables you want to exclude.

Khoros Care

We now capture deletes for the CONVERSATION_ACTION_HISTORY_REPORT table.

launchdarkly

We have implemented offset-based pagination for the SEGMENT endpoint.

Looker

We have fixed a bug where we received read timeout errors while trying to fetch data from the dashboard endpoint. We have updated our sync strategy and now fetch data using the search endpoint.

Marketo

The Marketo connector now supports the Hybrid Deployment model. For more information, see our setup instructions

Mixpanel

The Mixpanel connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Ometria

The Ometria connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Ometria's priority-first syncs fetch the most recent seven days' worth of data from the ORDERS, PROFILE, and UNSUBSCRIBED_CONTACTtables.

To learn more, see our priority-first sync documentation.

OneLake

You can no longer modify the following fields in the OneLake setup form after you create the destination:

Workspace Name
Lakehouse Name

Oracle Fusion Cloud Applications

You can now assign a role with lesser privileges, BIA_ADMINISTRATOR_DUTY, instead of ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT to the Oracle user that the connector uses to access your data.

PagerDuty

We now re-import the INCIDENT table and its child tables once a week. See our PagerDuty connector sync overview documentation for further details.

Pinterest Ads

We've added support for hourly report granulation for our Pinterest Ads connector. You can now choose whether to sync reports with daily or hourly granularity on the connector setup form. This change only applies to new Pinterest Ads connectors created after October 11, 2024.

Previously, all reports were synced with daily granularity. For more information, see our Pinterest Ads setup guide.

Resource Management by Smartsheet

We now re-import the PROJECT and its child tables once a week to capture updates and deletes.

S3 Data Lake

We now support automatic schema migration of Delta Lake tables in Databricks. For more information about configuring automatic schema migration, see our setup instructions.

You can no longer modify the following fields in the S3 Data Lake setup form after you create the destination:

Bucket
S3 Prefix Path

Sailthru

We have added a new field, Historical Sync Time Frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. The default value selected is ALL_TIME. For an existing connector, you can edit the connection details and set the time frame value. We have also added support for the historic_sync_time_frame field for connectors created using the Create a Connector endpoint. For more information, see our Sailthru documentation and REST API config.

The historical sync limit only applies to the following tables:

CAMPAIGN_QUERY
PURCHASE
PURCHASE_ITEM

Salesforce

We no longer use the deleted endpoint for the ORGANIZATION table. This is to avoid the issue where the endpoint returns the ID of active organizations, incorrectly marking them as deleted.

If this issue has impacted your data, you can either resync the table or wait for the next incremental sync to correct the records automatically.

We have upgraded our Salesforce connector from version 61.0 to 62.0 of the Salesforce REST API. For more information, see Salesforce's changelog.

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

We now support the translation of the following standard roll-up summary fields:

OBJECT	Standard Rollup Summary Fields
`DUPLICATE_RECORD_SET`	`RecordCount`
`IDEA`	`NumComments`, `LastCommentDate`
`PROFILE_SKILL`	`UserCount`
`PROFILE_SKILL_USER`	`EndorsementCount`
`QUOTE`	`Subtotal`, `LineItemCount`, `TotalPrice`
`WORK_ORDER`	`Subtotal`, `LineItemCount`, `TotalPrice`

Contact our support team to request support for any Standard Rollup Summary Field in your organization. We can verify whether we can generate the definition, as Salesforce does not provide an API to fetch metadata for standard roll-up summary fields.

We now translate formulas containing the CURRENCYRATE function.

We now translate formulas containing the LEFT and RIGHT functions. This is applicable only for the following destinations:

BigQuery
Databricks
PostgreSQL
Redshift
Snowflake

Salesforce Commerce Cloud

We now use a combination of the numeric IDs and the fivetran_ prefix as the primary key for the ORDER_SHIPMENT records if their shipmentNo value is null. For example, fivetran_1.

If you fix these orders in your Salesforce Commerce Cloud account, Fivetran automatically updates the correct shipmentNo values in the destination.

Samsara

We have fixed a bug where we didn't sync the new and updated records of the coaching_state column of the SAFETY_EVENT table. We have updated our sync strategy and modified the replay window for the SAFETY_EVENT table from 12 hours to 10 days.

SAP Concur

We now support table re-syncs for the SAP Concur connectors. You can now select or deselect the child tables to sync from the Schema tab on your connector details page. We are gradually rolling out this improvement to all existing connectors.

SAP ERP on HANA

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

We fixed issue in the creation of the deletion trigger when the table contains an .INCLUDE structure as the primary key.

For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.

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

We fixed an issue where the shadow table was not updated when changes were made to the structure of the primary key in your SAP tables. Additionally, we fixed an issue when searching for tables that exist only in the application layer but not in the database.

For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.

The SAP ERP on HANA connector now supports the Hybrid Deployment model. For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.

ServiceNow

The ServiceNow connector now supports the Hybrid Deployment model. For more information, see our setup instructions

SFTP

We have added a new configuration option, Run connection test to the setup form to perform an intermediate test during configuration. We perform this test to validate the login credentials and the connection to the SFTP server. For more information, see our setup instructions.

The SFTP connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Splunk Log Appender

We've improved event structure for better indexing. We now specify the source type as JSON for the events we send. This way, Splunk can properly format the data, which now contains time information for better message ordering.

StarRez

We now sync historical data from 2015 (2015-01-01T00:00:00Z) for all tables.

Previously, we synced historical data from 2021 (2021-01-01T00:00:00Z).

Workday Financial Management

We now support table re-syncs for the Workday Financial Management connectors. You can now select or deselect the tables to sync from the Schema tab of your connector details page. We are gradually rolling out this improvement to all existing connectors.

Workday HCM

The Workday HCM connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Workday RaaS

The Workday RaaS connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Zuora

The Zuora connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

REST API Improvements

Adyen

You can now configure your Adyen connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

Amazon S3

You can now configure the primary key used for file process and load using the Fivetran REST API.

October 2024

Coalesce Orchestration

Connector SDK

fivetran-connector-sdk PyPI package

Lite Connectors

Hybrid Deployment support

Proxy Agent

Transformations for dbt Core

Multi-Connector Quickstart transformations

Updated dbt Quickstart package

Schema changes

Aha!

Chargebee Product Catalog 2.0

Collibra

commercetools

Crossbeam

Cvent

dbt Cloud

Dropbox Sign

Facebook Ads

Facebook Pages

Fivetran Platform Connector

Flexport

Freshchat

Google Display & Video 360

Greenhouse

Height

HubSpot

Integral Ad Science

Jira

Jira Align

Khoros Care

LaunchDarkly

LinkedIn Ad Analytics

Notion

Persona

PowerReviews Enterprise

Proofpoint Security Awareness

Reply.io

Revel Systems

Rocketlane

RTB House

Sailthru

Salesforce

SAP Business ByDesign

ServiceTitan

Stripe

Swoogo

Talkwalker

TikTok Ads

Transcend

Upland Software

Workday HCM

Zoho CRM

Improvements

Alchemer

Amazon DynamoDB

AuthO

Azure Cosmos DB for NoSQL

Azure Data Lake Storage

Azure Synapse

Braze

Buildium

Confluence

Connector List Filter Update

Coupa

Databricks

Eloqua

Fivetran Platform Connector

Gladly

Gong

Google Ads

Greenhouse

Harvest

High-Volume Agent Db2 for i

Intercom

Jira

Khoros Care

launchdarkly

Looker

`fivetran-connector-sdk` PyPI package