December 2024
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 0.12.12.1 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Updated testers for the
fivetran debugcommand with better-formatted logs. - An error message when attempting to deploy a connector with more than 100 configuration fields.
- Automatic handling of port conflicts on your local machine.
fivetran-api-playground PyPI package
We have released version 0.12.12.1 of the fivetran-api-playground PyPI package. This release adds the following:
- Export CSV endpoint for testing export APIs.
- Authentication endpoints for testing the following types of authentication:
- HTTP basic
- HTTP bearer
- API key
- Session token
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:
- BigMarker
- Brightpearl
- Contrast Security
- D2L Brightspace
- Grepsr
- Healthie
- LINE Ads
- Phoenix Ads
- sticky.io
- The Movie Database
- Tive
- Xsolla
- Zip
Sunset Service
Chartio
We no longer support Chartio as a BI tool for Fivetran-managed BigQuery destinations.
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
- Mailchimp to version 0.10.0
- Marketo to version 0.12.1
- Quickbooks to version 0.17.0
- Shopify to version 0.14.0
- Stripe to version 0.15.1
- Tiktok Ads to version 0.7.0
- Twilio to version 0.4.0
- Zendesk Support to version 0.19.1
We have also updated the Quickstart package for the Ad Reporting multi-connector data model to version 1.10.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.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.
These schema changes are required to adhere to standard naming conventions.
2 total changes • 2 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
We have made the following changes to adhere to standard naming conventions.
2 total changes • 2 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
We are making these schema changes to introduce feature enhancements and improve schema usability.
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 | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
We have made these schema changes to improve schema usability.
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.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.
We have made these schema changes to improve schema usability.
2 total changes • 1 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
We are making these schema changes for more efficient data management and retrieval.
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_clickbatch_event_indexbatch_ordering_idbatch_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_PROPERTYFILTER_PUBLISHER_PROPERTY_IDFILTER_PUBLISHER_PROPERTY_SECTIONFILTER_PUBLISHER_PROPERTY_SECTION_ID
Instagram Business
We've removed the video_views column from the MEDIA_INSIGHTS table.
We've also removed the following columns from the USER_INSIGHTS table:
email_contactsget_direction_clicksprofile_viewstext_message_clickswebsite_clicksphone_call_clicks
We made these changes because these metrics are no longer available in the Instagram API.
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.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.
We have made this schema change to fix validation errors.
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.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.
We have made these schema changes to improve schema usability.
118 total changes • 30 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
We are making these changes to resolve data integrity issues caused by the MNTN API version update.
4 total changes • 2 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSION | |||||
| column | Deprecated Column | campaign_group_id | |||
| column | Deprecated Column | channel_name | |||
| column | New Column | conversion_point | |||
| column | New Column | last_touch | |||
Persona
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.
We've made the following schema changes to improve schema usability.
2 total changes • 0 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INQUIRY | |||||
| column | New Column | current_government_id | |||
| column | New Column | current_selfie | |||
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.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.
We are making these schema changes for more efficient data management and retrieval.
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 | Old name | New name | Notes | |
|---|---|---|---|---|---|
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.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.
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.
21 total changes • 16 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COMPANY_TAG | |||||
| table | New Table | COMPANY_TAG | |||
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. | ||
CUSTOMER_TAG | |||||
| table | New Table | CUSTOMER_TAG | |||
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. | ||
FEEDBACK_RESPONSE_TAG | |||||
| table | New Table | FEEDBACK_RESPONSE_TAG | |||
FEEDBACK_TAG | |||||
| table | New Table | FEEDBACK_TAG | |||
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. | ||
OUTBOX_CUSTOMER_TAG | |||||
| table | New Table | OUTBOX_CUSTOMER_TAG | |||
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 | Data now available in the COMPANY_TAG, CUSTOMER_TAG, FEEDBACK_RESPONSE_TAG, FEEDBACK_TAG, and OUTBOX_CUSTOMER_TAG tables. | ||
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.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.
We are making these changes to improve schema usability.
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.
SAP Business ByDesign
We have added a new column, SALES_ORDER_UUID to the following tables.
SALES_ORDER_ITEM_PRODUCT_TAX_DETAILSSALES_ORDER_ITEM_SCHEDULE_LINESALES_ORDER_PRICE_COMPONENT
Shopify
We have added the following new tables:
- APP
- CATALOG
- DISPUTE
- PRODUCT_PUBLICATION
- PUBLICATION
- RETURN
- RETURN_LINE_ITEM
We are gradually rolling out this change to all existing connectors.
Perform resync of ORDER table to fetch historical data for RETURN and RETURN_LINE_ITEM
We will re-import the remaining tables and their child tables daily to capture updates and deletes.
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.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.
We are making these schema changes to improve schema usability.
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.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.
We've made the following changes to ensure data integrity.
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_platformcountrycurrency
We've added the following columns to the CAMPAIGN table:
bid_strategybranding_textcampaign_item_typecampaign_profilecpa_goalend_date_in_utcis_spend_guard_activelearning_statemarketing_objectivemin_expected_conversions_for_cpa_goalpricing_modelroas_goalsafety_ratingstart_date_in_utctarget_cpatraffic_allocation_ab_test_end_datetype
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.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.
We've made these schema changes to ensure alignment with development framework best practices.
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 | |||
Xactly
Effective December 20, 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 a feature enhancement.
6 total changes • 0 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
RATE_TABLE | |||||
| table | New Table | RATE_TABLE | |||
RATE_TABLE_TIER | |||||
| table | New Table | RATE_TABLE_TIER | |||
RATE_TIER_VALUE | |||||
| table | New Table | RATE_TIER_VALUE | |||
TITLE | |||||
| table | New Table | TITLE | |||
TITLE_CATEGORY | |||||
| table | New Table | TITLE_CATEGORY | |||
USER_ROLE | |||||
| table | New Table | USER_ROLE | |||
Zip
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.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.
This schema change is required to resolve the null primary key issue.
2 total changes • 2 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
VENDOR_EXTERNAL_DATA | |||||
| column | Primary Key Change | id 🔑 | id | No longer primary key | |
| column | Primary Key Change | index 🔑 | New primary key | ||
Improvements
Adyen
Our Adyen connector is now generally available. Read our Adyen documentation.
Amazon Ads
The Amazon Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions
Apache Kafka
The Apache Kafka 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 |
Confluent Cloud
The Confluent Cloud connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
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.
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.
Everhour
We now incrementally sync the ASSIGNMENT table.
We also re-import this table once a week to capture updates and deletes.
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 Cloud Storage
We have improved the setup experience for Google Cloud Storage connectors. New connectors created on or after December 20, 2024, will have the following changes in the connector setup form:
- Added a new configuration option, Run connection test to perform an intermediate test during configuration
- Added a new configuration option, Preview Files to perform an intermediate test during configuration
- Added support for displaying fields based on the file type
- Added a new field, Quote character, to use an enclosing character
- Reorganised fields to make the setup form more intuitive
- Removed Infer as an option from the File Type field
- Removed the Enable Advanced Options toggle
- Changed the Null Sequence field to a toggle
- For the Delimiter character(s) field, we now use
,as the default value - For the Line Separator field, we now use
\nas the default value
For more information, see our setup instructions and REST API configuration.
We are gradually rolling out these changes 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.
Healthie
We now re-import the USERS table once a week to capture updates and deletes.
Heroku Kafka
The Heroku Kafka connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
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_EVENTEMAIL_EVENTEVENT
We are gradually rolling out this feature to all connectors.
HubSpot will sunset the Contact List V1 APIs on May 2025. For all connectors created on or after December 13, 2024, we will use the V3 APIs to sync data to the CONTACT_LIST and CONTACT_LIST_MEMBER tables. For more information, see Hubspot documentation. We are gradually rolling out these changes to all existing connectors.
JustCall
We now sync only the last one day's worth of data for the following tables during each incremental sync.
CALLSALE_DIALER_CAMPAIGNSALES_DIALER_CALLTEXT
We now sync only the last 4 hours' worth of data for the SALES_DIALER_ANALYTIC table during each incremental sync.
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:
ACCOUNTCASESINQUIRYLISTREPORTTRANSACTIONUSER_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:
PROJECTTASKTIME_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.
Snowflake
The Snowflake connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Stripe
The Stripe connector now supports the Hybrid Deployment model. For more information, see our setup instructions.