December 2024
Coalesce Orchestration
Coalesce* Orchestration is now generally available.
Read our Coalesce Orchestration documentation.
* Coalesce is a trademark of Coalesce Automation, Inc. All rights therein are reserved to Coalesce Automation, Inc. Fivetran Transformations is not a product or service of or endorsed by Coalesce Automation, Inc.
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 0.12.17.1 of the PyPI package. This release contains some minor improvements.
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
- Clockodo
- Contrast Security
- D2L Brightspace
- Grepsr
- Healthie
- LINE Ads
- Phoenix Ads
- Pipe17
- Rokt
- Statistics Netherlands CBS
- sticky.io
- The Movie Database
- Tive
- Totango
- Xsolla
- Zip
Transformations for dbt Core
Updated dbt Quickstart packages
We have updated the Quickstart packages for the following connectors:
- Fivetran Platform Connector to version 1.10.0
- Greenhouse to version 0.8.0
- LinkedIn Ad Analytics to version 0.10.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.
Updated format for user-defined dbt jobs and Quickstart transformations
We have updated the format of logs and webhooks for user-defined dbt jobs and Quickstart transformations.
New connectors
AWS Cost and Usage Reports
AWS Cost and Usage Reports is a tool to track and extract your cost and usage metrics. Read our AWS Cost and Usage Reports connector documentation.
Schema changes
Ada
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION | |||||
| column | New Column | generated_topic_v_2_desc | |||
| column | New Column | generated_topic_v_2_id | |||
| column | New Column | generated_topic_v_2_parent_id | |||
| column | New Column | generated_topic_v_2_title | |||
Aircall
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CALL | |||||
| column | New Column | sid | |||
USER_AVAILABILITY | |||||
| table | New Table | USER_AVAILABILITY | |||
Apple App Store
We have added the date column to the SALES_SUBSCRIPTION_SUMMARY table. For all existing connections, we will perform a free historical re-sync of the SALES_SUBSCRIPTION_SUMMARY table to populate it with data. For more details, see the Apple App Store ERD.
Asana
We have added a new column, actual_time_minutes, to the TASK table.
We have added a new table, TIME_TRACKING.
For more information, see the Asana ERD.
Assembled
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EVENT_CHANGE | |||||
| column | New Column | event_id | |||
Backbone PLM
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BOM_DIVIDER | |||||
| column | Primary Key Change | id 🔑 | id | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
BOM_ITEM_COLORWAY | |||||
| column | Discontinued Column | bom_item_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | custom_color 🔑 | custom_color | No longer a primary key. | |
| column | Primary Key Change | bom_item_index 🔑 | New primary key. | ||
| column | Primary Key Change | index 🔑 | New primary key. | ||
BOM_ITEM_COMPONENT_TECHPACK_IMAGE | |||||
| column | Discontinued Column | bom_item_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | image 🔑 | image | No longer a primary key. | |
| column | Primary Key Change | bom_item_index 🔑 | New primary key. | ||
| column | Primary Key Change | index 🔑 | New primary key. | ||
BOM_ITEM_COMPONENT_VARIANT | |||||
| column | Discontinued Column | bom_item_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | bom_item_index 🔑 | New primary key. | ||
BOM_ITEM_DETAIL | |||||
| column | Primary Key Change | id 🔑 | id | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
BOM_ITEM_TECHPACK_IMAGE | |||||
| column | Primary Key Change | image 🔑 | image | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
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 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 | Discontinued Table | ASSIGNMENT_ASSET | Data is available in the ASSIGNMENT_ASSET_TYPE table. | ||
ASSIGNMENT_ASSET_ARTICULATION_RULE | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_ARTICULATION_RULE | Data is available in the ASSIGNMENT_ASSET_TYPE_ARTICULATION_RULE table. | ||
ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | Data is available in the ASSIGNMENT_ASSET_TYPE_CHARACTERISTIC_TYPE table. | ||
ASSIGNMENT_ASSET_DATA_QUALITY_RULE | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_DATA_QUALITY_RULE | Data is available in the ASSIGNMENT_ASSET_TYPE_DATA_QUALITY_RULE table. | ||
ASSIGNMENT_ASSET_DOMAIN_TYPE | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_DOMAIN_TYPE | Data is available in the ASSIGNMENT_ASSET_TYPE_DOMAIN_TYPE table. | ||
ASSIGNMENT_ASSET_STATUS | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_STATUS | Data is available in the ASSIGNMENT_ASSET_TYPE_STATUS table. | ||
ASSIGNMENT_ASSET_TYPE | |||||
| column | New Column | scope_id | |||
ASSIGNMENT_ASSET_VALIDATION_RULE | |||||
| table | Discontinued Table | ASSIGNMENT_ASSET_VALIDATION_RULE | Data is available in the ASSIGNMENT_ASSET_TYPE_VALIDATION_RULE table. | ||
ASSIGNMENT_SCOPE_COMMUNITY | |||||
| table | Discontinued Table | ASSIGNMENT_SCOPE_COMMUNITY | Data is available in the SCOPE_COMMUNITY table. | ||
ASSIGNMENT_SCOPE_DOMAIN | |||||
| table | Discontinued Table | ASSIGNMENT_SCOPE_DOMAIN | Data is 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 the Facebook API documentation.
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 | Updated to adhere to standard naming conventions. | |
CHANNEL_WELCOME_MESSAGE | |||||
| column | Discontinued Column | bots_private_note | Column moved to the CHANNEL table. | ||
| column | Discontinued Column | message_type | Column moved to the CHANNEL table. | ||
| column | Discontinued 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 | Discontinued Table | ||||
OUTBOUND_MESSAGE_PHONE_NUMBER | |||||
| table | Discontinued Table | ||||
Google Ads
We now support the following resources as custom reports:
We now support the following fields for the CAMPAIGN report:
segments.travel_destination_citysegments.travel_destination_countrysegments.travel_destination_regionmetrics.general_invalid_clicksmetrics.general_invalid_click_ratecampaign.brand_guidelines_enabled
We now support the following fields for the AD_GROUP report:
segments.travel_destination_citysegments.travel_destination_countrysegments.travel_destination_regionad_group.exclude_demographic_expansion
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 connection 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
HubSpot
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INVOICE | |||||
| table | New Table | INVOICE | |||
INVOICE_COMPANY | |||||
| table | New Table | INVOICE_COMPANY | |||
INVOICE_CONTACT | |||||
| table | New Table | INVOICE_CONTACT | |||
INVOICE_DEAL | |||||
| table | New Table | INVOICE_DEAL | |||
INVOICE_LINE_ITEM | |||||
| table | New Table | INVOICE_LINE_ITEM | |||
INVOICE_PROPERTY_HISTORY | |||||
| table | New Table | INVOICE_PROPERTY_HISTORY | |||
INVOICE_TICKET | |||||
| table | New Table | INVOICE_TICKET | |||
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_viewsphone_call_clickstext_message_clickswebsite_clicks
We made these changes because these metrics are no longer available in the Instagram API.
JustCall
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CALL | |||||
| column | Discontinued Column | agent_email | |||
| column | Discontinued Column | call_info_url | |||
| column | Discontinued Column | direction | |||
| column | Discontinued Column | disposition_code | |||
| column | Discontinued Column | duration | |||
| column | Discontinued Column | friendly_duration | |||
| column | Discontinued Column | ivr_digit | |||
| column | Discontinued Column | ivr_digit_description | |||
| column | Discontinued Column | justcall_agent | |||
| column | Discontinued Column | missed_call_type | |||
| column | Discontinued Column | notes | |||
| column | Discontinued Column | queue_callback_agent_picked | |||
| column | Discontinued Column | queue_callback_customer_picked | |||
| column | Discontinued Column | queue_callback_request_time_elapsed | |||
| column | Discontinued Column | queue_callback_ringing_time_elapsed | |||
| column | Discontinued Column | rating | |||
| column | Discontinued Column | recording | |||
| column | Discontinued Column | status | |||
| column | Discontinued Column | time | |||
| column | Discontinued Column | time_utc | |||
| column | Discontinued 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 | Discontinued Column | agent_name | |||
| column | Discontinued Column | body | |||
| column | Discontinued Column | is_mms | |||
| column | Discontinued 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 | Discontinued Column | availability | |||
| column | Discontinued Column | firstname | |||
| column | Discontinued Column | last_login | |||
| column | Discontinued Column | lastname | |||
| column | Discontinued 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 | Discontinued Column | campaign_group_id | |||
| column | Discontinued Column | channel_name | |||
| column | New Column | conversion_point | |||
| column | New Column | last_touch | |||
Notion
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PAGE | |||||
| column | New Column | in_trash | |||
Persona
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INQUIRY | |||||
| column | New Column | current_government_id | |||
| column | New Column | current_selfie | |||
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 | |
|---|---|---|---|---|---|
COMPANY_TAG | |||||
| table | New Table | COMPANY_TAG | |||
CUSTOMER_PROPERTY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a 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 | Discontinued Column | _fivetran_id 🔑 | No longer a 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 | Discontinued Column | _fivetran_id 🔑 | No longer a 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 | Discontinued Column | _fivetran_id 🔑 | No longer a 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 | Discontinued Column | _fivetran_id 🔑 | No longer a 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 | Discontinued Table | TAGS | Data is available in the COMPANY_TAG, CUSTOMER_TAG, FEEDBACK_RESPONSE_TAG, FEEDBACK_TAG, and OUTBOX_CUSTOMER_TAG tables. | ||
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 | Discontinued Column | task_id 🔑 | No longer a 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 the existing columns, location_id and department_id, to the composite primary key in the USERRESTRICTION table.
SAP Business ByDesign
We have added the following columns to the SALES_ORDER_UUID table:
sales_order_item_product_tax_detailssales_order_item_schedule_linesales_order_price_component
Shopify
We have added the following new tables:
APPCATALOGDISPUTEPRODUCT_PUBLICATIONPUBLICATIONRETURNRETURN_LINE_ITEM
We are gradually rolling out this change to all existing connections.
We have changed our sync strategy and now re-import all tables and their child tables (except for the ORDER table) to capture updates and deletes.
Perform a re-sync of ORDER table to fetch historical data for RETURN and RETURN_LINE_ITEM.
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 | Discontinued Table | PRODUCT_PRICE | Data is 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 a new table, COUPON_PRODUCT, with two columns, coupon_id and product_id, to support the 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
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
REPORT_BUDGET | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 🔑 | Primary key calculation change. | |
| 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 | |||
Workday Financial Management
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CUSTOMER_INVOICE_ADJUSTMENT_LINE_DATA | |||||
| column | New Column | revenue_category_id | Added to foreign key of REVENUE_CATEGORY table. The new column supports the mapping between the CUSTOMER_INVOICE_ADJUSTMENT_LINE_DATA and REVENUE_CATEGORY tables. | ||
CUSTOMER_INVOICE_LINE | |||||
| column | New Column | revenue_category_id | Added to foreign key of REVENUE_CATEGORY table. The new column supports the mapping between the CUSTOMER_INVOICE_LINE and REVENUE_CATEGORY tables. | ||
Xactly
| 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
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
VENDOR_EXTERNAL_DATA | |||||
| column | Primary Key Change | id 🔑 | id | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
Improvements
Adyen
Our Adyen connector is now generally available. Read our Adyen connector documentation.
Affinity
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
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.
Azure Blob Storage
We have improved the setup experience for our Azure Blob Storage connector. New connections created on or after December 20, 2024, will have the following changes in the connection 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 connections.
Azure DevOps
Our Azure DevOps connector is now generally available. Read our Azure DevOps connector documentation.
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 |
Chargebee Product Catalog 2.0
The Chargebee Product Catalog 2.0 connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. For the Chargebee Product Catalog 2.0 connector, priority-first syncs fetch the past 30 days' worth of data from the QUOTE and QUOTE_SUBSCRIPTION tables.
To learn more, see our priority-first sync documentation.
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.
Dropbox Sign
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
We have added a new configuration option, Primary Key used for file process and load, to the connection setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connection 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.
Eventbrite
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Everhour
We have changes our sync strategy for the ASSIGNMENT table. We now incrementally sync the ASSIGNMENT table and also re-import the 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.
Flexport
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Float
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
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. We are gradually rolling out this change to all existing connections.
Google Ads
We now support Google Ads v18.
Google Cloud Storage
We have improved the setup experience for our Google Cloud Storage connector. New connections 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 connections.
Google Display & Video 360
The Google Display & Video 360 connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Google Drive
We have improved the setup experience for our Google Drive connector. New connections created on or after December 21, 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 connections.
Gorgias
We have changed our sync strategy. We now incrementally sync all the tables during every sync. We also re-import all the tables weekly to capture updates and deletes.
Healthie
We have changed our sync strategy and now re-import the USERS table weekly 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 connection setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connection, 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 connections.
HubSpot will sunset the Contact List V1 APIs on May 2025. For all connections 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 connections.
JustCall
We have changed our sync strategy. We now sync only the last one day's worth of data during the incremental sync for the following tables:
CALLSALE_DIALER_CAMPAIGNSALES_DIALER_CALLTEXT
Also, we now sync only the last 4 hours' worth of data for the SALES_DIALER_ANALYTIC table during the incremental sync.
Mode
We have changed our sync strategy and now re-import the REPORT_COLLECTION and REPORT_USING_DATA_SOURCE tables and their child tables weekly. For more details, see our Mode connector documentation.
Notion
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Pardot
We have removed the Sync External Activities toggle from the connection setup form and now sync the EXTERNAL_ACTIVITY table if you provide the required scopes for the /external-activities endpoint. We make API calls to the endpoint to validate the scopes, and if the calls succeed, we sync the EXTERNAL_ACTIVITY table. For more information, see Pardot documentation.
You must continue to specify the Set up API rate limit for External Activities for the /external-activities endpoint.
If your schema change handling configuration settings is Allow all, we will sync the EXTERNAL_ACTIVITY table to your destination.
PowerReviews Enterprise
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Recurly
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Retently
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
Event-based tables and tables with a retention period at the source don't support this feature.
Revel Systems
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Rocketlane
We have changed our sync strategy and now re-import the following tables daily to capture updates and deletes:
PROJECTTASKTIME_ENTRY
RTB House
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
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 weekly.
Salesforce
We have added a new toggle, Sync formula fields directly, to the connection setup form, with a default value of OFF. For an existing connection, you can click Edit connection in the Setup tab and enable or disable the toggle. Previously, this configuration (of syncing formula fields directly) was only possible through the REST API.
This toggle allows you to sync formula fields directly. However, to maintain data integrity, we recommend using our transformation-based approach instead. Directly syncing formula fields can lead to data integrity issues, as outlined in the Sync limitations section.
Samsara
We have changed the sync strategy and now re-import the VEHICLE table during every sync. Previously, we used to incrementally sync the table.
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.
SharePoint
We have improved the setup experience for our Sharepoint connector. New connections created on or after December 20, 2024, will have the following changes in the connection setup form:
- 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 connections.
Short.io
We have changed our sync strategy and now incrementally sync the LINK_STATISTICS and DOMAIN_STATISTICS tables. Previously, we re-imported these tables.
We no longer incrementally sync the LINK table.
We now re-import the DOMAIN_STATISTICS table weekly to capture updates and deletes.
Skilljar
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Snowflake
The Snowflake connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
StackAdapt
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Stripe
The Stripe connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Trisolute
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
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 connection details page in your Fivetran dashboard.
Workable
We have changed our sync strategy and no longer re-import the CANDIDATE table and its child tables.
REST API Improvements
Delighted
We have added a new paramater, password, to the REST API configuration.