October 2024

Lite Connectors

Lite connectors are now available for the following sources:

Hybrid Deployment support

The following Lite connectors now support the Hybrid Deployment model:

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

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.

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`

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

We've converted the BASIC_AD_ACTION_VALUES prebuilt report into a child table of the BASIC_AD table. This resolved a critical schema usability issue.

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

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.

414 total changes • 137 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	Rename Column	`address_city`
column	Primary Key Change	`commercial_invoice_id`	`commercial_invoice_id` 🔑	Added to primary key.
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	Primary Key Change	`sku`	`sku` 🔑	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`

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)`

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.

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.

Proofpoint Security Awareness

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 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`

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.

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 in the CUSTOMER table and replaced it with the 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.

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.

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

Databricks

Our Databricks connector is now available in BETA.

Read our Databricks connector 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.

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.

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.

Marketo

The Marketo 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.

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.

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.

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.

SAP ERP on HANA

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.

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.

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.