November 2024
Connector SDK
Fivetran Connector SDK
We have released the beta version of our Connector SDK.
Fivetran Connector SDK allows you to code a custom data connector using Python and deploy it as an extension of Fivetran. Fivetran automatically runs the connector at your scheduled frequency and manages the required compute resources. See our Connector SDK Quickstart Setup Guide to begin writing your connector.
fivetran-connector-sdk
PyPI package
We have released version 0.11.21.1
of the PyPI package. We now show the connector_id
in the success message of the fivetran deploy
command.
We have released version 0.11.14.1
of the PyPI package. This release adds the following:
- Support for Python version 3.12.
- Adds a
--force
flag tofivetran deploy
command which bypasses the connector exists check.
fivetran-api-playground
PyPI package
We have released version 0.11.21.1
of the PyPI package. This release adds changelog section to our PyPI package.
We have released version 0.11.14.1
of the PyPI package. This release adds support for Python version 3.12.
Lite Connectors
Lite connectors are now available for the following sources:
- Algolia
- Betterworks
- Cimis
- Clazar
- Clubspeed
- Coassemble
- Compliance Checkpoint
- Dialpad
- Everflow
- Exact Online
- ExpenseIn
- e-conomic
- Formstack
- FourKites
- Freshsales
- Freshsuccess
- Google Classroom
- Google Tasks
- GreenPowerMonitor
- Jamf
- Jibble
- JobNimbus
- Konnect Insights
- Lucca
- Malomo
- Nice
- PandaDoc
- Prisma Cloud
- REVIEWS.ai
- Rundeck
- SafeBase
- Sage HR
- Sana
- SugarCRM
- Vimeo
- Visit by GES
- Walmart Marketplace
- Wicked Reports
Hybrid Deployment support
The following Lite connectors now support the Hybrid Deployment model:
Expand to see the full list
- 7shifts
- 360Learning
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- Affinity
- Afterpay
- Aha!
- Akamai
- Akeneo
- Amazon Attribution
- Anvyl
- Appcues
- Appfigures
- Attio
- Aumni
- Auth0
- AvantLink
- Awin
- Backbone PLM
- BallotReady
- Bazaarvoice
- Bigin by Zoho CRM
- BillingPlatform
- Birdeye
- Bitly
- Bizzabo
- Boostr
- Brave Ads
- Brevo
- Brex
- Brightcove
- Buildium
- Buildkite
- Buzzsprout
- Calabrio
- Calendly
- CallRail
- Campaign Monitor
- Canny
- Canvas by Instructure
- Care Quality Commission
- Castor EDC
- Chameleon
- Chargebee Product Catalog 1.0
- Chargebee Product Catalog 2.0
- ChargeDesk
- ChartMogul
- Checkout.com
- Chorus
- Churnkey
- ChurnZero
- Cin7
- Cin7 Core
- CircleCI
- CJ Commission Detail
- Clari
- ClickUp
- Clockify
- Close
- Codefresh
- Collibra
- Column
- Concord
- Confluence
- Copper
- Criteo Retail Media
- Crossbeam
- crowd.dev
- Culture Amp
- Cvent
- Datadog
- dbt Cloud
- DCL Logistics
- Deputy
- Destini
- Dixa
- Docebo
- DoorLoop
- Drata
- Drift
- Drip
- Dropbox Sign
- DSV
- Duoplane
- EasyPost
- eBay
- Electronic Tenant Solutions
- Employment Hero
- Eventbrite
- Eventsforce
- Everhour
- ExpenseIn
- Expensify
- EZOfficeInventory
- Factbird
- Factorial
- Fillout
- FireHydrant
- Flexport
- Float
- Fone Dynamics
- Forj Community
- Fountain
- Freightview
- FreshBooks
- Freshchat
- Freshdesk Contact Center
- FreshTeam
- Friendbuy
- FullStory
- Gainsight Product Experience
- Gem
- Genesys
- GetFeedback
- GitLab
- Gladly
- GlobalMeet
- Gmail
- GoCardless
- Google Business Profile
- Google Calendar
- Gorgias
- GRIN
- Guru
- HappyFox
- Harvest
- Helpshift
- HiBob
- Hopin
- iLevel
- Incident.io
- Infobip
- Insightly
- Integral Ad Science
- Integrate
- Ironclad
- ironSource
- Ivanti
- Jira Align
- Jotform
- JustCall
- Kandji
- Katana
- Kevel
- KeyPay
- Khoros Care
- Kisi
- Kissmetrics
- Klarna
- Lattice
- LaunchDarkly
- LearnUpon
- Lemlist
- Lessonly
- Liftoff
- Linear
- LinkSquares
- LiveChat Partner
- Lob
- Looker
- Loop
- Loopio
- Luma
- Mailgun
- Mambu
- Matomo
- Maxio Chargify
- Maxio SaaSOptics
- Medallia Agile Research
- Megaphone
- Mention
- Microsoft Entra ID
- Missive
- Mixmax
- MNTN
- Mode
- Moloco
- Mux
- myosh
- Namely
- Navan
- Notion
- Okendo
- Ometria
- ON24
- OnceHub
- Open Data DC
- Open Exchange Rates
- Opsgenie
- Oracle Moat Analytics
- Orbit
- Ordway
- Ortto
- PagerDuty
- Papershift
- Partnerize
- PartnerStack Vendor
- Paychex
- Persona
- Personio
- Picqer
- Pingdom
- Pinpoint
- Pinterest Organic
- Pivotal Tracker
- Piwik PRO
- Planful
- Planhat
- Playvox
- Playvox Workforce Management
- Podio
- PostHog
- Postmark
- PowerReviews Enterprise
- Prive
- Procore
- Productboard
- Productive
- Proofpoint Security Awareness
- Qualaroo
- Quora Ads
- Rakuten Advertising
- Ramp
- Rarible
- ReBound Returns
- ReferralHero
- Resource Management by Smartsheet
- RetailNext
- Retently
- Revel Systems
- RevenueCat
- REVIEWS.io
- RevOps
- RevX
- Ricochet360
- Ringover
- Rippling
- Rithum
- Rocketlane
- Rollbar
- Rootly
- RTB House
- Ruddr
- SafetyCulture
- Salsify
- Samsara
- SCORM
- Security Journey
- ServiceTitan
- Sharetribe
- ShipHero
- ShipNetwork
- ShipStation
- Shopware
- Short.io
- Shortcut
- Sigma Computing
- Simplecast
- Simplesat
- SISTRIX
- Skilljar
- SkillsTX
- SkuVault
- Smadex
- SmartHR
- SmartRecruiters
- Smartwaiver
- Snyk
- SolarWinds Service Desk
- SonarQube
- SparkPost
- Splash
- Split
- Squarespace
- StackAdapt
- Standard Metrics
- StarRez
- Statuspage
- Stylight
- Subscript
- Survicate
- Swoogo
- Tableau
- Talkwalker
- Teads
- Teamtailor
- Teamwork
- Tempo
- TestRail
- Thinkific
- Ticket Tailor
- Toggl Track
- Transcend
- Trelica
- Trello
- Tremendous
- Triple Whale
- Trisolute
- Tymeshift
- Udemy Business
- UKG Pro
- Upland Software
- UpPromote
- Veeqo
- Vitally
- Vonage Contact Center
- VTS
- VWO
- Webconnex
- When I Work
- Wherefour
- WooCommerce
- WordPress
- Workable
- Workday Strategic Sourcing
- WorkRamp
- Wrike
- Xandr
- Xray
- Yahoo Search Ads on Yahoo Japan
- YouGov Sport
- Younium
- Zenefits
- Zingtree
- Zoho Books
- Zoho Campaigns
- Zoho Desk
- Zonka Feedback
- Zoom
Logs
Log event api_call
removed
We have removed the api_call
from the log event list. Use the new event, extract_summary
, instead.
For more information, see our Logs documentation.
New Account Overview page
We have added a new Overview page on the Fivetran dashboard. The page provides you with a comprehensive overview of your account and enables you to see and manage your connectors, transformations, and destinations.
Read more about the new page in our documentation.
Transformations for dbt Core
Updated dbt Quickstart package
We have updated the Quickstart packages for the following connectors:
- Amplitude to version 0.5.0
- Apple Search Ads to version 0.4.1
- Facebook Ads to version 0.8.0
- HubSpot to version 0.20.0
- Iterable to version 0.13.0
- Jira to version 0.19.0
- LinkedIn Ad Analytics to version 0.9.1
- Recurly to version 0.5.1
- Reddit Ads to version 0.3.1
- Zendesk Support to version 0.18.1
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
New connectors
Reltio
Our Reltio connector is now available in BETA.
Read our Reltio connector documentation.
Schema changes
Affinity
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FIELD_VALUE | |||||
table | Deprecated Table | FIELD_VALUE | Data now available in the opportunity_field_value , organization_field_value , and person_field_value tables. | ||
OPPORTUNITY_FIELD_VALUE | |||||
table | New Table | OPPORTUNITY_FIELD_VALUE | |||
ORGANIZATION_FIELD_VALUE | |||||
table | New Table | ORGANIZATION_FIELD_VALUE | |||
PERSON_FIELD_VALUE | |||||
table | New Table | PERSON_FIELD_VALUE |
Amazon Ads
We have deprecated the following Sponsored Display version 2 reporting tables in accordance with Amazon's deprecation calendar:
- 'SD_AD_GROUP_REPORT'
- 'SD_ASIN_REPORT'
- 'SD_CAMPAIGN_REPORT'
- 'SD_MATCHED_TARGET_REPORT'
- 'SD_PRODUCT_AD_REPORT'
- 'SD_TARGET_REPORT'
NOTE: The tables listed above have stopped receiving new data. However, we've renamed these tables in your destination by adding the '_v_2' suffix to each of them. You still have access to old data.
We have added support for the following Sponsored Display version 3 reporting tables:
- 'SD_AD_GROUP_REPORT_V_3'
- 'SD_CAMPAIGN_REPORT_V_3'
- 'SD_MATCHED_TARGET_REPORT_V_3'
- 'SD_PRODUCT_AD_REPORT_V_3'
- 'SD_PURCHASED_PRODUCTS_REPORTS'
- 'SD_TARGET_REPORT_V_3'
NOTE: Until November 15, 2024, all usage related to these new reports counts towards free MAR.
Chameleon
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
MICRO_SURVEY_RESPONSE | |||||
column | New Column | comment_step_button_selected | |||
column | New Column | comment_step_button_selected_2 | |||
column | New Column | comment_step_dropdown_item_2 | |||
column | New Column | comment_step_other_text_2 | |||
column | New Column | input_text_2 |
ChargeDesk
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ITEM | |||||
column | Rename Column | percent | percents |
Cin7 Core
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PRODUCT_MOVEMENT | |||||
column | Primary Key Change | index 🔑 | New primary key. |
Coupa
We have added a new table, SUPPLIER_PREFERRED_COMMODITIES_MAPPING
. The table stores the preferred commodities of a supplier.
DCL Logistics
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ORDER_SHIPMENT_SHIPPED_LINE_BUNDLE_LINE | |||||
column | Rename Column | item_number 🔑 | order_shipment_shipped_line_item_number |
Expensify
null
primary key issue.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EXPENSE_ATTENDEE | |||||
column | Primary Key Change | transaction_id | transaction_id 🔑 | Added to primary key. |
Facebook Ads
Due to changes to the Facebook API, for the unique_actions
and cost_per_unique_action_type
custom report fields, we now support only the following action_type
breakdowns:
link_click
onsite_conversion_messaging_first_reply
onsite_conversion_total_messaging_connection
outbound_click
We no longer support the following action_type
breakdowns for the unique_actions
and cost_per_unique_action_type
fields:
add_payment_info
add_to_cart
app_custom_event
app_custom_event.fb_mobile_achievement_unlocked
app_custom_event.fb_mobile_activate_app
app_custom_event.fb_mobile_add_payment_info
app_custom_event.fb_mobile_add_to_cart
app_custom_event.fb_mobile_add_to_wishlist
app_custom_event.fb_mobile_complete_registration
app_custom_event.fb_mobile_content_view
app_custom_event.fb_mobile_d2_retention
app_custom_event.fb_mobile_d7_retention
app_custom_event.fb_mobile_initiated_checkout
app_custom_event.fb_mobile_level_achieved
app_custom_event.fb_mobile_purchase
app_custom_event.fb_mobile_rate
app_custom_event.fb_mobile_search
app_custom_event.fb_mobile_spent_credits
app_custom_event.fb_mobile_tutorial_completion
app_custom_event.other
app_engagement
app_install
call_confirm_grouped
checkin
click_to_call_call_confirm
click_to_call_callback_request_submitted
click_to_call_native_20s_call_connect
click_to_call_native_60s_call_connect
click_to_call_native_call_placed
click_to_join_new_channel_member
comment
commerce_event
complete_registration
credit_spent
group_join
initiate_checkout
landing_page_view
lead
leadgen_grouped
like
mobile_app_install
offline_conversion
offline_conversion.add_payment_info
offline_conversion.add_to_cart
offline_conversion.add_to_wishlist
offline_conversion.complete_registration
offline_conversion.initiate_checkout
offline_conversion.lead
offline_conversion.other
offline_conversion.purchase
offline_conversion.search
offline_conversion.view_content
offsite_conversion
offsite_conversion.fb_pixel_add_payment_info
offsite_conversion.fb_pixel_add_to_cart
offsite_conversion.fb_pixel_add_to_wishlist
offsite_conversion.fb_pixel_complete_registration
offsite_conversion.fb_pixel_custom
offsite_conversion.fb_pixel_initiate_checkout
offsite_conversion.fb_pixel_lead
offsite_conversion.fb_pixel_purchase
offsite_conversion.fb_pixel_search
offsite_conversion.fb_pixel_view_content
omni_achievement_unlocked
omni_activate_app
omni_add_to_cart
omni_add_to_wishlist
omni_app_install
omni_complete_registration
omni_custom
omni_initiated_checkout
omni_level_achieved
omni_purchase
omni_rate
omni_search
omni_spend_credits
omni_tutorial_completion
omni_view_content
onsite_app_add_to_cart
onsite_app_purchase
onsite_app_view_content
onsite_conversion.add_to_cart
onsite_conversion.add_to_wishlist
onsite_conversion.click_to_call
onsite_conversion.donate
onsite_conversion.find_location
onsite_conversion.flow_complete
onsite_conversion.initiate_checkout
onsite_conversion.lead
onsite_conversion.lead_grouped
onsite_conversion.message_to_buy
onsite_conversion.messaging_20s_call_connect
onsite_conversion.messaging_60s_call_connect
onsite_conversion.messaging_block
onsite_conversion.messaging_business_calling_call_answered
onsite_conversion.messaging_business_calling_call_initiated
onsite_conversion.messaging_business_calling_call_missed
onsite_conversion.messaging_business_calling_opt_in_accepted
onsite_conversion.messaging_business_calling_opt_in_denied
onsite_conversion.messaging_business_calling_opt_in_sent
onsite_conversion.messaging_conversation_replied_7d
onsite_conversion.messaging_conversation_started_7d
onsite_conversion.messaging_order_created_v2
onsite_conversion.messaging_order_shipped_v2
onsite_conversion.messaging_user_call_placed
onsite_conversion.messaging_user_depth_2_message_send
onsite_conversion.messaging_user_depth_3_message_send
onsite_conversion.messaging_user_subscribed
onsite_conversion.messaging_welcome_message_view
onsite_conversion.other
onsite_conversion.post_save
onsite_conversion.purchase
onsite_conversion.view_content
onsite_web_add_to_cart
onsite_web_app_add_to_cart
onsite_web_app_purchase
onsite_web_app_view_content
onsite_web_lead
onsite_web_purchase
onsite_web_view_content
page_engagement
photo_view
post
post_engagement
post_reaction
purchase
rsvp
search
video_view
view_content
Factbird
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CHANGEOVER_STOP | |||||
table | New Table | CHANGEOVER_STOP | |||
OEE | |||||
table | New Table | OEE | |||
PRODUCT | |||||
table | New Table | PRODUCT |
Gladly
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
AGENT_AVAILABILITY_EVENT | |||||
table | New Table | AGENT_AVAILABILITY_EVENT | |||
AGENT_DURATION_REPORT | |||||
table | New Table | AGENT_DURATION_REPORT | |||
AGENT_STATUS_EVENT | |||||
table | New Table | AGENT_STATUS_EVENT | |||
AGENT_TIMESTAMPS_REPORT | |||||
table | New Table | AGENT_TIMESTAMPS_REPORT | |||
CONTACT_EVENT | |||||
table | New Table | CONTACT_EVENT | |||
CONTACT_EXPORT_REPORT_V_3 | |||||
table | New Table | CONTACT_EXPORT_REPORT_V_3 | |||
CONTACT_TIMESTAMP_REPORT | |||||
table | New Table | CONTACT_TIMESTAMP_REPORT | |||
CONVERSATION_EXPORT_REPORT | |||||
table | New Table | CONVERSATION_EXPORT_REPORT | |||
CUSTOMER_EVENT | |||||
table | New Table | CUSTOMER_EVENT | |||
GLAD_APP_ANSWER_SEARCH_REPORT | |||||
table | New Table | GLAD_APP_ANSWER_SEARCH_REPORT | |||
GLAD_APP_ANSWER_USAGE_REPORT | |||||
table | New Table | GLAD_APP_ANSWER_USAGE_REPORT | |||
GLAD_APP_CONTACT_POINT_REPORT | |||||
table | New Table | GLAD_APP_CONTACT_POINT_REPORT | |||
HELP_CENTER_ANSWER_USAGE_REPORT | |||||
table | New Table | HELP_CENTER_ANSWER_USAGE_REPORT | |||
PAYMENT_REQUEST_EVENT | |||||
table | New Table | PAYMENT_REQUEST_EVENT | |||
QUICK_ACTION_USAGE_REPORT | |||||
table | New Table | QUICK_ACTION_USAGE_REPORT | |||
TASK_EVENT | |||||
table | New Table | TASK_EVENT | |||
TASK_EXPORT_REPORT | |||||
table | New Table | TASK_EXPORT_REPORT | |||
TASK_SUMMARY_REPORT | |||||
table | New Table | TASK_SUMMARY_REPORT | |||
TASK_TIMESTAMPS_REPORT | |||||
table | New Table | TASK_TIMESTAMPS_REPORT | |||
WORK_SESSION_REPORT | |||||
table | New Table | WORK_SESSION_REPORT |
Google Ads
We have added two new metadata tables, AD_GROUP_BID_MODIFIER_HISTORY
and CAMPAIGN_BID_MODIFIER_HISTORY
.
HubSpot
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FEEDBACK_SUBMISSION | |||||
table | New Table | FEEDBACK_SUBMISSION | |||
FEEDBACK_SUBMISSION_CONTACT | |||||
table | New Table | FEEDBACK_SUBMISSION_CONTACT | |||
FEEDBACK_SUBMISSION_PROPERTY_HISTORY | |||||
table | New Table | FEEDBACK_SUBMISSION_PROPERTY_HISTORY | |||
FEEDBACK_SUBMISSION_TICKET | |||||
table | New Table | FEEDBACK_SUBMISSION_TICKET |
Jira
We have added a new table, FIELD_PROJECT
, with the following columns:
field_id
project_id
Perform a resync to fetch the historical data of the new table and columns.
We are gradually rolling out these changes to all existing connectors. These changes are available only for Jira Cloud instances.
NOTE: You must grant Fivetran the
Administer Jira
global permission to fetch the custom-fields project's mapping data.
Jira Align
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
USERS_TEAM | |||||
column | Primary Key Change | user_id | user_id 🔑 | Added to primary key. | |
USERS_TIME_TRACK_ROLE | |||||
column | Deprecated Column | task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | user_id 🔑 | New primary key. |
Kustomer
We have added a new column, open_status_at
, to the CONVERSATION_HISTORY
table.
We have added the following new tables:
BUSINESS_HOLIDAY
BUSINESS_SCHEDULE
BUSINESS_SCHEDULE_HOUR
We are gradually rolling out this change to all existing connectors.
Mambu
LOAN_TRANSACTION
table.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACCOUNTING_REPORT_ITEM | |||||
column | Primary Key Change | reportkey | encoded_key 🔑 | Added to primary key. | |
DEPOSIT_ACCOUNT_AUTHORIZATION_HOLD | |||||
column | Rename Column | currency_code | balance_currency_code | ||
LOAN_TRANSACTION | |||||
column | New Column | custom_* |
Navan
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BOOKING_SEGMENT | |||||
column | New Column | hotel_super_chain |
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BOOKING | |||||
column | Primary Key Change | id 🔑 | booking_id | No longer primary key | |
column | Rename Column | id 🔑 | booking_id | Renamed 'id' to 'booking_id' in the table. The column was previously a primary key, but it is no longer set as such. | |
column | Primary Key Change | uuid | uuid 🔑 | Added to primary key | |
BOOKING_BILLABLE_ENTITY | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_BOOKER | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_COST_CENTER | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_CREDIT | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_CUSTOM_FIELD | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_DEPARTMENT | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_DESTINATION | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_ETICKET | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_ORIGIN | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_OUT_OF_POLICY_VIOLATION_TYPE | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_PASSENGER | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_REGION | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_RESHOPPING | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_SEAT | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_SEGMENT | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Deprecated Column | hotel_super_chain | |||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_SUBSIDIARY | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
BOOKING_TRIP_UUID | |||||
column | Deprecated Column | booking_id 🔑 | No longer primary key | ||
column | Primary Key Change | booking_uuid 🔑 | New primary key | ||
TRANSACTION | |||||
column | Deprecated Column | booking_id | |||
column | New Column | navan_booking_id |
Ordway
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SUBSCRIPTION | |||||
column | Primary Key Change | version | version 🔑 | Added to primary key. | |
SUBSCRIPTION_CUSTOM_FIELD | |||||
column | Primary Key Change | subscription_version 🔑 | New primary key. | ||
SUBSCRIPTION_PLAN | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
column | Primary Key Change | subscription_version 🔑 | New primary key. | ||
SUBSCRIPTION_PLAN_CUSTOM_FIELD | |||||
column | Primary Key Change | subscription_plan_id 🔑 | subscription_plan_id | No longer primary key. | |
column | Deprecated Column | subscription_plan_subscription_id 🔑 | No longer primary key. | ||
column | Primary Key Change | subscription_id 🔑 | New primary key. | ||
column | Primary Key Change | subscription_plan_index 🔑 | New primary key. | ||
column | Primary Key Change | subscription_version 🔑 | New primary key. | ||
SUBSCRIPTION_PLAN_TRANSACTION_POSTING_ENTRIES | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | New Column | subscription_plan_index | |||
column | New Column | subscription_version |
Productboard
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FEATURE | |||||
column | New Column | parent_id |
Ramp
null
primary key issue.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
TRANSACTION_POLICY_VIOLATION | |||||
column | Primary Key Change | id 🔑 | No longer primary key | ||
column | Primary Key Change | index 🔑 | Added to primary key |
SolarWinds Service Desk
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
INCIDENT | |||||
column | New Column | customer_satisfaction_response | |||
column | New Column | is_customer_satisfied | |||
column | New Column | resolution | |||
column | New Column | resolution_type | |||
column | New Column | total_time_spent | |||
INCIDENT_CUSTOM_FIELD_VALUE | |||||
table | New Table | INCIDENT_CUSTOM_FIELD_VALUE | |||
INCIDENT_REQUEST_VARIABLE | |||||
table | New Table | INCIDENT_REQUEST_VARIABLE | |||
INCIDENT_STATISTIC | |||||
table | New Table | INCIDENT_STATISTIC |
StackAdapt
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
AUDIENCE_FILE | |||||
table | New Table | AUDIENCE_FILE | |||
AUDIENCE_FILE_GEO_TARGETS_COMBINED | |||||
table | Deprecated Table | AUDIENCE_FILE_GEO_TARGETS_COMBINED | Data now available in the AUDIENCE_FILE and AUDIENCE_GEO_TARGETS_FILE tables. | ||
AUDIENCE_GEO_TARGETS_FILE | |||||
table | New Table | AUDIENCE_GEO_TARGETS_FILE | |||
CREATIVE_DISPLAY_JS | |||||
column | Deprecated Column | _fivetran_id 🔑 | No longer primary key. | ||
column | Primary Key Change | creative_id | creative_id 🔑 | Added to primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
CREATIVE_INPUT_AUDIO_VIDEO | |||||
table | Deprecated Table | CREATIVE_INPUT_AUDIO_VIDEO | Data now available in the CREATIVE_INPUT_DATA_AUDIO and CREATIVE_INPUT_DATA_VIDEO tables. | ||
CREATIVE_INPUT_DATA_AUDIO | |||||
table | New Table | CREATIVE_INPUT_DATA_AUDIO | |||
CREATIVE_INPUT_DATA_VIDEO | |||||
table | New Table | CREATIVE_INPUT_DATA_VIDEO | |||
CREATIVE_VAST_TRACKER | |||||
column | Deprecated Column | _fivetran_id 🔑 | No longer primary key. | ||
column | Primary Key Change | creative_id | creative_id 🔑 | Added to primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
INSIGHT_CAMPAIGN_AUDIENCE | |||||
table | New Table | INSIGHT_CAMPAIGN_AUDIENCE | |||
INSIGHT_CAMPAIGN_AUDIENCE_AB | |||||
table | New Table | INSIGHT_CAMPAIGN_AUDIENCE_AB | |||
INSIGHT_CAMPAIGN_BID_FACTOR | |||||
table | New Table | INSIGHT_CAMPAIGN_BID_FACTOR | |||
INSIGHT_CAMPAIGN_CATEGORY | |||||
table | New Table | INSIGHT_CAMPAIGN_CATEGORY | |||
INSIGHT_CAMPAIGN_CREATIVE_TACTIC | |||||
table | New Table | INSIGHT_CAMPAIGN_CREATIVE_TACTIC | |||
INSIGHT_CAMPAIGN_DEAL | |||||
table | New Table | INSIGHT_CAMPAIGN_DEAL | |||
INSIGHT_CAMPAIGN_DEMOGRAPHIC | |||||
table | New Table | INSIGHT_CAMPAIGN_DEMOGRAPHIC | |||
INSIGHT_CAMPAIGN_DEVICE | |||||
table | New Table | INSIGHT_CAMPAIGN_DEVICE | |||
INSIGHT_CAMPAIGN_GEO | |||||
table | New Table | INSIGHT_CAMPAIGN_GEO | |||
INSIGHT_CAMPAIGN_GROUP_AUDIENCE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_AUDIENCE | |||
INSIGHT_CAMPAIGN_GROUP_AUDIENCE_AB | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_AUDIENCE_AB | |||
INSIGHT_CAMPAIGN_GROUP_BID_FACTOR | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_BID_FACTOR | |||
INSIGHT_CAMPAIGN_GROUP_CATEGORY | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_CATEGORY | |||
INSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTIC | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTIC | |||
INSIGHT_CAMPAIGN_GROUP_DEAL | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEAL | |||
INSIGHT_CAMPAIGN_GROUP_DEMOGRAPHIC | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEMOGRAPHIC | |||
INSIGHT_CAMPAIGN_GROUP_DEVICE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEVICE | |||
INSIGHT_CAMPAIGN_GROUP_GEO | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_GEO | |||
INSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENT | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENT | |||
INSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCE | |||
INSIGHT_CAMPAIGN_RETARGETING_SEGMENT | |||||
table | New Table | INSIGHT_CAMPAIGN_RETARGETING_SEGMENT | |||
INSIGHT_CAMPAIGN_SUPPLY_SOURCE | |||||
table | New Table | INSIGHT_CAMPAIGN_SUPPLY_SOURCE | |||
STATS_DELIVERY | |||||
table | Deprecated Table | STATS_DELIVERY | Data now available in the STATS_DELIVERY_ADVERTISER , STATS_DELIVERY_NATIVE_AD , STATS_DELIVERY_CONVERSION_TRACKER , STATS_DELIVERY_CAMPAIGN_GROUP and STATS_DELIVERY_CAMPAIGN tables. | ||
STATS_DELIVERY_ADVERTISER | |||||
table | New Table | STATS_DELIVERY_ADVERTISER | |||
STATS_DELIVERY_CAMPAIGN | |||||
table | New Table | STATS_DELIVERY_CAMPAIGN | |||
STATS_DELIVERY_CAMPAIGN_GROUP | |||||
table | New Table | STATS_DELIVERY_CAMPAIGN_GROUP | |||
STATS_DELIVERY_CONVERSION_TRACKER | |||||
table | New Table | STATS_DELIVERY_CONVERSION_TRACKER | |||
STATS_DELIVERY_NATIVE_AD | |||||
table | New Table | STATS_DELIVERY_NATIVE_AD | |||
STATS_INSIGHT | |||||
table | Deprecated Table | STATS_INSIGHT | Data now available in the INSIGHT_CAMPAIGN_* tables. |
StarRez
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
APPLICATION_STATUS | |||||
table | New Table | APPLICATION_STATUS | |||
ENTRY_APPLICATION | |||||
table | New Table | ENTRY_APPLICATION | |||
ENTRY_APPLICATION_CUSTOM_FIELD | |||||
table | New Table | ENTRY_APPLICATION_CUSTOM_FIELD | |||
ROOM_CONFIGURATION_TERM_TYPE | |||||
table | New Table | ROOM_CONFIGURATION_TERM_TYPE | |||
ROOM_SPACE_CLOSED | |||||
table | New Table | ROOM_SPACE_CLOSED | |||
ROOM_SPACE_CLOSED_REASON_ENUM | |||||
table | New Table | ROOM_SPACE_CLOSED_REASON_ENUM | |||
ROOM_SPACE_DETAIL | |||||
table | New Table | ROOM_SPACE_DETAIL | |||
TERM_TYPE | |||||
table | New Table | TERM_TYPE |
TikTok Ads
We added a buying_types
filter to our calls to retrieve all possible buying_types entities {AUCTION, RESERVATION_RF, RESERVATION_TOP_VIEW} for the following tables:
- AD_HISTORY
- ADGROUP_HISTORY
- CAMPAIGN_HISTORY
We added the buying_type
field to all three tables (AD_HISTORY, ADGROUP_HISTORY, CAMPAIGN_HISTORY) to reflect the buying_types
filter value used in our data requests.
We added the following fields to the AD_HISTORY table (see the TikTok documentation for details):
aigc_disclosure_type
avatar_icon_web_uri
brand_safety_postbid_partner
brand_safety_vast_url
branded_content_disabled
call_to_action_id
card_id
carousel_image_index
cpp_url
creative_type
dark_post_status
deeplink_type
dynamic_destination
dynamic_format
fallback_type
identity_authorized_bc_id
identity_id
identity_type
item_duet_status
item_stitch_status
music_id
optimization_event
page_id
phone_number
phone_region_calling_code
phone_region_code
product_set_id
product_specific_type
promotional_music_disabled
shopping_ads_deeplink_type
shopping_ads_fallback_type
shopping_ads_video_package_id
tiktok_page_category
tracking_app_id
tracking_pixel_id
vast_moat_enabled
vertical_video_strategy
viewability_postbid_partner
viewability_vast_url
We added the following fields to the ADGROUP_HISTORY table (see the TikTok documentation for details):
adgroup_app_profile_page_state
attribution_event_count
bid_display_mode
brand_safety_partner
brand_safety_type
click_attribution_window
comment_disabled
cpm
delivery_mode
discount_amount
discount_percentage
discount_type
engaged_view_attribution_window
feed_type
identity_authorized_bc_id
identity_id
identity_type
ios14_quota_type
ios14_targeting
is_smart_performance_campaign
next_day_retention
pre_discount_budget
pre_discount_cpm
predict_impression
product_source
promotion_target_type
promotion_type
promotion_website_type
purchased_impression
purchased_reach
rf_estimated_cpr
rf_estimated_frequency
rf_purchased_type
roas_bid
saved_audience_id
scheduled_budget
search_result_enabled
share_disabled
shopping_ads_retargeting_actions_days
shopping_ads_retargeting_custom_audience_relation
shopping_ads_retargeting_type
shopping_ads_type
smart_audience_enabled
smart_interest_behavior_enabled
spending_power
split_test_group_id
split_test_status
store_authorized_bc_id
store_id
String> tiktok_subplacements
vbo_window
vertical_sensitivity_id
video_download_disabled
view_attribution_window
We added the following fields to the CAMPAIGN_HISTORY table (see the TikTok documentation for details):
app_id
app_promotion_type
bid_type
budget_optimize_on
campaign_app_profile_page_state
campaign_product_source
deep_bid_type
is_advanced_dedicated_campaign
is_search_campaign
is_smart_performance_campaign
objective
optimization_goal
postback_window_mode
rf_campaign_type
roas_bid
rta_id
rta_product_selection_enabled
Workable
null
primary key issue.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CANDIDATE_SOCIAL_PROFILE | |||||
column | Primary Key Change | username 🔑 | username | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. |
Improvements
Aha!
We now incrementally sync the RELEASE
table.
Assembled
The Assembled connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure Blob Storage
The Azure Blob Storage connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure DevOps
The Azure DevOps connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure Event Hubs
The Azure Event Hubs connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure SQL Database
Azure SQL Database connectors configured for Hybrid Deployment now support Microsoft Entra ID (formerly Azure Active Directory) authentication.
Collibra
We have updated our sync strategy. We now re-import the ATTRIBUTE
table once a month and no longer re-import the JOB
table. Previously, we re-imported these two tables weekly.
commercetools
The commercetools connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Coupa
We have updated our sync strategy for the COMMODITY
table. We now sync the table data using the commodities
API endpoint.
Delighted
The Delighted connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
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.
Gainsight Customer Success
The Gainsight Customer Success connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Google Ads
The Google Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Google Search Ads 360
We've added the following metadata tables to provide a more comprehensive schema:
ad
ad_group
bidding_strategy
campaign
customer
We've added the following prebuilt reports to our Google Search Ads 360 connector:
ad_conversion_action_and_device_report
ad_device_report
ad_group_conversion_action_and_device_report
ad_group_device_report
ad_group_report
campaign_conversion_action_and_device_report
campaign_device_report
campaign_report
customer_conversion_action_and_device_report
customer_device_report
customer_report
keyword_conversion_action_and_device_report
keyword_device_report
keyword_report
Prebuilt reports are common report configurations that make it easier to get insight into your data without needing to create custom reports. For more details about this update, please refer to the Google Search Ads 360 ERD.
HubSpot
We have added support for HubSpot's Feedback Submissions API to sync the feedback submissions data in your HubSpot account. We are gradually rolling out this improvement to all existing connectors.
Impact
The Impact connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Ironclad
The Ironclad connector now supports OAuth 2.0 authentication. For more information, see our setup instructions.
Lever
The Lever connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Maxio SaaSOptics
We now re-import the INVOICE
table once a week to capture updates and deletes.
MongoDB
If your MongoDB server version is less than 4.0, you must upgrade to a supported version by March 1, 2025. Otherwise, the MongoDB drivers will no longer be compatible with your server version. Learn more in MongoDB's MongoDB's software lifecycle schedules documentation.
NetSuite SuiteAnalytics
The NetSuite SuiteAnalytics connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
OneLake
We have introduced new fields in the setup form: Workspace GUID and Lakehouse GUID.
For new connectors, these fields now replace the existing Workspace Name and Lakehouse Name fields.
For existing connectors, the new GUID fields have been added alongside the current Workspace Name and Lakehouse Name fields. We will sunset the original fields in a future update. Ensure that you update the new GUID fields before this change.
PayPal
The PayPal connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
PostgreSQL
We now support syncing the "oid" data type as LONG. See all supported data types in our PostgreSQL documentation.
PostgreSQL destination
All PostgreSQL implementations now support the Hybrid Deployment model. We are gradually rolling out this feature to all existing destinations. For more information, see the individual destination setup guides.
Recurly
The Recurly connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
S3
We have made the following updates to the 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
- 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
For more information, see our setup instructions. We are gradually rolling out these changes to all existing connectors.
Salesforce
For roll-up summary fields that reference formula fields, we now round formula field values to their configured scale before calculating the roll-up summary result, aligning with Salesforce behavior. This improvement applies to BigQuery, Databricks, PostgreSQL, Redshift, and Snowflake destinations. For other destinations, we calculate the roll-up summary result without rounding.
We are gradually rolling out this change to all existing connectors.
ServiceNow
We have added support for Okta authentication. We will be gradually rolling out this feature to existing connections.
SFTP
We have made the following updates to the 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
For more information, see our setup instructions and REST API configuration. We are gradually rolling out these changes to all existing connectors.
SharePoint
The SharePoint connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Shopify
We have fixed a data integrity issue in the currency
column of the CUSTOMER
table. If you observe null
values for the column in your destination, trigger a re-sync of the CUSTOMER
table.
Slack
The Slack connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Spotify Ads
Our Spotify Ads connector is now generally available.
Read our Spotify Ads connector documentation.
Sprout Social
The Sprout Social connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Talkdesk
The Talkdesk connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Uservoice
The Uservoice connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Xero
We have improved the decimal precision of the currency_rate
columns and now support a scale of 10 for decimal values in the currency_rate
columns of the following tables:
BANK_TRANSACTION
BANK_TRANSFER
CREDIT_NOTE
INVOICE
OVERPAYMENT
PAYMENT
PREPAYMENT
Previously, we supported a scale of 6 for decimal values and rounded the values to six decimal places.
Yahoo Search Ads Yahoo Japan
We have upgraded our Yahoo Search Ads Yahoo Japan connector to Search Ads API v15 from v12.
Zendesk Chat
The Zendesk Chat connector now supports the Hybrid Deployment model. For more information, see our setup instructions.