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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EMAIL_CAMPAIGN | |||||
column | Rename Column | tag | tags | ||
EMAIL_TEMPLATE | |||||
column | Rename Column | tag | tags |
Chameleon
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
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
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
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
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
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
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
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
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 |
Pingdom
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
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
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
REVIEW_AND_QUESTION | |||||
column | New Column | nps |
Rocketlane
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
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
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
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.
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.