Release Notes
October 2024
Effective October 24, 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.
These schema changes are required due to primary key issues and reserved keywords being used as column names.
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.6 total changes • 6 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
APPOINTMENT | |||||
column | Rename Column | end | ends | ||
CALL | |||||
column | Primary Key Change | lead_call_id | lead_call_id 🔑 | Added to primary key. | |
INVENTORY_BILL_ITEM | |||||
column | Rename Column | order 🔑 | orders 🔑 | Primary key has been renamed. | |
INVOICE_ITEM | |||||
column | Rename Column | order | orders | ||
PROJECT_STATUS | |||||
column | Rename Column | order | orders | ||
PROJECT_SUB_STATUS | |||||
column | Rename Column | order | orders |
June 2024
We no longer capture deletes for the following tables and their child tables:
APPOINTMENT
APPOINTMENT_ASSIGNMENT
BOOKING_PROVIDER_TAG
BUSINESS_UNIT
CALL
CAMPAIGN
CUSTOMER
EMPLOYEE
EXPORT_INVOICE_ITEM
INVENTORY_BILL
INVOICE
JOB
JOB_HOLD_REASON
JOB_SPLIT
JOB_TYPE
LEAD
LOCATION
MEMBERSHIP
PAYMENT
PROJECT
PROJECT_STATUS
PROJECT_SUBSTATUS
TECHNICIAN
May 2024
Lite connectors are now available for the following sources: