September 2024
Hybrid Deployment
Our Hybrid Deployment model is now generally available.
For the complete list of connectors and destinations supporting this model, see our Hybrid Deployment documentation.
Lite Connectors
Lite connectors are now available for the following sources:
- Attio
- BillingPlatform
- Buildium
- Bazaarvoice
- Gmail
- myosh
- Okendo
- OnceHub
- Planhat
- RevenueCat
- RevOps
- RevX
- ShipNetwork
Table re-sync and table selection support
We have made the following improvements to our Lite connectors:
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.
Expand for list of supported connectors
- 15Five
- 360Learning
- 7shifts
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- Afterpay
- Aha!
- Aircall
- Amazon Attribution
- Anvyl
- Appcues
- Appfigures
- Attentive
- Aumni
- Auth0
- Awin
- Bizzabo
- Boostr
- Brave Ads
- Brevo
- Brex
- Brightcove
- Buildkite
- Buzzsprout
- CJ Commission Detail
- Calabrio
- Calendly
- CallRail
- Campaign Monitor
- Canny
- Care Quality Commission
- Castor EDC
- Chameleon
- ChargeDesk
- Chargebee Product Catalog 2.0
- ChartMogul
- Checkout.com
- Checkr
- Chorus
- ChurnZero
- Churnkey
- Cin7
- Cin7 core
- CircleCI
- Close
- Codefresh
- Collibra
- Column
- commercetools
- Copper
- Crossbeam
- crowd.dev
- Culture Amp
- Customer.io
- Cvent
- dbt Cloud
- DCL Logistics
- DSV
- Deputy
- Destini
- Dixa
- Docebo
- DoorLoop
- Drift
- Duoplane
- EZOfficeInventory
- EasyPost
- eBay
- Electronic Tenant Solutions
- Employment Hero
- Eventsforce
- Everhour
- Expensify
- Factbird
- Factorial
- FireHydrant
- Fone Dynamics
- Forj Community
- Fountain
- Freightview
- FreshBooks
- Freshchat
- Freshdesk Contact Center
- Friendbuy
- FullStory
- GRIN
- Gem
- Genesys
- GitLab
- Gladly
- GlobalMeet
- Google Business Profile
- Google Calendar
- Gorgias
- Guru
- HappyFox
- Harvest
- Helpshift
- HiBob
- Impact
- incident.io
- Insightly
- Integral Ad Science
- Integrate
- IronSource
- Ironclad
- Ivanti
- Jotform
- JustCall
- Kandji
- Kevel
- KeyPay
- Khoros Care
- Kisi
- Kissmetrics
- Klarna
- LaunchDarkly
- LearnUpon
- Lemlist
- Lessonly
- Liftoff
- Linear
- LinkSquares
- LiveChat Partner
- Lob
- Looker
- Loopio
- Luma
- MNTN
- Mambu
- Maxio Chargify
- Maxio SaaSOptics
- Medallia Agile Research
- Megaphone
- Mention
- Microsoft Entra ID
- Mode
- Moloco
- Monday.com
- Mux
- Namely
- Navan
- ON24
- Ometria
- Open Data DC
- Open Exchange Rates
- Opsgenie
- Oracle Moat Analytics
- Orbit
- Ordway
- Ortto
- PagerDuty
- Papershift
- PartnerStack Vendor
- Partnerize
- Paychex
- Persona
- Personio
- Picqer
- Pingdom
- Pinpoint
- Pinterest Organic
- Pivotal Tracker
- Piwik PRO
- Playvox
- PostHog
- Postmark
- Prive
- Productboard
- Productive
- Proofpoint Security Awareness
- Qualaroo
- Quora Ads
- REVIEWS.io
- Rakuten Advertising
- Ramp
- Rarible
- ReBound Returns
- ReferralHero
- Reply.io
- Resource Management by Smartsheet
- RevX
- Ricochet360
- Ringover
- Rippling
- Rithum
- Rocketlane
- SCORM
- SafetyCulture
- Salsify
- Security Journey
- ServiceTitan
- Sharetribe
- ShipHero
- ShipStation
- Shopware
- Short.io
- Shortcut
- Sigma Computing
- Simplesat
- SkillsTX
- SkuVault
- Smadex
- SmartHR
- SmartRecruiters
- Smartwaiver
- SolarWinds Service Desk
- SonarQube
- SparkPost
- Split
- Sprout Social
- Squarespace
- Standard Metrics
- StarRez
- Statsig
- Statuspage
- Stylight
- Subscript
- Survicate
- Swoogo
- Tableau
- Talkdesk
- Talkwalker
- Teads
- Teamtailor
- Teamwork
- Tempo
- TestRail
- Thinkific
- Ticket Tailor
- Transcend
- Trelica
- Trello
- Tymeshift
- UKG Pro
- Udemy Business
- UpPromote
- Upland Software
- VTS
- Veeqo
- Vitally
- Vonage Contact Center
- Webconnex
- When I Work
- Wherefour
- WooCommerce
- WordPress
- WorkRamp
- Wrike
- Xandr
- Xray
- Yahoo Search Ads on Yahoo Japan
- YouGov Sport
- Younium
- Zenefits
- Zoho Books
- Zoho Campaigns
- Zoho Desk
- Zoom
Expand for list of non-supported connectors
- Affinity
- Algolia
- Attio
- Autodesk BIM 360
- Bitly
- Ceridian Dayforce
- Chargebee Product 1.0
- Clari
- ClickUp
- Concord
- Confluence
- Drata
- Drip
- Dropbox Sign
- Eventbrite
- Flexport
- Float
- FreshTeam
- GetFeedback
- Hopin
- iLevel
- Jira Align
- Katana
- Lattice
- Loop
- Mailgun
- Notion
- PowerReviews Enterprise
- RTB House
- RetailNext
- Retently
- Revel Systems
- Rollbar
- Rootly
- Sage HR
- Samsara
- Simplecast
- Skilljar
- StackAdapt
- Toggl Track
- Trisolute
- VWO
- Workable
Transformations for dbt Core
ClickHouse dbt adapter support
We now support the ClickHouse destination for scheduled in code and scheduled in Fivetran transformations by default for all supported dbt Core versions.
* 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.
Schema changes
Amazon Ads
We have added a new prebuilt report, CAMPAIGN_PLACEMENT_REPORT_INCOMING
.
Until December 5, 2024, all usage for this report will count towards free MAR.
Amazon Selling Partner
We have added the following new tables to support the Catalog module for Amazon vendor accounts:
CATALOG
ITEM_CLASSIFICATION_SALES_RANK
ITEM_CONTRIBUTOR
ITEM_DIMENSION
ITEM_DISPLAY_GROUP_SALES_RANK
ITEM_IDENTIFIER
ITEM_IMAGE
ITEM_PRODUCT_TYPE
ITEM_RELATIONSHIP
ITEM_SUMMARY
ITEM_VARIATION_THEME
ITEM_VENDOR_DETAILS
We have made the following schema changes for all Amazon Selling Partner connectors:
- We have changed the primary key of the
VENDOR_RETAIL_PROCUREMENT_SHIPMENT
table and its child tables. The new composite key is a combination of thevendor_shipment_identifier
andtransaction_date
columns. If any of the two columns are NULL, we will skip these tables to avoid sync failures. - We have changed the primary key of the
CONTAINER_PACKED_ITEM
table. The new composite key is a combination of theindex
,container_sequence_number
,container_type
,transaction_date
, andvendor_shipment_identifier
columns to avoid data integrity issues. - We have changed the primary key of the
SHIPMENT_STATUS_DETAIL
table. The new composite key is a combination of theindex
,transaction_date
, andshipment_status
columns. - We will skip the records of the
VENDOR_SHIPPING_ORDER
if any of the columnspurchase_order_date
orpurchase_order_number
is null.
Appfigures
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SDK_TAG | |||||
column | Rename Column | tag 🔑 | tags |
Attentive
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CUSTOM_ATTRIBUTE | |||||
column | Rename Column | timestamp | timestamps | ||
EMAIL_MESSAGE_LINK_CLICK | |||||
column | Rename Column | timestamp | timestamps | ||
EMAIL_OPENED | |||||
column | Rename Column | timestamp | timestamps | ||
EMAIL_SENT | |||||
column | Rename Column | timestamp | timestamps | ||
SMS_EMAIL_SUBSCRIBED | |||||
column | Rename Column | timestamp | timestamps | ||
SMS_EMAIL_UNSUBSCRIBED | |||||
column | Rename Column | timestamp | timestamps | ||
SMS_INBOUND | |||||
column | Rename Column | timestamp | timestamps | ||
SMS_MESSAGE_LINK_CLICK | |||||
column | Rename Column | timestamp | timestamps | ||
SMS_SENT | |||||
column | Rename Column | timestamp | timestamps |
Care Quality Commission
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
LOCATION_RELATIONSHIP | |||||
column | Primary Key Change | related_location_id 🔑 | related_location_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. |
Checkr
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
REPORT | |||||
column | Deprecated Column | geos | |||
column | New Column | federal_district_civil_search_ids | |||
column | New Column | federal_district_criminal_search_ids | |||
column | New Column | skipped_screening_ids | |||
REPORT_COUNTY_CRIMINAL_SEARCH | |||||
column | New Column | assessment | |||
REPORT_FEDERAL_CRIMINAL_SEARCH | |||||
table | New Table | REPORT_FEDERAL_CRIMINAL_SEARCH | |||
REPORT_GEO | |||||
table | New Table | REPORT_GEO | |||
REPORT_GLOBAL_WATCHLIST_SEARCH | |||||
column | New Column | assessment | |||
REPORT_INTERNATIONAL_ADVERSE_MEDIA_SEARCH | |||||
table | New Table | REPORT_INTERNATIONAL_ADVERSE_MEDIA_SEARCH | |||
REPORT_INTERNATIONAL_CRIMINAL_SEARCH | |||||
table | New Table | REPORT_INTERNATIONAL_CRIMINAL_SEARCH | |||
REPORT_INTERNATIONAL_EDUCATION_VERIFICATION | |||||
table | New Table | REPORT_INTERNATIONAL_EDUCATION_VERIFICATION | |||
REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD | |||||
table | New Table | REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD | |||
REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD_EVENT | |||||
table | New Table | REPORT_INTERNATIONAL_EDUCATION_VERIFICATION_RECORD_EVENT | |||
REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION | |||||
table | New Table | REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION | |||
REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_HISTORY | |||||
table | New Table | REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_HISTORY | |||
REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_RECORD | |||||
table | New Table | REPORT_INTERNATIONAL_EMPLOYMENT_VERIFICATION_RECORD | |||
REPORT_INTERNATIONAL_GLOBAL_WATCHLIST_SEARCH | |||||
table | New Table | REPORT_INTERNATIONAL_GLOBAL_WATCHLIST_SEARCH | |||
REPORT_INTERNATIONAL_IDENTITY_DOCUMENT_VALIDATION | |||||
table | New Table | REPORT_INTERNATIONAL_IDENTITY_DOCUMENT_VALIDATION | |||
REPORT_INTERNATIONAL_MOTOR_VEHICLE | |||||
table | New Table | REPORT_INTERNATIONAL_MOTOR_VEHICLE | |||
REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE | |||||
table | New Table | REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE | |||
REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_INFO | |||||
table | New Table | REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_INFO | |||
REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_VIOLATION | |||||
table | New Table | REPORT_INTERNATIONAL_MOTOR_VEHICLE_LICENSE_VIOLATION | |||
REPORT_STATE_CRIMINAL_SEARCH | |||||
column | New Column | assessment | |||
REPORT_TERRORIST_WATCHLIST_SEARCH | |||||
column | New Column | assessment |
Cin7
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BOM_MASTER | |||||
table | New Table | BOM_MASTER | |||
BOM_MASTER_COMPONENT | |||||
table | New Table | BOM_MASTER_COMPONENT |
Cin7 Core
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SALE_CREDIT_NOTE_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_CREDIT_NOTE_RESTOCK | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_FULLFILLMENT_PACK_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_FULLFILLMENT_PICK_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_INVENTORY_MOVEMENT | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_INVOICE_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_ORDER_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
SALE_QUOTE_LINE | |||||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | index 🔑 | New primary key. |
Close
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EMAIL_ACTIVITY | |||||
column | Rename Column | references | reference | ||
LEAD | |||||
column | Rename Column | localtime | local_time | ||
ROLE | |||||
column | Rename Column | permissions | permission |
Collibra
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ASSET | |||||
column | Rename Column | system | is_system | ||
ASSET_TYPE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_ARTICULATION_RULE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE_ARTICULATION_RULE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE_CHARACTERISTIC_TYPE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_ATTRIBUTE_TYPE | |||||
column | Rename Column | system | is_system | ||
ASSIGNMENT_LEG_TYPE | |||||
column | Rename Column | system | is_system | ||
ATTACHMENT | |||||
column | Rename Column | system | is_system | ||
ATTRIBUTE | |||||
column | Rename Column | system | is_system | ||
ATTRIBUTE_TYPE | |||||
column | Rename Column | system | is_system | ||
COMMENT | |||||
column | Rename Column | system | is_system | ||
COMMUNITY | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION_ATTRIBUTE | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION_LEG | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE_ATTRIBUTE_TYPE | |||||
column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE_LEG_TYPE | |||||
column | Rename Column | system | is_system | ||
DATA_QUALITY_METRIC | |||||
column | Rename Column | system | is_system | ||
DATA_QUALITY_RULE | |||||
column | Rename Column | system | is_system | ||
DOMAIN | |||||
column | Rename Column | system | is_system | ||
DOMAIN_TYPE | |||||
column | Rename Column | system | is_system | ||
ISSUE | |||||
column | Rename Column | system | is_system | ||
JOB | |||||
column | Rename Column | system | is_system | ||
MAPPING | |||||
column | Rename Column | system | is_system | ||
RATING | |||||
column | Rename Column | system | is_system | ||
RELATION | |||||
column | Rename Column | system | is_system | ||
RELATION_TYPE | |||||
column | Rename Column | system | is_system | ||
RESPONSIBILITY | |||||
column | Rename Column | system | is_system | ||
ROLE | |||||
column | Rename Column | system | is_system | ||
SCOPE | |||||
column | Rename Column | system | is_system | ||
SCOPE_COMMUNITY | |||||
column | Primary Key Change | community_id 🔑 | Added to primary key. | ||
SCOPE_DOMAIN | |||||
column | Primary Key Change | domain_id 🔑 | Added to primary key. | ||
SEARCH_VIEW_AGGREGATION | |||||
column | Rename Column | limit | limits | ||
USERS | |||||
column | Rename Column | language | languages |
Coupa
We have added the expense_line_id
column as a part of the composite primary key in the EXPENSE_ATTENDEE
table.
Eventbrite
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CODE_COMPONENT | |||||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
STRUCTURE_CONTENT | |||||
table | Deprecated Table | STRUCTURE_CONTENT | Data now available in the STRUCTURE_CONTENT_WORKING and STRUCTURE_CONTENT_PUBLISHED tables. | ||
STRUCTURE_CONTENT_MODULE | |||||
table | Deprecated Table | STRUCTURE_CONTENT_MODULE | Data now available in the STRUCTURE_CONTENT_WORKING_MODULE and STRUCTURE_CONTENT_PUBLISHED_MODULE tables. | ||
STRUCTURE_CONTENT_PUBLISHED | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_PUBLISHED_MODULE | |||||
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB | |||||
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB_SLOT | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | status | |||
column | Primary Key Change | widget_tab_name 🔑 | New primary key. | ||
STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB_SLOT_HOST | |||||
column | Deprecated Column | status | |||
column | Primary Key Change | widget_tab_name 🔑 | New primary key. | ||
STRUCTURE_CONTENT_WIDGET | |||||
table | Deprecated Table | STRUCTURE_CONTENT_WIDGET | Data now available in the STRUCTURE_CONTENT_WORKING_WIDGET_TAB and STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB tables. | ||
STRUCTURE_CONTENT_WIDGET_TAB | |||||
table | Deprecated Table | STRUCTURE_CONTENT_WIDGET_TAB | Data now available in the STRUCTURE_CONTENT_WORKING_WIDGET_TAB and STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB tables. | ||
STRUCTURE_CONTENT_WIDGET_TAB_SLOT | |||||
table | Deprecated Table | STRUCTURE_CONTENT_WIDGET_TAB_SLOT | Data now available in the STRUCTURE_CONTENT_WORKING_WIDGET_TAB_SLOT and STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB_SLOT tables. | ||
STRUCTURE_CONTENT_WIDGET_TAB_SLOT_HOST | |||||
table | Deprecated Table | STRUCTURE_CONTENT_WIDGET_TAB_SLOT_HOST | Data now available in the STRUCTURE_CONTENT_WORKING_WIDGET_TAB_SLOT_HOST and STRUCTURE_CONTENT_PUBLISHED_WIDGET_TAB_SLOT_HOST tables. | ||
STRUCTURE_CONTENT_WORKING | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_WORKING_MODULE | |||||
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_WORKING_WIDGET_TAB | |||||
column | Deprecated Column | status | |||
STRUCTURE_CONTENT_WORKING_WIDGET_TAB_SLOT | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | status | |||
column | Primary Key Change | widget_tab_name 🔑 | New primary key. | ||
STRUCTURE_CONTENT_WORKING_WIDGET_TAB_SLOT_HOST | |||||
column | Deprecated Column | status | |||
column | Primary Key Change | widget_tab_name 🔑 | New primary key. |
Facebook Ads
We have added a new prebuilt report, BASIC_AD_ACTION_VALUES
.
Float
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PHASE_TEAM | |||||
table | New Table | PHASE_TEAM | |||
PROJECT_PHASE_TEAM | |||||
table | Deprecated Table | PROJECT_PHASE_TEAM | Data now available in the PHASE_TEAM , and PROJECT_TEAM tables. | ||
PROJECT_TEAM | |||||
table | New Table | PROJECT_TEAM |
Google Ads
We've added new prebuilt reports with leads data:
LEAD_FORM_SUBMISSION_DATA
LOCAL_SERVICES_LEAD
LOCAL_SERVICES_LEAD_CONVERSATIONS
We are slowly rolling these reports out to all existing connectors.
NOTE: Syncing the
LEAD_FORM_SUBMISSION_DATA
report requires specific access permissions.
Also, we've added new prebuilt reports:
CLICK_STATS
LANDING_PAGE_STATS
SEARCH_KEYWORD_STATS
SEARCH_TERM_STATS
We are slowly rolling these reports out to all existing connectors.
Google Campaign Manager 360
Google Campaign Manager 360 now supports higher timeline granularity for reports.
We are gradually rolling out this feature to all existing connectors.
Guru
We now re-import the COLLECTION
table once a week to capture updates and deletes.
HubSpot
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CUSTOM_EVENT | |||||
table | New Table | CUSTOM_EVENT | |||
CUSTOM_EVENT_DEFINITION | |||||
table | New Table | CUSTOM_EVENT_DEFINITION | |||
CUSTOM_EVENT_DEFINITION_ASSOCIATION | |||||
table | New Table | CUSTOM_EVENT_DEFINITION_ASSOCIATION | |||
CUSTOM_EVENT_DEFINITION_PROPERTY | |||||
table | New Table | CUSTOM_EVENT_DEFINITION_PROPERTY | |||
CUSTOM_EVENT_DEFINITION_PROPERTY_OPTION | |||||
table | New Table | CUSTOM_EVENT_DEFINITION_PROPERTY_OPTION |
Intercom
We have added the following new columns to the CONVERSATION_HISTORY
table:
ai_agent_last_answer_type
ai_agent_participated
ai_agent_rating
ai_agent_rating_remark
ai_agent_resolution_state
ai_agent_source_title
ai_agent_source_type
We have added a new table, CONVERSATION_AI_AGENT_CONTENT_SOURCE
with following columns:
content_type
locale
title
url
If you want to sync the historical data you would need to do a resync.
We are gradually rolling out these changes all existing connectors.
Katana
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BATCH_TRANSACTION | |||||
table | Deprecated Table | BATCH_TRANSACTION | |||
CONFIG_TYPE | |||||
table | Deprecated Table | CONFIG_TYPE | |||
CONFIG_TYPE_VALUE | |||||
table | Deprecated Table | CONFIG_TYPE_VALUE | |||
CUSTOMER_ADDRESSES (new table name: CUSTOMER_ADDRESS) | |||||
table | Rename Table | CUSTOMER_ADDRESSES | CUSTOMER_ADDRESS | ||
MANUFACTURING_ORDER_BATCH_TRANSACTION | |||||
table | New Table | ||||
MANUFACTURING_ORDER_SERIAL_NUMBER | |||||
column | Primary Key Change | manufacturing_order_id | manufacturing_order_id 🔑 | Added to primary key | |
MANUFACTURING_ORDERING_RECIPE_BATCH_TRANSACTION | |||||
table | New Table | ||||
MATERIAL_CONFIG | |||||
table | New Table | ||||
MATERIAL_CONFIG_VALUE | |||||
table | New Table | ||||
MATERIAL_SUPPLIER_ITEM_CODE | |||||
column | Primary Key Change | material_id | material_id 🔑 | Added to primary key | |
MATERIAL_VARIANT | |||||
column | Primary Key Change | id 🔑 | variant_id 🔑 | New primary key | |
column | Primary Key Change | material_id | material_id 🔑 | Added to primary key | |
OUTSOURCE_PURCHASE_BATCH_TRANSACTION | |||||
table | New Table | ||||
PRODUCT_CONFIG | |||||
table | New Table | ||||
PRODUCT_CONFIG_VALUE | |||||
table | New Table | ||||
PRODUCT_VARIANT | |||||
column | Primary Key Change | id 🔑 | variant_id 🔑 | New primary key | |
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key | |
PURCHASE_ORDER_PURCHASE_ORDER_ROW | |||||
column | Primary Key Change | purchase_order_id | purchase_order_id 🔑 | Added to primary key | |
PURCHASE_ORDER_ROW_BATCH_TRANSACTION | |||||
table | New Table | ||||
SALES_ORDER_ROW_BATCH_TRANSACTION | |||||
table | New Table | ||||
SALES_ORDER_SALES_ORDER_ROW | |||||
column | Primary Key Change | sales_order_id | sales_order_id 🔑 | Added to primary key | |
STOCK_ADJUSMENT (new table name: STOCK_ADJUSTMENT) | |||||
table | Rename Table | STOCK_ADJUSMENT | STOCK_ADJUSTMENT | ||
STOCK_ADJUSMENT_ROW (new table name: STOCK_ADJUSTMENT_ROW) | |||||
table | Rename Table | STOCK_ADJUSMENT_ROW | STOCK_ADJUSTMENT_ROW | ||
STOCK_ADJUSTMENT_ROW | |||||
column | Primary Key Change | stock_adjustment_id | stock_adjustment_id 🔑 | Added to primary key | |
STOCK_ADJUSTMENT_ROW_BATCH_TRANSACTION | |||||
table | New Table | ||||
STOCK_TRANSFER_ROW_BATCH_TRANSACTION | |||||
table | New Table | ||||
VARIANT_CONFIG_ATTRIBUTE | |||||
column | Primary Key Change | variant_id | variant_id 🔑 | Added to primary key |
Marketo
We have added the following new columns to the EMAIL_TEMPLATE_HISTORY
table:
auto_copy_to_text
is_open_tracking_disabled
pre_header
Pendo
We have added the following new columns to the PAGE_HISTORY
table:
isCoreEvent
isSuggested
kind
To sync the historical data for these columns, contact Fivetran support.
Rarible
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACTIVITY | |||||
column | Rename Column | from | from_source | ||
COLLECTION_TAG | |||||
column | Rename Column | tag 🔑 | tags 🔑 | ||
ITEM_TAG | |||||
column | Rename Column | tag 🔑 | tags 🔑 |
RetailNext
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
DATAMINE_METRICS | |||||
table | Deprecated Table | DATAMINE_METRICS | Data now available in the DATAMINE_METRIC_LOCATION table. | ||
LOCATION | |||||
column | Deprecated Column | location_profile_id | |||
column | New Column | archive_date | |||
column | New Column | comp_start_date | |||
column | New Column | currency | |||
column | New Column | current_utc_offset | |||
column | New Column | name | |||
column | New Column | parent_id | |||
column | New Column | store_id | |||
column | New Column | street_address | |||
column | New Column | time_zone | |||
column | New Column | time_zone_abbrev | |||
LOCATION_PROFILE | |||||
table | Deprecated Table | LOCATION_PROFILE | Data now available in the LOCATION table. | ||
NETWORK_INTERFACE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | store_uuid | |||
column | New Column | camera_device_id | |||
USER_PROFILE_LOCATION | |||||
table | Deprecated Table | USER_PROFILE_LOCATION | Data now available in the LOCATION table. | ||
USERS_LOCATION | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Deprecated Column | type | |||
column | Primary Key Change | users_id | users_id 🔑 | Added to primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
VIDEO_CHANNEL | |||||
column | Deprecated Column | store_uuid | |||
column | Primary Key Change | camera_device_id 🔑 | New primary key. |
Rootly
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FORM_FIELD_SELECTION_OPTION | |||||
column | Deprecated Column | selected_option_id 🔑 | No longer primary key. | ||
column | Deprecated Column | user_id | |||
column | New Column | color | |||
column | New Column | created_at | |||
column | New Column | defaults | |||
column | New Column | form_field_id | |||
column | Primary Key Change | id 🔑 | New primary key. | ||
column | New Column | position | |||
column | New Column | updated_at | |||
column | New Column | value |
S3 Data Lake
To avoid naming conflicts with Iceberg's reserved field names, we now prefix the following column names with #
before writing them to the Iceberg tables in your destination:
_deleted
_file
_partition
_pos
_spec_id
file_path
pos
row
We will verify the existing column names in your destination and rename the columns with these reserved names. You may observe a sync delay when we rename your existing columns.
We are gradually rolling this change to all existing destinations.
Salesforce Marketing Cloud
We now sync the triggered_send_key
field to the ACTIVITY
table.
Shopify
We have added two new tables, COMPANY
and COMPANY_CONTACT
.
We are gradually rolling out this change to all existing connectors.
Shortcut
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
STORY_COMMIT | |||||
column | Rename Column | timestamp | timestamps |
Skilljar
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
COURSE | |||||
column | Deprecated Column | lesson_count | |||
column | Deprecated Column | required_lesson_count | |||
column | Deprecated Column | url | |||
column | New Column | enforce_sequential_navigation | |||
column | New Column | long_description_html | |||
column | New Column | short_description | |||
ENROLLMENT | |||||
table | Deprecated Table | ENROLLMENT | Data available in the PLAN_ENROLLMENT ,PUBLISHED_COURSE_ENROLLMENT , and PUBLISHED_PATH_ENROLLMENT tables. | ||
PLAN_ENROLLMENT | |||||
table | New Table | PLAN_ENROLLMENT | |||
PUBLISHED_COURSE | |||||
column | New Column | course_lesson_count | |||
column | New Column | course_required_lesson_count | |||
PUBLISHED_COURSE_ENROLLMENT | |||||
table | New Table | PUBLISHED_COURSE_ENROLLMENT | |||
PUBLISHED_PATH_ENROLLMENT | |||||
table | New Table | PUBLISHED_PATH_ENROLLMENT | |||
USERS_PUBLISHED_COURSE | |||||
column | New Column | course_lesson_count | |||
column | New Column | course_required_lesson_count |
SkuVault
null
primary key issue.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SHIPMENT | |||||
column | Primary Key Change | sale_id | sale_id 🔑 | Added to primary key. | |
column | Primary Key Change | tracking_number | tracking_number 🔑 | Added to primary key. | |
column | Primary Key Change | tracking_url 🔑 | No longer primary key. | ||
SHIPMENT_COST | |||||
column | Deprecated Column | shipment_tracking_url 🔑 | No longer primary key. | ||
column | New Column | shipment_sale_id | |||
column | New Column | shipment_tracking_number | |||
SHIPMENT_LANDED_COST | |||||
column | Deprecated Column | shipment_tracking_url 🔑 | No longer primary key. | ||
column | Primary Key Change | shipment_sale_id 🔑 | Added to primary key. | ||
column | Primary Key Change | shipment_tracking_number 🔑 | Added to primary key. | ||
SHIPMENT_PARCEL | |||||
column | Deprecated Column | tracking_url | |||
column | New Column | sale_id 🔑 | Added to primary key. | ||
column | New Column | tracking_number 🔑 | Added to primary key. |
Snyk
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
COLLECTION | |||||
table | New Table | COLLECTION | |||
DEPENDENCY | |||||
column | New Column | organization_id | |||
GROUP_MEMBER | |||||
table | New Table | GROUP_MEMBER | |||
GROUP_MEMBER_ORG | |||||
table | Deprecated Table | GROUP_MEMBER_ORG | |||
GROUP_ORGAINZATION | |||||
table | New Table | GROUP_ORGAINZATION | |||
GROUP_ROLE | |||||
table | New Table | GROUP_ROLE | |||
GROUP_TAG | |||||
table | New Table | GROUP_TAG | |||
ISSUE | |||||
column | Deprecated Column | cvss_score | |||
column | Deprecated Column | cvssv_3 | |||
column | Deprecated Column | disclosure_time | |||
column | Deprecated Column | exploit_maturity | |||
column | Deprecated Column | fixed_date | |||
column | Deprecated Column | introduced_date | |||
column | Deprecated Column | is_fixed | |||
column | Deprecated Column | is_ignored | |||
column | Deprecated Column | is_patchable | |||
column | Deprecated Column | is_patched | |||
column | Deprecated Column | is_pinnable | |||
column | Deprecated Column | is_upgradable | |||
column | Deprecated Column | issue_identifiers_osvdb | |||
column | Deprecated Column | jira_issue_url | |||
column | Deprecated Column | languages | |||
column | Deprecated Column | original_severity | |||
column | Deprecated Column | package | |||
column | Deprecated Column | package_manager | |||
column | Deprecated Column | patched_date | |||
column | Deprecated Column | priority_score | |||
column | Deprecated Column | project_id 🔑 | No longer primary key. | ||
column | Deprecated Column | project_name | |||
column | Deprecated Column | project_package_manager | |||
column | Deprecated Column | project_source | |||
column | Deprecated Column | project_target_file | |||
column | Deprecated Column | project_url | |||
column | Deprecated Column | publication_time | |||
column | Deprecated Column | reachability | |||
column | Deprecated Column | semver_unaffected | |||
column | Deprecated Column | severity | |||
column | Deprecated Column | url | |||
column | Deprecated Column | version | |||
column | New Column | created_at | |||
column | New Column | description | |||
column | New Column | effective_severity_level | |||
column | New Column | ignore_id | |||
column | New Column | ignored | |||
column | New Column | key | |||
column | New Column | organization_id | |||
column | New Column | resolution_details | |||
column | New Column | resolution_resolved_at | |||
column | New Column | resolution_type | |||
column | New Column | risk_score_model | |||
column | New Column | risk_score_value | |||
column | New Column | scan_item_id | |||
column | New Column | status | |||
column | New Column | tool | |||
column | New Column | updated_at | |||
ISSUE_CLASS | |||||
table | New Table | ISSUE_CLASS | |||
ISSUE_COORDINATE | |||||
table | New Table | ISSUE_COORDINATE | |||
ISSUE_CREDIT | |||||
table | Deprecated Table | ISSUE_CREDIT | |||
ISSUE_IDENTIFIER_CVE | |||||
table | Deprecated Table | ISSUE_IDENTIFIER_CVE | |||
ISSUE_IDENTIFIER_CWE | |||||
table | Deprecated Table | ISSUE_IDENTIFIER_CWE | |||
ISSUE_PATCH | |||||
table | Deprecated Table | ISSUE_PATCH | |||
ISSUE_PATCH_COMMENT | |||||
table | Deprecated Table | ISSUE_PATCH_COMMENT | |||
ISSUE_PATCH_URL | |||||
table | Deprecated Table | ISSUE_PATCH_URL | |||
ISSUE_PROBLEM | |||||
table | New Table | ISSUE_PROBLEM | |||
ISSUE_RISK_FACTOR | |||||
table | New Table | ISSUE_RISK_FACTOR | |||
ISSUE_SEMVER_VULNERABLE | |||||
table | Deprecated Table | ISSUE_SEMVER_VULNERABLE | |||
ISSUE_TEST_EXECUTION | |||||
table | New Table | ISSUE_TEST_EXECUTION | |||
ISSUE_UNIQUE_SEVERITY | |||||
table | Deprecated Table | ISSUE_UNIQUE_SEVERITY | |||
MEMBER | |||||
column | Deprecated Column | organization_group_id | |||
column | New Column | organization_id | |||
ORGANIZATION | |||||
column | Rename Column | created | created_at | ||
column | Deprecated Column | group_name | |||
column | Deprecated Column | url | |||
column | New Column | access_requests_enabled | |||
column | New Column | is_personal | |||
column | New Column | member_role_id | |||
column | New Column | member_role_name | |||
column | New Column | member_role_type | |||
column | New Column | updated_at | |||
PROJECT | |||||
table | New Table | PROJECT | |||
TARGET | |||||
table | New Table | TARGET | |||
USERS | |||||
table | Deprecated Table | USERS | |||
USERS_ORGANIZATION | |||||
table | Deprecated Table | USERS_ORGANIZATION |
Subscript
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BUSINESS_SNAPSHOT_CUSTOMER_STAT | |||||
column | Rename Column | new | new_count | ||
BUSINESS_SNAPSHOT_REVENUE_STAT | |||||
column | Rename Column | new | new_count | ||
BUSINESS_SNAPSHOT_SEAT_STAT | |||||
column | Rename Column | new | new_count | ||
BUSINESS_SNAPSHOT_SUMMARY_STAT | |||||
column | Rename Column | new | new_count | ||
WATERFALL_CUSTOMER_STAT | |||||
column | Rename Column | new | new_count | ||
WATERFALL_REVENUE_STAT | |||||
column | Rename Column | new | new_count |
Ticket Tailor
EVENT_OCCURENCE
table.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EVENT_OCCURENCE | |||||
column | Primary Key Change | event_series_id 🔑 | Added to primary key |
TikTok Ads
We added the ad_format
field to the AD_HISTORY
table. We also added a new table, UTM_PARAM
.
For more information, see the TikTok API documentation.
Transcend
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
REQUEST | |||||
column | Deprecated Column | enabled_on_airgap_cookie | |||
column | Deprecated Column | enabled_on_airgap_data_flow |
Trisolute
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
RANKING | |||||
column | Primary Key Change | object_type 🔑 | object_type | No longer primary key. | |
RANKING_DETAIL | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Rename Column | ranking_object_type | object_type | Updated to adhere to standard naming conventions. | |
SERP_PUBLISHER | |||||
column | Rename Column | serp_drilldown_keyword_keyword | keyword 🔑 | Updated to adhere to standard naming conventions. | |
column | Rename Column | serp_drilldown_keyword_object_type | object_type 🔑 | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | keyword 🔑 | Added to the primary key. | ||
column | Primary Key Change | object_type 🔑 | Added to the primary key. | ||
SERP_VISIBILITY_CHART | |||||
table | Deprecated Table | SERP_VISIBILITY_CHART | Data now available in the SERP_VISIBILITY_VALUE table. | ||
SERP_VISIBILITY_VALUE | |||||
column | Deprecated Column | rate | |||
column | Rename Column | serp_visibility_chart_object_type | object_type | Updated to adhere to standard naming conventions. | |
column | Rename Column | serp_visibility_chart_publisher | publisher 🔑 | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | publisher 🔑 | Added to the primary key. |
Upland Software
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PROFILE_CLICK | |||||
column | New Column | clicked_url | |||
TINY_URL | |||||
table | New Table | TINY_URL |
Workday Financial Management
We have added the ledger_type
column to the LEDGER
table. Re-sync the parent table, JOURNAL_ENTRY
, to backfill the historical data, or reach out to Fivetran Support to do the re-sync for you.
YouTube Analytics
We've added support for the audience retention report.
We've added support for following metadata:
Re-authorize your connector to start using comments metadata.
Zoom
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
WEBINAR_CUSTOM_QUESTION | |||||
table | Deprecated Table | WEBINAR_CUSTOM_QUESTION | Data from WEBINAR_CUSTOM_QUESTION is now available in the WEBINAR_REGISTRANT_CUSTOM_QUESTION table. | ||
WEBINAR_CUSTOM_QUESTION_ANSWER | |||||
table | Deprecated Table | WEBINAR_CUSTOM_QUESTION_ANSWER | Data from WEBINAR_CUSTOM_QUESTION_ANSWER is now available in the WEBINAR_REGISTRANT_CUSTOM_QUESTION table. | ||
WEBINAR_REGISTRANT_CUSTOM_QUESTION | |||||
table | New Table | WEBINAR_REGISTRANT_CUSTOM_QUESTION |
Improvements
Alchemer
We have made the following improvements to the connector:
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.
Amazon S3
The Amazon S3 connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Amazon Selling Partner
We have fixed a bug where we didn’t sync a few records of the VENDOR_RETAIL_PROCUREMENT_ORDER
and VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM
tables.
Assembled
We have made the following improvements to the connector:
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.
Azure Data Lake Storage
We no longer perform hex encoding to store binary values in the destination.
We now support the Iceberg format for your destination tables. This feature is now available in beta. For more information, see our Azure Data Lake Storage documentation.
Checkr
We no longer capture deletes for the CANDIDATE
table and its child tables.
ChurnZero
We now support priority-first sync for the CHURN_SCORE_CALCULATION
and CHURN_SCORE_FACTOR_CALCULATION
tables.
We now sync only the last 2 days' worth of data for the CHURN_SCORE_CALCULATION
table during each incremental sync.
Connector List UI
We added a new design for Connector List on Connector Page.
We have made the following changes to the Lines to Skip and Skip Footer Lines fields in the setup form:
- Renamed the Lines to Skip field to Skip Header Lines
- Added toggles to the Skip Header Lines and Skip Footer Lines fields, which allow you to specify the number of lines you want the connector to skip
For more information, see our setup instructions.
FTP
We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.
GitHub
We have added support for GitHub App authentication.
GoCardless
We now incrementally sync the EVENT
table.
Gong
We have made the following improvements to the connector:
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.
Google Analytics 4
You can now filter a custom report on a dimension that is not a part of the report.
For more details, see our Google Analytics 4 Setup Guide.
Google Display & Video 360
We've added the option to set the report aggregation by specyfying a date range.
We are slowly rolling this feature out to all existing connectors.
HubSpot
We have added support for HubSpot's Custom Events API to sync the custom events and its definitions data in your HubSpot account. We are gradually rolling out this improvement to all existing connectors.
Iterable
We have added a new field, Historical Sync Time Frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. The default value is ALL_TIME
. You can edit the connection details and set the time frame value for an existing connector. We have also added support for the historic_sync_time_frame
field for connectors created using the Create a Connector endpoint. For more information, see our REST API config.
The historical sync limit only applies to the EVENT
table.
Katana
We made the following changes to the sync strategy:
We now incrementally sync the
MANUFACTURE_ORDER_OPERATION
andMANUFACTURING_ORDERING_RECIPE
tables.We now re-import only the following tables to capture updates and deletes:
PRODUCTION_OPERATION
RECIPE
SALES_ORDER_FULFILLMENT
Lever
You can now select to allow or deny syncing the confidential data while setting up a Lever connector. This functionality is enabled by default for connectors created after July 29, 2024.
Linear
We can now retrieve and sync your archived issues into the ISSUE
table.
MySQL
All MySQL 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.
Okta
We have made the following improvements to the connector:
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.
The Okta connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
OneLake
We no longer perform hex encoding to store binary values in the destination.
Oracle Fusion Cloud Applications
We now support JSON Web Token (JWT) Authentication for our Oracle Fusion Cloud Application connectors.
We are gradually rolling out this feature for all the connectors.
The Oracle Fusion Cloud Applications connectors now support the Hybrid Deployment model. For more information, see our setup instructions:
- Oracle Fusion Cloud Applications - CRM
- Oracle Fusion Cloud Applications - FSCM (ERP & SCM)
- Oracle Fusion Cloud Applications - HCM
Salesforce
We now display a warning when a table encounters issues capturing deletes, recommending that you manually re-sync the affected tables instead of automatically re-syncing them. For more information, see our Salesforce documentation.
We are gradually rolling out this improvement to all connectors.
SAP ERP on HANA
A new version of the Fivetran NetWeaver API is now available for download: v1900242.
We fixed an issue with the INT1 data type (1 byte) that was incorrectly stored as 2 bytes. This caused issues on SAP systems running on big-endian architectures. The fix ensures proper handling of this data type, regardless of the system's endianness.
Additionally, for MDTC
, we have modified unpacked column names so they are no longer prefixed by /FIVETRAN/
.
For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.
Shopify
We have upgraded our connector to Shopify API v2024-04. As a part of the upgrade, we have added a new column, is_removed
, to the ORDER_SHIPPING_LINE
table. We are gradually rolling out this improvement to all existing connectors.
Slack
We have made the following improvements to the connector:
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.
Snowflake
We now support Snowflake's internal stage to temporarily store data before writing it to Snowflake destinations configured for the Hybrid Deployment model.
Our Snowflake connector is now generally available. See our Snowflake connector documentation.
We have introduced a new sync mechanism to fetch your data from your Snowflake connector. This new method uses Change Data Capture (CDC) sync leveraging Snowflake's Time Travel feature. To enable Time Travel sync, you must either enable change tracking
for all tables or grant OWNERSHIP
privileges to Fivetran for update capture.
SQL Server
All SQL Server 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.
Toggl Track
We have removed the Password dropdown field from the setup configuration as it had a fixed default value, making it an unnecessary field for customers.
Workday RaaS
You can now use a Fivetran-generated primary key for your Workday RaaS reports without a suitable primary (single or composite) key. We have added a new toggle, Use Fivetran Generated Primary Key, to the connector setup form. We generate a fivetran_id
primary key based on a hash of all the columns in the report.
REST API Improvements
Hybrid Deployment Agent Management API
We have renamed our Local Processing Agent Management API to Hybrid Deployment Agent Management API. We will stop supporting the previous paths that were applicable to the Local Processing Agent Management API in 3 months from now. Therefore, you must migrate to the new API before we stop supporting the old paths.
We have added a new parameter, hybrid_deployment_agent_id
, to the Connector Management API and Destination Management API. The new parameter defines the Hybrid Deployment Agent ID and is a duplicate of the local_processing_agent_id
parameter. We will remove the local_processing_agent_id
parameter in future.
New Destination Management endpoint to list destinations within account
We have implemented a new Destination Management API endpoint for our REST API. You can now leverage the new List all destinations within an account feature.
New System Keys management tab Private Preview
We added a new tab where you can add, view, and rotate the previously introduced System Keys in your Fivetran dashboard. To manage System Keys, you must have administrative permissions on the account. Learn more in our System Keys management documentation.
You can add a new System Key by uploading a JSON file with the key access rules. We then validate the file and show a summary of key permissions.
REST API doesn't allow to trigger initial sync for File connectors without Primary Keys defined.
We now restrict API users from triggering File connectors to sync if:
- the
append_file_option
field has its value set toupsert_file_with_primary_keys
- and the primary keys are not defined in the schema configuration
We also restrict the following actions for such connectors:
- Creating a new connector in an un-paused state via API;
- Updating the connector's
paused
field tofalse
via API request; - Forcing the connector sync or re-sync via API request.