Release Noteslink
May 2024link
We have released a new May 2024 Schema on May 13, 2024. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We have changed the primary key column for multiple tables. 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 changed the primary key column for multiple tables. 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.
10 total changes • 9 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CONTACT_CUSTOM_PROPERTY | |||||
column | Primary Key Change | contact_id | contact_id 🔑 | Added to primary key | |
CONTACT_TAG | |||||
column | Primary Key Change | contact_id | contact_id 🔑 | Added to primary key | |
CUSTOM_PROPERTY_OPTION | |||||
column | Primary Key Change | custom_property_id | custom_property_id 🔑 | Added to primary key | |
MEDIA_LIBRARY_CONTENT | |||||
column | New Column | owner_reached | |||
MEDIA_LIBRARY_CONTENT_TAG | |||||
column | Primary Key Change | media_library_content_id | media_library_content_id 🔑 | Added to primary key | |
PARTNERSHIP_JOB | |||||
column | Primary Key Change | partnership_id | partnership_id 🔑 | Added to primary key | |
PARTNERSHIP_PROPOSAL | |||||
column | Primary Key Change | partnership_id | partnership_id 🔑 | Added to primary key | |
PARTNERSHIP_TASK | |||||
column | Primary Key Change | partnership_id | partnership_id 🔑 | Added to primary key | |
PAYMENT_ITEM | |||||
column | Primary Key Change | payment_id | payment_id 🔑 | Added to primary key | |
PRODUCT_IMAGE | |||||
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key |
April 2024link
We have added the column metadata
in the CONVERSION
table to store information about custom fields. Previously, these fields appeared with the prefix meta_data_
, but now they are consolidated into this single column.
February 2024link
Lite connectors are now available for the following sources: