December 2024

Fivetran Azure US Servers

We have added new servers in the Azure US West 3 (Phoenix) region.

If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in the US, your data does not leave the US during processing.

For more information, see our data residency documentation.

Lite Connectors

Lite connectors are now available for the following sources:

Transformations for dbt Core

Updated dbt Quickstart packages

We have updated the Quickstart packages for the following connectors:

Fivetran Log to version 1.9.1
Greenhouse to version 0.8.0
Quickbooks to version 0.17.0
Shopify to version 0.14.0
Stripe to version 0.15.1
Twilio to version 0.4.0
Zendesk Support to version 0.19.0

Schema changes

Apple App Store

We have added the date column to the SALES_SUBSCRIPTION_SUMMARY table.

For all existing connectors, we will perform a free historical re-sync of the SALES_SUBSCRIPTION_SUMMARY table to populate it with data. See the Apple App Store connector's latest ERD for more details.

Brevo

Effective December 9, 2024 we use a new December 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 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.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name
`EMAIL_CAMPAIGN`
column	Rename Column	`tag`	`tags`
`EMAIL_TEMPLATE`
column	Rename Column	`tag`	`tags`

Chameleon

Effective December 9, 2024 we use a new December 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 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.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name
`EXPERIENCE_DELIVERY`
column	Rename Column	`from`	`from_date`
`USER_PROFILE`
column	Rename Column	`percent`	`percents`

Chargebee Product Catalog 1.0

Effective December 21, 2024 we use a new December 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 feature enhancements and 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.

125 total changes • 64 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADDON`
column	Rename Column	`accounting_category1`	`accounting_category_1`
column	Rename Column	`accounting_category2`	`accounting_category_2`
column	Rename Column	`accounting_category3`	`accounting_category_3`
column	Rename Column	`accounting_category4`	`accounting_category_4`
column	New Column		`proration_type`
`ADDON_TAX_PROVIDER_FIELD`
table	New Table		`ADDON_TAX_PROVIDER_FIELD`
`ADDON_TIER`
table	New Table		`ADDON_TIER`
`CREDIT_NOTE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM`
table	New Table
`CREDIT_NOTE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM_TAX`
table	New Table
`CREDIT_NOTE_LINE_ITEM_TIER`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_BALANCE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_TAX_PROVIDER_FIELD`
table	New Table		`CUSTOMER_TAX_PROVIDER_FIELD`
`EVENT`
table	New Table		`EVENT`
`EVENT_METADATA`
table	New Table		`EVENT_METADATA`
`EVENT_WEBHOOK`
table	New Table		`EVENT_WEBHOOK`
`GIFT_TIMELINE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`gift_id`	`gift_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`HOSTED_PAGE`
column	New Column		`business_entity_id`
`INVOICE`
column	New Column		`einvoice_reference_number`
column	New Column		`local_currency_exchange_rate`
column	New Column		`site_details_at_creation_organization_address_city`
column	New Column		`site_details_at_creation_organization_address_country_code`
column	New Column		`site_details_at_creation_organization_address_line_1`
column	New Column		`site_details_at_creation_organization_address_state`
column	New Column		`site_details_at_creation_organization_address_zip`
column	New Column		`site_details_at_creation_organization_email`
column	New Column		`site_details_at_creation_organization_name`
column	New Column		`site_details_at_creation_organization_phone`
column	New Column		`site_details_at_creation_organization_website`
column	New Column		`site_details_at_creation_timezone`
column	New Column		`statement_descriptor`
column	New Column		`statement_descriptor_id`
column	New Column		`tax_category`
column	New Column		`tax_origin_country`
column	New Column		`tax_origin_registration_number`
`INVOICE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_DUNNING_ATTEMPT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM`
table	New Table
`INVOICE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM_TAX`
table	New Table
`INVOICE_NOTE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`LINE_ITEM`
table	Deprecated Table	`LINE_ITEM`		Data now available in the `INVOICE_LINE_ITEM`, `QUOTE_LINE_ITEM`, and `CREDIT_NOTE_LINE_ITEM` tables.
`LINE_ITEM_TAX`
table	Deprecated Table	`LINE_ITEM_TAX`		Data now available in the `INVOICE_LINE_ITEM_TAX`, `CREDIT_NOTE_LINE_ITEM_TAX`, `QUOTE_LINE_ITEM_TAX`, and `ORDER_LINE_ITEM_TAX` tables.
`ORDER_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`order_id`	`order_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`ORDER_LINE_ITEM_TAX`
table	New Table	`_FIVETRAN_ID` 🔑		No longer primary key.
`PAYMENT_SOURCE`
column	New Column		`bank_account_direct_debit_scheme`
column	New Column		`boleto_email`
column	New Column		`boleto_first_name`
column	New Column		`boleto_last_4`
column	New Column		`boleto_last_name`
column	New Column		`klarna_pay_now_email`
column	New Column		`venmo_user_name`
`PLAN`
column	Rename Column	`accounting_category1`	`accounting_category_1`
column	Rename Column	`accounting_category2`	`accounting_category_2`
column	Rename Column	`accounting_category3`	`accounting_category_3`
column	Rename Column	`accounting_category4`	`accounting_category_4`
`PLAN_TAX_PROVIDER_FIELD`
table	New Table		`PLAN_TAX_PROVIDER_FIELD`
`PLAN_TIER`
table	New Table		`PLAN_TIER`
`QUOTE_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM`
table	New Table
`QUOTE_LINE_ITEM_DISCOUNT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM_TAX`
table	New Table
`QUOTE_LINE_ITEM_TIER`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_TAX`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`SUBSCRIPTION`
column	New Column		`contract_term_total_contract_value_before_tax`
`TIER`
table	Deprecated Table	`TIER`		Data now available in the `UNBILLED_CHARGE_TIER`, `ADDON_TIER`, and `PLAN_TIER` tables.
`TRANSACTION`
column	New Column		`custom_payment_method_id`
column	New Column		`custom_payment_method_name`
column	New Column		`error_cause_customer_message`
column	New Column		`error_cause_id`
column	New Column		`error_cause_merchant_message`
column	New Column		`error_detail_decline_code`
column	New Column		`error_detail_decline_message`
column	New Column		`error_detail_error_category`
column	New Column		`error_detail_error_code`
column	New Column		`error_detail_error_field`
column	New Column		`error_detail_error_message`
column	New Column		`error_detail_network_error_code`
column	New Column		`error_detail_network_error_message`
column	New Column		`error_detail_processor_error_code`
column	New Column		`error_detail_processor_error_message`
column	New Column		`error_detail_recommendation_code`
column	New Column		`error_detail_recommendation_message`
column	New Column		`error_detail_request_id`
`UNBILLED_CHARGE_TIER`
table	New Table		`UNBILLED_CHARGE_TIER`

Chargebee Product Catalog 2.0

Effective December 5, 2024 we use a new December 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 feature enhancements.

33 total changes • 0 possible breaking changes

Table/column	Change type	New name
`CREDIT_NOTE_LINE_ITEM`
column	New Column	`reference_line_item_id`
`INVOICE_DUNNING_ATTEMPT`
column	New Column	`transaction_amount`
column	New Column	`transaction_status`
`INVOICE_LINKED_PAYMENT`
column	New Column	`transaction_amount`
column	New Column	`transaction_date`
column	New Column	`transaction_status`
`QUOTE`
table	New Table	`QUOTE`
`QUOTE_DISCOUNT`
table	New Table	`QUOTE_DISCOUNT`
`QUOTE_LINE_ITEM`
table	New Table	`QUOTE_LINE_ITEM`
`QUOTE_LINE_ITEM_DISCOUNT`
table	New Table	`QUOTE_LINE_ITEM_DISCOUNT`
`QUOTE_LINE_ITEM_ITER`
table	New Table	`QUOTE_LINE_ITEM_ITER`
`QUOTE_LINE_ITEM_TAX`
table	New Table	`QUOTE_LINE_ITEM_TAX`
`QUOTE_NOTE`
table	New Table	`QUOTE_NOTE`
`QUOTE_SUBSCRIPTION`
table	New Table	`QUOTE_SUBSCRIPTION`
`QUOTE_SUBSCRIPTION_ADDON`
table	New Table	`QUOTE_SUBSCRIPTION_ADDON`
`QUOTE_SUBSCRIPTION_COUPON`
table	New Table	`QUOTE_SUBSCRIPTION_COUPON`
`QUOTE_SUBSCRIPTION_DISCOUNT`
table	New Table	`QUOTE_SUBSCRIPTION_DISCOUNT`
`QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON`
table	New Table	`QUOTE_SUBSCRIPTION_EVENT_BASED_ADDON`
`QUOTE_SUBSCRIPTION_ITEM`
table	New Table	`QUOTE_SUBSCRIPTION_ITEM`
`QUOTE_SUBSCRIPTION_ITEM_ITER`
table	New Table	`QUOTE_SUBSCRIPTION_ITEM_ITER`
`QUOTE_TAX`
table	New Table	`QUOTE_TAX`
`SUBSCRIPTION`
column	New Column	`active_id`
column	New Column	`changes_scheduled_at`
column	New Column	`contract_term_total_contract_value_before_tax`
column	New Column	`shipping_address_index`
`SUBSCRIPTION_DISCOUNT`
table	New Table	`SUBSCRIPTION_DISCOUNT`
`SUBSCRIPTION_ITEM_PRICE`
column	New Column	`billing_period`
column	New Column	`billing_period_unit`
column	New Column	`charge_once`
column	New Column	`free_quantity_in_decimal`
column	New Column	`proration_type`
column	New Column	`trial_end`
column	New Column	`usage_accumulation_reset_frequency`

Collibra

Effective December 19, 2024 we use a new December 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.

10 total changes • 9 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ASSIGNMENT_ASSET`
table	Deprecated Table	`ASSIGNMENT_ASSET`		Data available in the `ASSIGNMENT_ASSET_TYPE` table.
`ASSIGNMENT_ASSET_ARTICULATION_RULE`
table	Deprecated Table	`ASSIGNMENT_ASSET_ARTICULATION_RULE`		Data available in the `ASSIGNMENT_ASSET_TYPE_ARTICULATION_RULE` table.
`ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE`
table	Deprecated Table	`ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE`		Data available in the `ASSIGNMENT_ASSET_TYPE_CHARACTERISTIC_TYPE` table.
`ASSIGNMENT_ASSET_DATA_QUALITY_RULE`
table	Deprecated Table	`ASSIGNMENT_ASSET_DATA_QUALITY_RULE`		Data available in the `ASSIGNMENT_ASSET_TYPE_DATA_QUALITY_RULE` table.
`ASSIGNMENT_ASSET_DOMAIN_TYPE`
table	Deprecated Table	`ASSIGNMENT_ASSET_DOMAIN_TYPE`		Data available in the `ASSIGNMENT_ASSET_TYPE_DOMAIN_TYPE` table.
`ASSIGNMENT_ASSET_STATUS`
table	Deprecated Table	`ASSIGNMENT_ASSET_STATUS`		Data available in the `ASSIGNMENT_ASSET_TYPE_STATUS` table.
`ASSIGNMENT_ASSET_TYPE`
column	New Column		`scope_id`	Column added to establish a relationship with the `SCOPE_COMMUNITY` and `SCOPE_DOMAIN` tables.
`ASSIGNMENT_ASSET_VALIDATION_RULE`
table	Deprecated Table	`ASSIGNMENT_ASSET_VALIDATION_RULE`		Data available in the `ASSIGNMENT_ASSET_TYPE_VALIDATION_RULE` table.
`ASSIGNMENT_SCOPE_COMMUNITY`
table	Deprecated Table	`ASSIGNMENT_SCOPE_COMMUNITY`		Data available in the `SCOPE_COMMUNITY` table.
`ASSIGNMENT_SCOPE_DOMAIN`
table	Deprecated Table	`ASSIGNMENT_SCOPE_DOMAIN`		Data available in the `SCOPE_DOMAIN` table.

dbt Cloud

Effective December 11, 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 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.

2 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name
`RUN`
column	Rename Column	`artifact_s3_path`	`artifact_s_3_path`
`RUN_ARTIFACT`
table	New Table		`RUN_ARTIFACT`

Facebook Pages

We have added two new metadata tables, PAGE_VIDEO_HISTORY and PAGE_VIDEO_THUMBNAILS.

For more information see Facebook's API docs.

Fivetran Platform Connector

We've added the TRANSFORMATION_RUNS table to sync Transformations usage data.

Freshchat

Effective December 9, 2024 we use a new December 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.

11 total changes • 6 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CHANNEL`
column	New Column		`bots_private_note`
column	New Column		`message_type`
column	New Column		`restrict_response`
`CHANNEL_TAG`
column	Rename Column	`tag`	`tags`	The previous name is a reserved word
`CHANNEL_WELCOME_MESSAGE`
column	Deprecated Column		`bots_private_note`	Column moved to the CHANNEL table
column	Deprecated Column		`message_type`	Column moved to the CHANNEL table
column	Deprecated Column		`restrict_response`	Column moved to the CHANNEL table
`CONVERSATION_PROPERTY`
table	New Table		`CONVERSATION_PROPERTY`
`CONVERSATION_PROPERTY_CHOICE`
table	New Table		`CONVERSATION_PROPERTY_CHOICE`
`OUTBOUND_MESSAGE`
table	Deprecated Table
`OUTBOUND_MESSAGE_PHONE_NUMBER`
table	Deprecated Table

Google Analytics 4 Export

We've added the following columns to the EVENT table:

session_traffic_source_last_click
batch_event_index
batch_ordering_id
batch_page_id

Re-sync the connector to backfill the historical data for the new columns.

Google Display & Video 360

We've removed the following dimensions because they are no longer available in the Bid Manager API:

FILTER_PUBLISHER_PROPERTY
FILTER_PUBLISHER_PROPERTY_ID
FILTER_PUBLISHER_PROPERTY_SECTION
FILTER_PUBLISHER_PROPERTY_SECTION_ID

Jira Align

Effective December 3, 2024 we use a new December 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 fix validation errors.

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
`DEPENDENCY`
column	Rename Column		`isResponse_blocked`	`is_response_blocked`	We have made this change to fix validation errors.

JustCall

Effective December 5, 2024 we use a new December 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.

118 total changes • 30 possible breaking changes

Table/column	Change type	Old name	New name
`CALL`
column	Deprecated Column	`agent_email`
column	Deprecated Column	`call_info_url`
column	Deprecated Column	`direction`
column	Deprecated Column	`disposition_code`
column	Deprecated Column	`duration`
column	Deprecated Column	`friendly_duration`
column	Deprecated Column	`ivr_digit`
column	Deprecated Column	`ivr_digit_description`
column	Deprecated Column	`justcall_agent`
column	Deprecated Column	`missed_call_type`
column	Deprecated Column	`notes`
column	Deprecated Column	`queue_callback_agent_picked`
column	Deprecated Column	`queue_callback_customer_picked`
column	Deprecated Column	`queue_callback_request_time_elapsed`
column	Deprecated Column	`queue_callback_ringing_time_elapsed`
column	Deprecated Column	`rating`
column	Deprecated Column	`recording`
column	Deprecated Column	`status`
column	Deprecated Column	`time`
column	Deprecated Column	`time_utc`
column	Deprecated Column	`type`
column	New Column		`agent_active`
column	New Column		`call_date`
column	New Column		`call_duration_conversation_time`
column	New Column		`call_duration_friendly_duration`
column	New Column		`call_duration_handle_time`
column	New Column		`call_duration_hold_time`
column	New Column		`call_duration_queue_wait_time`
column	New Column		`call_duration_ring_time`
column	New Column		`call_duration_total_duration`
column	New Column		`call_duration_wrap_up_time`
column	New Column		`call_info_direction`
column	New Column		`call_info_disposition`
column	New Column		`call_info_missed_call_reason`
column	New Column		`call_info_notes`
column	New Column		`call_info_rating`
column	New Column		`call_info_recording`
column	New Column		`call_info_recording_child`
column	New Column		`call_info_status`
column	New Column		`call_info_type`
column	New Column		`call_info_voicemail_transcription`
column	New Column		`call_sid`
column	New Column		`call_time`
column	New Column		`call_user_date`
column	New Column		`call_user_time`
column	New Column		`contact_email`
column	New Column		`cost_incurred`
column	New Column		`forward_info_datetime`
column	New Column		`forward_info_from_number`
column	New Column		`forward_info_to_number`
column	New Column		`ivr_info_content`
column	New Column		`ivr_info_digit_pressed`
column	New Column		`justcall_ai_call_score`
column	New Column		`justcall_ai_call_score_parameters_call_etiquette`
column	New Column		`justcall_ai_call_score_parameters_customer_sentiment_score`
column	New Column		`justcall_ai_call_score_parameters_de_escalation`
column	New Column		`justcall_ai_call_score_parameters_dead_air_time`
column	New Column		`justcall_ai_call_score_parameters_empathy`
column	New Column		`justcall_ai_call_score_parameters_filler_word`
column	New Column		`justcall_ai_call_score_parameters_greeting`
column	New Column		`justcall_ai_call_score_parameters_monologue_duration`
column	New Column		`justcall_ai_call_score_parameters_talk_listen_ratio`
column	New Column		`justcall_ai_call_score_parameters_words_per_minute`
column	New Column		`justcall_ai_call_summary`
column	New Column		`justcall_ai_customer_sentiment`
column	New Column		`justcall_ai_manual_call_score`
column	New Column		`justcall_line_name`
column	New Column		`queue_callback_attempted_time`
column	New Column		`queue_callback_reached`
column	New Column		`queue_callback_reached_duration`
column	New Column		`queue_callback_reached_time`
column	New Column		`queue_callback_requested_time`
column	New Column		`queue_callback_status`
column	New Column		`queue_callback_wait_duration`
column	New Column		`queue_entered_at_position`
column	New Column		`queue_exit_reason`
`CALL_AI_MOMENT`
table	New Table		`CALL_AI_MOMENT`
`CALL_AI_TAG`
table	New Table		`CALL_AI_TAG`
`CALL_INFO_TRAIT`
table	New Table		`CALL_INFO_TRAIT`
`SALE_DIALER_CAMPAIGN`
column	New Column		`default_number`
column	New Column		`type`
`SALES_DIALER_ANALYTIC`
table	New Table		`SALES_DIALER_ANALYTIC`
`SALES_DIALER_CALL`
table	New Table		`SALES_DIALER_CALL`
`SALES_DIALER_CALL_AI_MOMENT`
table	New Table		`SALES_DIALER_CALL_AI_MOMENT`
`SALES_DIALER_CALL_AI_TAG`
table	New Table		`SALES_DIALER_CALL_AI_TAG`
`TEXT`
column	Deprecated Column	`agent_name`
column	Deprecated Column	`body`
column	Deprecated Column	`is_mms`
column	Deprecated Column	`mms`
column	New Column		`contact_email`
column	New Column		`contact_number`
column	New Column		`cost_incurred`
column	New Column		`justcall_line_name`
column	New Column		`medium`
column	New Column		`sms_date`
column	New Column		`sms_info_body`
column	New Column		`sms_info_is_mms`
column	New Column		`sms_time`
column	New Column		`sms_user_date`
column	New Column		`sms_user_time`
`USER_GROUP`
table	New Table		`USER_GROUP`
`USER_OWNED_NUMBER`
table	New Table		`USER_OWNED_NUMBER`
table	New Table		`USER_OWNED_NUMBER`
`USER_SHARED_NUMBER`
table	New Table		`USER_SHARED_NUMBER`
`USERS`
column	Deprecated Column	`availability`
column	Deprecated Column	`firstname`
column	Deprecated Column	`last_login`
column	Deprecated Column	`lastname`
column	Deprecated Column	`owner_id`
column	New Column		`available`
column	New Column		`created_at`
column	New Column		`extention`
column	New Column		`last_login_timestamp`
column	New Column		`name`
column	New Column		`role`
column	New Column		`timezone`
column	New Column		`unavailability_reason`
column	New Column		`working_hours_type`

MNTN

Effective December 12, 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 are making these changes to resolve data integrity issues caused by the MNTN API version update.

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

Table/column	Change type	Old name	New name
`CONVERSION`
column	Deprecated Column	`campaign_group_id`
column	Deprecated Column	`channel_name`
column	New Column		`conversion_point`
column	New Column		`last_touch`

Pingdom

Effective December 4, 2024 we use a new Decenber 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.

6 total changes • 6 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CHECK_DESCRIPTION`
column	Rename Column	`ipv6`	`ipv_6`
`CHECKS`
column	Rename Column	`ipv6`	`ipv_6`
`EMAIL`
column	Primary Key Change		`index` 🔑	New primary key
`PROBE`
column	Rename Column	`ipv6`	`ipv_6`
`SMS`
column	Primary Key Change		`index` 🔑	New primary key
`STATE`
column	Primary Key Change		`index` 🔑	New primary key

PostHog

Effective December 2, 2024 we use a new December 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 feature enhancements.

4 total changes • 0 possible breaking changes

Table/column	Change type	New name
`COHORT`
column	New Column	`groups`
`COHORT_PERSON`
table	New Table	`COHORT_PERSON`
`SESSION`
table	New Table	`SESSION`
`SESSION_RECORDING`
table	New Table	`SESSION_RECORDING`

Retently

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

December 17, 2024: Migration window begins. Additions and Phase 1 changes take effect. You can manually start the update in your Fivetran dashboard.

January 17, 2025: Migration window closes. If you haven't already started the update manually, Fivetran will apply the remaining changes automatically.

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.

16 total changes • 16 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CUSTOMER_PROPERTY`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Primary key Change		`index` 🔑	New primary key.
`FEEDBACK_ADDITIONAL_QUESTION`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary key Change	`feedback_id`	`feedback_id` 🔑	Added to primary key.
column	Primary key Change		`index` 🔑	New primary key.
`FEEDBACK_NOTE`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary key Change	`feedback_id`	`feedback_id` 🔑	Added to primary key.
column	Primary key Change		`index` 🔑	New primary key.
`OUTBOX_ADDITIONAL_RECIPIENT`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Primary key Change		`index` 🔑	New primary key.
`REPORT_TREND`
column	Deprecated Column	`_fivetran_id` 🔑		No longer primary key.
column	Primary key Change	`report_campaign_id`	`report_campaign_id` 🔑	Added to primary key.
column	Primary key Change		`index` 🔑	New primary key.
`TAGS`
table	Deprecated Table	`TAGS`

