Release Notes
December 2024
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.
November 2024
The following Lite connectors now support the Hybrid Deployment model:
Expand to see the full list
- 7shifts
- 360Learning
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- 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
October 2024
Effective October 23, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.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.
We have made these schema changes to improve schema usability.
413 total changes • 136 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ADDRESS | |||||
| table | Discontinued Table | ADDRESS | |||
BOOKING | |||||
| column | Discontinued Column | consignee_entity_name | |||
| column | Discontinued Column | consignee_entity_object | |||
| column | Discontinued Column | consignee_entity_ref | |||
| column | Rename Column | ocean_booking_container_counts_forty_five_ft_hc | ocean_booking_container_count_forty_five_ft_hc | ||
| column | Rename Column | ocean_booking_container_counts_forty_ft | ocean_booking_container_count_forty_ft | ||
| column | Rename Column | ocean_booking_container_counts_forty_ft_hc | ocean_booking_container_count_forty_ft_hc | ||
| column | Rename Column | ocean_booking_container_counts_object | ocean_booking_container_count_object | ||
| column | Rename Column | ocean_booking_container_counts_twenty_ft | ocean_booking_container_count_twenty_ft | ||
| column | Discontinued Column | shipper_entity_name | |||
| column | Discontinued Column | shipper_entity_object | |||
| column | Discontinued Column | shipper_entity_ref | |||
| column | New Column | air_booking_destination_port_address_city | |||
| column | New Column | air_booking_destination_port_address_country | |||
| column | New Column | air_booking_destination_port_address_country_code | |||
| column | New Column | air_booking_destination_port_address_object | |||
| column | New Column | air_booking_destination_port_address_ref | |||
| column | New Column | air_booking_destination_port_address_state | |||
| column | New Column | air_booking_destination_port_address_street | |||
| column | New Column | air_booking_destination_port_address_street_2 | |||
| column | New Column | air_booking_destination_port_address_timezone | |||
| column | New Column | air_booking_destination_port_address_unlocode | |||
| column | New Column | air_booking_destination_port_address_zip | |||
| column | New Column | air_booking_destination_port_name | |||
| column | New Column | air_booking_destination_port_object | |||
| column | New Column | air_booking_origin_port_address_city | |||
| column | New Column | air_booking_origin_port_address_country | |||
| column | New Column | air_booking_origin_port_address_country_code | |||
| column | New Column | air_booking_origin_port_address_ref | |||
| column | New Column | air_booking_origin_port_address_state | |||
| column | New Column | air_booking_origin_port_address_street | |||
| column | New Column | air_booking_origin_port_address_street_2 | |||
| column | New Column | air_booking_origin_port_address_timezone | |||
| column | New Column | air_booking_origin_port_address_unlocode | |||
| column | New Column | air_booking_origin_port_address_zip | |||
| column | New Column | destination_address_city | |||
| column | New Column | destination_address_country | |||
| column | New Column | destination_address_country_code | |||
| column | New Column | destination_address_ref | |||
| column | New Column | destination_address_state | |||
| column | New Column | destination_address_street | |||
| column | New Column | destination_address_street_2 | |||
| column | New Column | destination_address_timezone | |||
| column | New Column | destination_address_unlocode | |||
| column | New Column | destination_address_zip | |||
| column | New Column | ocean_booking_destination_port_address_city | |||
| column | New Column | ocean_booking_destination_port_address_country | |||
| column | New Column | ocean_booking_destination_port_address_country_code | |||
| column | New Column | ocean_booking_destination_port_address_object | |||
| column | New Column | ocean_booking_destination_port_address_ref | |||
| column | New Column | ocean_booking_destination_port_address_state | |||
| column | New Column | ocean_booking_destination_port_address_street | |||
| column | New Column | ocean_booking_destination_port_address_street_2 | |||
| column | New Column | ocean_booking_destination_port_address_timezone | |||
| column | New Column | ocean_booking_destination_port_address_unlocode | |||
| column | New Column | ocean_booking_destination_port_address_zip | |||
| column | New Column | ocean_booking_origin_port_address_city | |||
| column | New Column | ocean_booking_origin_port_address_country | |||
| column | New Column | ocean_booking_origin_port_address_country_code | |||
| column | New Column | ocean_booking_origin_port_address_ref | |||
| column | New Column | ocean_booking_origin_port_address_state | |||
| column | New Column | ocean_booking_origin_port_address_street | |||
| column | New Column | ocean_booking_origin_port_address_street_2 | |||
| column | New Column | ocean_booking_origin_port_address_timezone | |||
| column | New Column | ocean_booking_origin_port_address_unlocode | |||
| column | New Column | ocean_booking_origin_port_address_zip | |||
| column | New Column | origin_address_city | |||
| column | New Column | origin_address_country | |||
| column | New Column | origin_address_country_code | |||
| column | New Column | origin_address_ref | |||
| column | New Column | origin_address_state | |||
| column | New Column | origin_address_street | |||
| column | New Column | origin_address_street_2 | |||
| column | New Column | origin_address_timezone | |||
| column | New Column | origin_address_unlocode | |||
| column | New Column | origin_address_zip | |||
BOOKING_AIR_BOOKING_DESTINATION_PORT_DETAIL | |||||
| table | New Table | BOOKING_AIR_BOOKING_DESTINATION_PORT_DETAIL | |||
BOOKING_AIR_BOOKING_ORIGIN_PORT_DETAIL | |||||
| table | New Table | BOOKING_AIR_BOOKING_ORIGIN_PORT_DETAIL | |||
BOOKING_AIR_PRODUCT_DESCRIPTION (new table name: BOOKING_AIR_BOOKING_PRODUCT_DESCRIPTION) | |||||
| table | Rename Table | BOOKING_AIR_PRODUCT_DESCRIPTION | BOOKING_AIR_BOOKING_PRODUCT_DESCRIPTION | ||
BOOKING_CARGO_LITHIUM_BATTERY_PACKING_TYPE | |||||
| table | New Table | BOOKING_CARGO_LITHIUM_BATTERY_PACKING_TYPE | |||
BOOKING_CARGO_SHIPPING_UNIT | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | booking_id | booking_id 🔑 | Added to primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
BOOKING_DESCRIPTION | |||||
| table | Discontinued Table | BOOKING_DESCRIPTION | |||
BOOKING_OCEAN_BOOKING_DESTINATION_PORT_DETAIL | |||||
| table | New Table | BOOKING_OCEAN_BOOKING_DESTINATION_PORT_DETAIL | |||
BOOKING_OCEAN_BOOKING_ORIGIN_PORT_DETAIL | |||||
| table | New Table | BOOKING_OCEAN_BOOKING_ORIGIN_PORT_DETAIL | |||
BOOKING_OCEAN_BOOKING_PRODUCT_DESCRIPTION | |||||
| table | New Table | BOOKING_OCEAN_BOOKING_PRODUCT_DESCRIPTION | |||
COMMERCIAL_INVOICE | |||||
| column | New Column | updated_at | |||
COMMERCIAL_INVOICE_INVOLVED_PARTY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | commercial_invoice_id | commercial_invoice_id 🔑 | Added to primary key. | |
| column | Rename Column | mailing_city | address_city | ||
| column | Rename Column | mailing_country | address_country | ||
| column | Rename Column | mailing_country_code | address_country_code | ||
| column | Rename Column | mailing_object | address_object | ||
| column | Rename Column | mailing_ref | address_ref | ||
| column | Rename Column | mailing_state | address_state | ||
| column | Rename Column | mailing_street_address | address_street | ||
| column | Rename Column | mailing_street_address_2 | address_street_2 | ||
| column | Rename Column | mailing_timezone | address_timezone | ||
| column | Rename Column | mailing_unlocode | address_unlocode | ||
| column | Rename Column | mailing_zip | address_zip | ||
| column | Primary Key Change | index 🔑 | New primary key. | ||
COMMERCIAL_INVOICE_LINE_ITEM | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | commercial_invoice_id | commercial_invoice_id 🔑 | Added to primary key. | |
| column | New Column | country_of_origin | |||
| column | Primary Key Change | id 🔑 | New primary key. | ||
COMMERCIAL_INVOICE_MANUFACTURER_ADDRESS | |||||
| table | New Table | COMMERCIAL_INVOICE_MANUFACTURER_ADDRESS | |||
COMPANY_ENTITY | |||||
| column | New Column | mailing_address_city | |||
| column | New Column | mailing_address_country | |||
| column | New Column | mailing_address_country_code | |||
| column | New Column | mailing_address_object | |||
| column | New Column | mailing_address_ref | |||
| column | New Column | mailing_address_state | |||
| column | New Column | mailing_address_street | |||
| column | New Column | mailing_address_street_2 | |||
| column | New Column | mailing_address_timezone | |||
| column | New Column | mailing_address_unlocode | |||
| column | New Column | mailing_address_zip | |||
COMPANY_ENTITY_VAT_NUMBER | |||||
| table | New Table | COMPANY_ENTITY_VAT_NUMBER | |||
CONTAINER | |||||
| column | New Column | empty_container_pickup_date | |||
| column | New Column | empty_ready_date | |||
| column | New Column | reference_code | |||
CONTAINER_ITEM | |||||
| column | Primary Key Change | container_id | container_id 🔑 | Added to primary key. | |
CONTAINER_LEG_DATE | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | container_leg_id | container_leg_id 🔑 | Added to primary key. | |
| column | New Column | actual_discharge_date | |||
| column | Primary Key Change | index 🔑 | New primary key. | ||
DETAIL | |||||
| table | Discontinued Table | DETAIL | |||
HS | |||||
| table | Discontinued Table | HS | |||
INVOICE | |||||
| column | Discontinued Column | issuer_name | |||
| column | Discontinued Column | issuer_ref | |||
| column | Discontinued Column | recipient_name | |||
| column | Discontinued Column | recipient_ref | |||
| column | Discontinued Column | shipment_id | |||
| column | New Column | exchange_rate | |||
| column | New Column | invoice_type | |||
| column | New Column | quote_currency_code | |||
| column | New Column | service_level | |||
| column | New Column | shipment_link | |||
INVOICE_CREDIT_MEMO | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | category | |||
| column | Primary Key Change | invoice_id | invoice_id 🔑 | Added to primary key. | |
| column | Discontinued Column | reason | |||
| column | Discontinued Column | reasons | |||
| column | Primary Key Change | index 🔑 | New primary key. | ||
INVOICE_CREDIT_MEMO_CATEGORY | |||||
| table | New Table | INVOICE_CREDIT_MEMO_CATEGORY | |||
INVOICE_CREDIT_MEMO_REASON | |||||
| table | New Table | INVOICE_CREDIT_MEMO_REASON | |||
INVOICE_LINE_ITEM (new table name: ) | |||||
| table | Rename Table | INVOICE_ITEM | |||
LOCATION | |||||
| column | Discontinued Column | contacts_ref_type | |||
| column | New Column | address_city | |||
| column | New Column | address_country | |||
| column | New Column | address_country_code | |||
| column | New Column | address_object | |||
| column | New Column | address_ref | |||
| column | New Column | address_state | |||
| column | New Column | address_street | |||
| column | New Column | address_street_2 | |||
| column | New Column | address_timezone | |||
| column | New Column | address_unlocode | |||
| column | New Column | address_zip | |||
PORT | |||||
| column | New Column | address_city | |||
| column | New Column | address_country | |||
| column | New Column | address_country_code | |||
| column | New Column | address_object | |||
| column | New Column | address_ref | |||
| column | New Column | address_state | |||
| column | New Column | address_street | |||
| column | New Column | address_street_2 | |||
| column | New Column | address_timezone | |||
| column | New Column | address_unlocode | |||
| column | New Column | address_zip | |||
PORT_DETAIL | |||||
| table | New Table | PORT_DETAIL | |||
PRODUCT_CLASSIFICATION | |||||
| column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
| column | New Column | object | |||
PRODUCT_CLASSIFICATION_CODE | |||||
| column | Rename Column | hs_code 🔑 | code | No longer a primary key. | |
| column | Discontinued Column | product_classification_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | index 🔑 | New primary key. | ||
| column | Primary Key Change | product_classification_index 🔑 | New primary key. | ||
| column | Primary Key Change | product_id 🔑 | New primary key. | ||
PRODUCT_PROPERTY | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
PRODUCT_SUPPLIER | |||||
| column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
PURCHASE_ORDER | |||||
| column | Discontinued Column | buyer_id | |||
| column | Rename Column | freight_paymnet_term | freight_payment_term | ||
| column | Rename Column | line_itemlink | line_item_link | ||
| column | Rename Column | line_itemobject | line_item_object | ||
| column | Discontinued Column | line_itemref_type | |||
| column | Discontinued Column | seller_id | |||
| column | New Column | destination_port_address_city | |||
| column | New Column | destination_port_address_country | |||
| column | New Column | destination_port_address_country_code | |||
| column | New Column | destination_port_address_object | |||
| column | New Column | destination_port_address_ref | |||
| column | New Column | destination_port_address_state | |||
| column | New Column | destination_port_address_street | |||
| column | New Column | destination_port_address_street_2 | |||
| column | New Column | destination_port_address_timezone | |||
| column | New Column | destination_port_address_unlocode | |||
| column | New Column | destination_port_address_zip | |||
| column | New Column | origin_address_city | |||
| column | New Column | origin_address_country | |||
| column | New Column | origin_address_country_code | |||
| column | New Column | origin_address_object | |||
| column | New Column | origin_address_ref | |||
| column | New Column | origin_address_state | |||
| column | New Column | origin_address_street | |||
| column | New Column | origin_address_street_2 | |||
| column | New Column | origin_address_timezone | |||
| column | New Column | origin_address_unlocode | |||
| column | New Column | origin_address_zip | |||
| column | New Column | origin_port_address_city | |||
| column | New Column | origin_port_address_country | |||
| column | New Column | origin_port_address_country_code | |||
| column | New Column | origin_port_address_object | |||
| column | New Column | origin_port_address_ref | |||
| column | New Column | origin_port_address_state | |||
| column | New Column | origin_port_address_street | |||
| column | New Column | origin_port_address_street_2 | |||
| column | New Column | origin_port_address_timezone | |||
| column | New Column | origin_port_address_unlocode | |||
| column | New Column | origin_port_address_zip | |||
PURCHASE_ORDER_DESTINATION_ADDRESS | |||||
| table | New Table | PURCHASE_ORDER_DESTINATION_ADDRESS | |||
PURCHASE_ORDER_DESTINATION_PORT_DETAIL | |||||
| table | New Table | PURCHASE_ORDER_DESTINATION_PORT_DETAIL | |||
PURCHASE_ORDER_LINE_ITEM | |||||
| column | Discontinued Column | assigned_party_name | |||
| column | Discontinued Column | assigned_party_object | |||
| column | Discontinued Column | assigned_party_ref | |||
| column | Discontinued Column | country_code | |||
| column | Discontinued Column | hs_code | |||
| column | Discontinued Column | product_id | |||
| column | Discontinued Column | supplier | |||
| column | New Column | cargo_ready_date | |||
| column | New Column | destination_port_address_city | |||
| column | New Column | destination_port_address_country | |||
| column | New Column | destination_port_address_country_code | |||
| column | New Column | destination_port_address_object | |||
| column | New Column | destination_port_address_ref | |||
| column | New Column | destination_port_address_state | |||
| column | New Column | destination_port_address_street | |||
| column | New Column | destination_port_address_street_2 | |||
| column | New Column | destination_port_address_timezone | |||
| column | New Column | destination_port_address_unlocode | |||
| column | New Column | destination_port_address_zip | |||
| column | New Column | destination_port_object | |||
| column | New Column | origin_address_city | |||
| column | New Column | origin_address_country | |||
| column | New Column | origin_address_country_code | |||
| column | New Column | origin_address_object | |||
| column | New Column | origin_address_ref | |||
| column | New Column | origin_address_state | |||
| column | New Column | origin_address_street | |||
| column | New Column | origin_address_street_2 | |||
| column | New Column | origin_address_timezone | |||
| column | New Column | origin_address_unlocode | |||
| column | New Column | origin_address_zip | |||
| column | New Column | origin_location_city | |||
| column | New Column | origin_location_country | |||
| column | New Column | origin_location_country_code | |||
| column | New Column | origin_location_object | |||
| column | New Column | origin_location_ref | |||
| column | New Column | origin_location_state | |||
| column | New Column | origin_location_street | |||
| column | New Column | origin_location_street_2 | |||
| column | New Column | origin_location_timezone | |||
| column | New Column | origin_location_unlocode | |||
| column | New Column | origin_location_zip | |||
| column | New Column | origin_port_address_city | |||
| column | New Column | origin_port_address_country | |||
| column | New Column | origin_port_address_country_code | |||
| column | New Column | origin_port_address_ref | |||
| column | New Column | origin_port_address_state | |||
| column | New Column | origin_port_address_street | |||
| column | New Column | origin_port_address_street_2 | |||
| column | New Column | origin_port_address_timezone | |||
| column | New Column | origin_port_address_unlocode | |||
| column | New Column | origin_port_address_zip | |||
| column | New Column | origin_port_object | |||
| column | New Column | product_sku | |||
PURCHASE_ORDER_LINE_ITEM_DESTINATION_ADDRESS | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM_DESTINATION_ADDRESS | |||
PURCHASE_ORDER_LINE_ITEM_DESTINATION_PORT_DETAIL | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM_DESTINATION_PORT_DETAIL | |||
PURCHASE_ORDER_LINE_ITEM_HS_CODE | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM_HS_CODE | |||
PURCHASE_ORDER_LINE_ITEM_MEASUREMENT | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Primary Key Change | purchase_order_line_item_id | purchase_order_line_item_id 🔑 | Added to primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
PURCHASE_ORDER_LINE_ITEM_ORIGIN_PORT_DETAIL | |||||
| table | New Table | PURCHASE_ORDER_LINE_ITEM_ORIGIN_PORT_DETAIL | |||
PURCHASE_ORDER_LINE_ITEM_PRODUCT_CLASSIFICATION | |||||
| table | Discontinued Table | PURCHASE_ORDER_LINE_ITEM_PRODUCT_CLASSIFICATION | |||
PURCHASE_ORDER_LINE_ITEM_PRODUCT_PROPERTY | |||||
| table | Discontinued Table | PURCHASE_ORDER_LINE_ITEM_PRODUCT_PROPERTY | |||
PURCHASE_ORDER_ORIGIN_PORT_DETAIL | |||||
| table | New Table | PURCHASE_ORDER_ORIGIN_PORT_DETAIL 🔑 | |||
PURCHASE_ORDER_PARTY | |||||
| column | Primary Key Change | company_entity_id 🔑 | company_entity_id | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | New primary key. | ||
PURCHASE_ORDER_PARTY_CONTACT | |||||
| column | Discontinued Column | _fivetran_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | purchase_order_party_company_entity_id | |||
| column | Discontinued Column | purchase_order_party_purchase_order_id | |||
| column | Primary Key Change | index 🔑 | New primary key. | ||
| column | Primary Key Change | purchase_order_id 🔑 | Added to primary key. | ||
| column | Primary Key Change | purchase_order_party_index 🔑 | New primary key. | ||
SHIPMENT | |||||
| column | New Column | accepted_quote_amount | |||
| column | New Column | accepted_quote_currency_code | |||
| column | New Column | dangerous_goods_is_dangerous | |||
| column | New Column | freight_cost | |||
| column | New Column | main_freight_services_level | |||
| column | New Column | on_time_delivery_date | |||
| column | New Column | quoted_delivery_date_from | |||
| column | New Column | quoted_delivery_date_to | |||
| column | New Column | quoted_transit_time_days_max | |||
| column | New Column | quoted_transit_time_days_min | |||
| column | New Column | wants_214_filing | |||
| column | New Column | wants_ftz_entry | |||
SHIPMENT_BUYER | |||||
| column | Discontinued Column | mailing_city | |||
| column | Discontinued Column | mailing_country | |||
| column | Discontinued Column | mailing_country_code | |||
| column | Discontinued Column | mailing_object | |||
| column | Discontinued Column | mailing_ref | |||
| column | Discontinued Column | mailing_state | |||
| column | Discontinued Column | mailing_street_address | |||
| column | Discontinued Column | mailing_street_address_2 | |||
| column | Discontinued Column | mailing_timezone | |||
| column | Discontinued Column | mailing_unlocode | |||
| column | Discontinued Column | mailing_zip | |||
| column | Discontinued Column | name | |||
| column | Discontinued Column | object | |||
| column | Discontinued Column | ref | |||
| column | Primary Key Change | shipment_id | shipment_id 🔑 | Added to primary key. | |
SHIPMENT_CONSIGNEE | |||||
| table | New Table | SHIPMENT_CONSIGNEE | |||
SHIPMENT_DANGERIOUS_GOODS_CLASSIFICATION (new table name: SHIPMENT_DANGEROUS_GOODS_CLASSIFICATION) | |||||
| table | Rename Table | SHIPMENT_DANGERIOUS_GOODS_CLASSIFICATION | SHIPMENT_DANGEROUS_GOODS_CLASSIFICATION | ||
SHIPMENT_ENTITY | |||||
| table | Discontinued Table | SHIPMENT_ENTITY | |||
SHIPMENT_IMPORTERS_RECORD | |||||
| column | Discontinued Column | mailing_city | |||
| column | Discontinued Column | mailing_country | |||
| column | Discontinued Column | mailing_country_code | |||
| column | Discontinued Column | mailing_object | |||
| column | Discontinued Column | mailing_ref | |||
| column | Discontinued Column | mailing_state | |||
| column | Discontinued Column | mailing_street_address | |||
| column | Discontinued Column | mailing_street_address_2 | |||
| column | Discontinued Column | mailing_timezone | |||
| column | Discontinued Column | mailing_unlocode | |||
| column | Discontinued Column | mailing_zip | |||
| column | Discontinued Column | name | |||
| column | Discontinued Column | object | |||
| column | Discontinued Column | ref | |||
| column | Primary Key Change | shipment_id | shipment_id 🔑 | Added to primary key. | |
SHIPMENT_ITEM | |||||
| column | New Column | additional_quantity | |||
| column | New Column | country_of_origin | |||
| column | New Column | package_quantity | |||
| column | New Column | reference | |||
| column | New Column | total_units_unit_of_measure | |||
SHIPMENT_LEG | |||||
| column | Discontinued Column | container_leg_link | |||
| column | Discontinued Column | container_leg_object | |||
| column | Discontinued Column | destination_object | |||
| column | Discontinued Column | destination_place_object | |||
| column | Discontinued Column | destination_terminal | |||
| column | Rename Column | ocean_leg_container_legs_link | ocean_leg_container_leg_link | ||
| column | Discontinued Column | ocean_leg_container_legs_object | |||
| column | Discontinued Column | origin_object | |||
| column | Discontinued Column | origin_place_object | |||
| column | Discontinued Column | origin_terminal_object | |||
| column | Rename Column | rail_leg_container_legs_link | rail_leg_container_leg_link | ||
| column | Discontinued Column | rail_leg_container_legs_object | |||
| column | Discontinued Column | rail_leg_object | |||
| column | New Column | air_leg_pieces | |||
| column | New Column | destination_place_address_city | |||
| column | New Column | destination_place_address_country | |||
| column | New Column | destination_place_address_country_code | |||
| column | New Column | destination_place_address_object | |||
| column | New Column | destination_place_address_ref | |||
| column | New Column | destination_place_address_state | |||
| column | New Column | destination_place_address_street | |||
| column | New Column | destination_place_address_street_2 | |||
| column | New Column | destination_place_address_timezone | |||
| column | New Column | destination_place_address_unlocode | |||
| column | New Column | destination_place_address_zip | |||
| column | New Column | destination_terminal_address_city | |||
| column | New Column | destination_terminal_address_country | |||
| column | New Column | destination_terminal_address_country_code | |||
| column | New Column | destination_terminal_address_object | |||
| column | New Column | destination_terminal_address_ref | |||
| column | New Column | destination_terminal_address_state | |||
| column | New Column | destination_terminal_address_street | |||
| column | New Column | destination_terminal_address_street_2 | |||
| column | New Column | destination_terminal_address_timezone | |||
| column | New Column | destination_terminal_address_unlocode | |||
| column | New Column | destination_terminal_address_zip | |||
| column | New Column | origin_place_address_city | |||
| column | New Column | origin_place_address_country | |||
| column | New Column | origin_place_address_country_code | |||
| column | New Column | origin_place_address_object | |||
| column | New Column | origin_place_address_ref | |||
| column | New Column | origin_place_address_state | |||
| column | New Column | origin_place_address_street | |||
| column | New Column | origin_place_address_street_2 | |||
| column | New Column | origin_place_address_timezone | |||
| column | New Column | origin_place_address_unlocode | |||
| column | New Column | origin_place_address_zip | |||
| column | New Column | origin_terminal_address_city | |||
| column | New Column | origin_terminal_address_country | |||
| column | New Column | origin_terminal_address_country_code | |||
| column | New Column | origin_terminal_address_object | |||
| column | New Column | origin_terminal_address_ref | |||
| column | New Column | origin_terminal_address_state | |||
| column | New Column | origin_terminal_address_street | |||
| column | New Column | origin_terminal_address_street_2 | |||
| column | New Column | origin_terminal_address_timezone | |||
| column | New Column | origin_terminal_address_unlocode | |||
| column | New Column | origin_terminal_address_zip | |||
| column | New Column | trucking_leg_container_leg_link | |||
SHIPMENT_LEG_DESTINATION_PLACE_DETAIL | |||||
| table | New Table | SHIPMENT_LEG_DESTINATION_PLACE_DETAIL | |||
SHIPMENT_LEG_DESTINATION_TAG | |||||
| table | New Table | SHIPMENT_LEG_DESTINATION_TAG | |||
SHIPMENT_LEG_ORIGIN_PLACE_DETAIL | |||||
| table | New Table | ||||
SHIPMENT_LEG_ORIGIN_TAG | |||||
| table | New Table | ||||
SHIPMENT_SELLER | |||||
| table | New Table | SHIPMENT_SELLER | |||
SHIPMENT_SHIPPER | |||||
| table | New Table | SHIPMENT_SHIPPER | |||
TAGS | |||||
| table | Discontinued Table | TAGS | |||
VAT_NUMBER | |||||
| table | Discontinued Table | VAT_NUMBER | |||
August 2024
We have updated the sync strategy for the INVOICE table to ensure data integrity. We now re-import the INVOICE table once a week to capture updates.
May 2024
Effective May 27, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.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.
We are making this schema change to avoid potential data integrity issues.
4 total changes • 3 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BOOKING_DESCRIPTION | |||||
| column | Primary Key Change | code 🔑 | code | No longer a primary key. | |
| column | Primary Key Change | description_type 🔑 | description_type | No longer a primary key. | |
| column | Primary Key Change | parent_id 🔑 | parent_id | No longer a primary key. | |
| column | New Column | _fivetran_id 🔑 | Added to primary key. | ||
November 2023
Lite connectors are now available for the following sources: