Release Notes
September 2024
Effective September 4, 2024 we use a new September 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.16 total changes • 16 possible breaking changes
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. |
May 2024
We have renamed our DEAR connector to Cin7 Core. This name change applies to the Fivetran dashboard and our documentation.
June 2023
Lite connectors are now available for the following sources: