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 to fivetran 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:

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.

Overview page

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

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

We are making these schema changes to improve schema usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

4 total changes • 1 possible breaking changes

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

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

We are making these changes to improve schema usability.

5 total changes • 0 possible breaking changes

Table/column	Change type	New name
`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

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

We are making this schema change to adhere to standard naming conventions.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`ITEM`
column	Rename Column		`percent`	`percents`

Cin7 Core

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

We are making these schema changes to avoid data integrity issue.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`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

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

We have made this schema change to prevent duplicate fields in the same table.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`ORDER_SHIPMENT_SHIPPED_LINE_BUNDLE_LINE`
column	Rename Column		`item_number` 🔑	`order_shipment_shipped_line_item_number`

Expensify

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

This schema change is required due to a null primary key issue.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`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

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

We are making these schema changes to introduce feature enhancements.

3 total changes • 0 possible breaking changes

Table/column	Change type	New name
`CHANGEOVER_STOP`
table	New Table	`CHANGEOVER_STOP`
`OEE`
table	New Table	`OEE`
`PRODUCT`
table	New Table	`PRODUCT`

Gladly

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

We have made these schema changes to improve schema usability.

20 total changes • 0 possible breaking changes

Table/column	Change type	New name
`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

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

4 total changes • 0 possible breaking changes

Table/column	Change type	New name
`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

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

This schema change is required to resolve data intigrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 3 possible breaking changes

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

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

We've made these schema changes to improve schema usability and to introduce custom tables to the LOAN_TRANSACTION table.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 2 possible breaking changes

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

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

We are making these schema changes to improve schema usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`BOOKING_SEGMENT`
column	New Column			`hotel_super_chain`

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

We are making these schema changes to improve data retrieval and management.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

40 total changes • 39 possible breaking changes

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

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

These schema changes are required to resolve data integrity issues.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

13 total changes • 11 possible breaking changes

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

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

We are making these schema changes to improve schema usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`FEATURE`
column	New Column			`parent_id`

Ramp

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

We are making the following changes to resolve a null primary key issue.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	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

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

We've made the following schema changes to improve schema usability.

8 total changes • 0 possible breaking changes

Table/column	Change type	New name
`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

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

We are making these schema changes to more efficiently retrieve and manage data.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

41 total changes • 10 possible breaking changes

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

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

We have made these schema changes to improve schema usability.

8 total changes • 0 possible breaking changes

Table/column	Change type	New name
`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

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

This schema change is required due to a null primary key issue.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	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 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.

November 2024

Connector SDK

Fivetran Connector SDK

fivetran-connector-sdk PyPI package

fivetran-api-playground PyPI package

Lite Connectors

Hybrid Deployment support

Logs

Log event api_call removed

New Account Overview page

Transformations for dbt Core

Updated dbt Quickstart package

New connectors

Reltio

Schema changes

Affinity

Amazon Ads

Chameleon

ChargeDesk

Cin7 Core

Coupa

DCL Logistics

Expensify

Facebook Ads

Factbird

Gladly

Google Ads

HubSpot

Jira

Jira Align

Kustomer

Mambu

Navan

Ordway

Productboard

Ramp

SolarWinds Service Desk

StackAdapt

StarRez

TikTok Ads

Workable

Improvements

Aha!

Assembled

Azure Blob Storage

Azure DevOps

Azure SQL Database

Collibra

commercetools

Coupa

Delighted

Gainsight Customer Success

Google Ads

Google Search Ads 360

HubSpot

Impact

Ironclad

Lever

Maxio SaaSOptics

MongoDB

NetSuite SuiteAnalytics

OneLake

PayPal

PostgreSQL

PostgreSQL destination

Recurly

S3

Salesforce

ServiceNow

SFTP

SharePoint

Shopify

Slack

Spotify Ads

Sprout Social

Talkdesk

Uservoice

Xero

Yahoo Search Ads Yahoo Japan

Zendesk Chat

`fivetran-connector-sdk` PyPI package

`fivetran-api-playground` PyPI package

Log event `api_call` removed