REVIEWS.io

Effective December 9, 2024 we use a new December 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.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`REVIEW_AND_QUESTION`
column	New Column			`nps`

Rocketlane

Effective December 12, 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 are making these 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.

36 total changes • 3 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`PROJECT`
column	New Column		`allocated_minute`
column	New Column		`billable_hour`
column	New Column		`billable_minute`
column	New Column		`currency_code`
column	New Column		`currency_name`
column	New Column		`currency_symbol`
column	New Column		`external_reference_id`
column	New Column		`financial_subscription_contract_frequency`
column	New Column		`financial_subscription_contract_no_of_periods`
column	New Column		`financial_subscription_contract_period_budget`
column	New Column		`financial_subscription_contract_period_minute`
column	New Column		`financial_subscription_contract_start_date`
column	New Column		`non_billable_hour`
column	New Column		`non_billable_minute`
column	New Column		`percentage_budget_consumed`
column	New Column		`tracked_minute`
`TASK`
column	New Column		`billable`
column	New Column		`csat_enabled`
column	New Column		`external_reference_id`
column	New Column		`parent_task_id`
column	New Column		`parent_task_name`
column	New Column		`phase_id`
column	New Column		`phase_name`
column	New Column		`priority_label`
column	New Column		`priority_value`
column	New Column		`task_private_note`
column	New Column		`time_entry_category_id`
column	New Column		`time_entry_category_name`
`TASK_DEPENDENCY`
column	Deprecated Column	`task_id` 🔑		No longer primary key
column	Primary Key Change		`task_dependency_id` 🔑	New primary key
column	Primary Key Change		`TASK_id` 🔑	New primary key
`TIME_ENTRY`
column	New Column		`bill_rate`
column	New Column		`bill_rate_currency`
column	New Column		`cost_rate`
column	New Column		`cost_rate_currency`
column	New Column		`status`

Sage Intacct

We have added existing columns, location_id and department_id, to the composite primary key in the USERRESTRICTION table.

Shopware

Effective December 5, 2024 we use a new December 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
`PRODUCT_ATTRIBUTE_CHEAPEST_PRICE`
table	New Table		`PRODUCT_ATTRIBUTE_CHEAPEST_PRICE`
`PRODUCT_ATTRIBUTE_PRICE`
table	New Table		`PRODUCT_ATTRIBUTE_PRICE`
`PRODUCT_PRICE`
table	Deprecated Table	`PRODUCT_PRICE`		Data now available in the `PRODUCT_ATTRIBUTE_PRICE` and `PRODUCT_ATTRIBUTE_CHEAPEST_PRICE` tables.

Squarespace

Effective December 5, 2024 we use a new December 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 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
`INTERNAL_NOTE`
column	Primary Key Change		`orders_id`	`orders_id` 🔑	Added to primary key.

Stripe

We've added the COUPON_PRODUCT table with two columns, coupon_id and product_id, to support mapping between the COUPON and PRODUCT tables.

Taboola

We've added the following columns to the ACCOUNT table:

default_platform
country
currency

We've added the following columns to the CAMPAIGN table:

bid_strategy
branding_text
campaign_item_type
campaign_profile
cpa_goal
end_date_in_utc
is_spend_guard_active
learning_state
marketing_objective
min_expected_conversions_for_cpa_goal
pricing_model
roas_goal
safety_rating
start_date_in_utc
target_cpa
traffic_allocation_ab_test_end_date
type

Teads

Effective December 4, 2024 we use a new December 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 ensure alignment with development framework best practices.

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.

42 total changes • 7 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`REPORT_BUDGET`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_DISPLAY_PROGRESS`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_LUMEN`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_MOAT`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_SCOPE`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_VIDEO`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`
`REPORT_VIDEO_PROGRESS`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	We've changed the way we calculate the primary key.
column	New Column		`advertiser_updated_at`
column	New Column		`campaign_updated_at`
column	New Column		`creative_updated_at`
column	New Column		`line_group_updated_at`
column	New Column		`line_item_updated_at`

Improvements

Amazon Ads

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

BigQuery destination

We now support the following BigQuery dataset locations:

Region	Code
Columbus, Ohio	us-east5
Dallas	us-south1
Santiago	southamerica-west1
Toronto	northamerica-northeast2
Madrid	europe-southwest1
Milan	europe-west8
Paris	europe-west9
Berlin	europe-west10
Turin	europe-west12
Doha	me-central1
Dammam	me-central2
Tel Aviv	me-west1
Johannesburg	africa-south1

Databricks

We now support IAM role authentication to authorize S3 buckets associated with Databricks destinations configured for Hybrid Deployment. We are gradually rolling out this change to all existing destinations.

Email

We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.

Facebook Ads

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

Freshsales

We have changed our sync strategy and now incrementally sync the CONTACT table and its child tables to capture updates and deletes. Previously, we re-imported the table.

Gainsight Customer Success

We now capture deletes for all standard and custom objects in Gainsight Customer Success. We are gradually rolling out this change to all existing connectors.

Google Display & Video 360

The Google Display & Video 360 connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Gorgias

We made the following changes to the sync strategy:

We now incrementally sync all tables and their child tables during every sync.
we now re-import all tables and their child tables once a week to capture updates and deletes.

HubSpot

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. For more information, see our Historical sync time frame documentation.

We apply the historical sync limit to the following tables only:

CUSTOM_EVENT
EVENT
EMAIL_EVENT

We are gradually rolling out this feature to all connectors.

Mode

We now re-import the REPORT_COLLECTION and REPORT_USING_DATA_SOURCE tables and their child tables once a week. See our Mode connector documentation for more details.

Persona

We made the following changes to the sync strategy:

We now incrementally sync the following tables and their child tables:
- ACCOUNT
- CASES
- INQUIRY
- LIST
- REPORT
- TRANSACTION
- USER_AUDIT_LOG
We now re-import the above tables and their child tables once a month to capture updates and deletes.

Recurly

We have added table re-sync support. Previously, we only supported connector-level re-syncs.

NOTE: Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.

Retently

We have added table re-sync support. Previously, we only supported connector-level re-syncs.

NOTE: Event-based tables and tables with a retention period at the source don't support this feature.

Rocketlane

We now re-import the following tables once a day to capture updates and deletes:

PROJECT
TASK
TIME_ENTRY

Ruddr

We now capture deletes for the ALLOCATION and TIME_ENTRY tables. We have also changed our sync strategy and now re-import the ALLOCATION and TIME_ENTRY tables once a week.

SFTP

We have updated the connection method for configuring a connector through REST API. We now use DIRECT and SSH_TUNNEL for configuration. Previously, we used direct and sshTunnel. For more information, see our REST API configuration.

Stripe

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