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:

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`

Facebook Ads

We've removed the BASIC_AD_ACTION_VALUES prebuilt report to resolve a 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 following dimensions and metrics as they have been sunset in the Bid Manager API:

Metric / Dimension	Label
`FILTER_ANONYMOUS_INVENTORY_MODELING`	`Anonymous Inventory Modeling`
`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.

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

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 15, 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.

SCORM

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

4 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`REGISTRATION_ACTIVITY_COMMENT`
table	Deprecated Table	`REGISTRATION_ACTIVITY_COMMENT`		Data for the deprecated table is now available in the `REGISTRATION_ACTIVITY_LEARNER_COMMENT` and `REGISTRATION_ACTIVITY_LMS_COMMENT` tables.
`REGISTRATION_ACTIVITY_RUNTIME_INTERACTION`
column	Rename Column	`timestamp`	`timestamps`
`REGISTRATION_OBJECTIVE`
table	Deprecated Table	`REGISTRATION_OBJECTIVE`		Data for the deprecated table is now available in the `REGISTRATION_GLOBAL_OBJECTIVE` and `REGISTRATION_ACTIVITY_OBJECTIVE` tables.
`REGISTRATION_STATEMENT`
column	Rename Column	`timestamp`	`timestamps`

SmartRecruiters

Effective October 7, 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.

7 total changes • 0 possible breaking changes

Table/column	Change type	New name
`APPROVAL`
table	New Table	`APPROVAL`
`APPROVAL_STEP`
table	New Table	`APPROVAL_STEP`
`APPROVAL_STEP_APPROVER`
table	New Table	`APPROVAL_STEP_APPROVER`
`CANDIDATE_SCREENING_ANSWER`
table	New Table	`CANDIDATE_SCREENING_ANSWER`
`CANDIDATE_SCREENING_ANSWER_RECORD`
table	New Table	`CANDIDATE_SCREENING_ANSWER_RECORD`
`CANDIDATE_SCREENING_ANSWER_RECORD_VALUE`
table	New Table	`CANDIDATE_SCREENING_ANSWER_RECORD_VALUE`
`JOB_APPLICATION`
table	New Table	`JOB_APPLICATION`

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
`EVENT`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.
`REGISTRANT`
column	New Column	`custom_*`	Custom fields have the `custom_` prefix.

Transcend

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 have made these schema changes since Transcend has deprecated these columns.

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
`SOMBRA`
column	Deprecated Column		`changelog`

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

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.

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.

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.

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.

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.

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.