Release Noteslink
April 2024link
We have released a new April 2024 schema on April 22, 2024. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
These schema changes are required to resolve critical data integrity issues. 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.
These schema changes are required to resolve critical data integrity issues. 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.
25 total changes • 22 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
INTERACTION_CHAT_PERSON_EMAIL | |||||
table | Deprecated Table | interaction_chat_person_email | Data is available in the person_with_interaction_email table. | ||
INTERACTION_FROM_EMAIL | |||||
table | Deprecated Table | interaction_from_email | Data is available in the person_with_interaction_email table. | ||
INTERACTION_MEETING_CALL | |||||
table | Deprecated Table | interaction_meeting_call | We are creating individual tables for both meeting and call type of interactions so this table has been removed. | ||
INTERACTION_MEETING_CALL_ATTENDEE | |||||
table | Deprecated Table | interaction_meeting_call_attendee | We are creating individual tables for both meeting and call type of interactions so this table has been removed. | ||
INTERACTION_MEETING_CALL_EMAIL | |||||
table | Deprecated Table | interaction_meeting_call_email | We are creating individual tables for both meeting and call type of interactions so this table has been removed. | ||
INTERACTION_MEETING_CALL_NOTE | |||||
table | Deprecated Table | interaction_meeting_call_note | We are creating individual tables for both meeting and call type of interactions so this table has been removed. | ||
INTERACTION_MEETING_CALL_PERSON | |||||
table | Deprecated Table | interaction_meeting_call_person | We are creating individual tables for both meeting and call type of interactions so this table has been removed. | ||
INTERACTION_TO_EMAIL_COMBINED | |||||
table | Deprecated Table | interaction_to_email_combined | The table was causing data redundancy. | ||
INTERACTION_TO_PERSON_EMAIL (new table name: INTERACTION_EMAIL_TO) | |||||
table | Rename Table | interaction_to_person_email | interaction_email_to | Renamed for better understanding. | |
LIST_ENTRY | |||||
column | Primary Key Change | list_id | list_id 🔑 | Added to primary key to avoid data integrity issues. | |
NOTE | |||||
table | New Table | We are now capturing notes data. | |||
OPPORTUNITY_LIST_ENTRY | |||||
column | Primary Key Change | opportunity_id | opportunity_id 🔑 | Added to primary key to avoid data integrity issues. | |
OPPORTUNITY_ORGANIZATION | |||||
column | Deprecated Column | type | Not required because we are not combining any tables. | ||
OPPORTUNITY_ORGANIZATION_COMBINED (new table name: OPPORTUNITY_ORGANIZATION) | |||||
table | Rename Table | opportunity_organization_combined | opportunity_organization | We are now capturing data from only one entity. Previously, it was two combined entities. | |
ORGANIZATION (new table name: ORGANIZATION_WITH_INTERACTION) | |||||
table | Rename Table | organization | organization_with_interaction | Renamed for better understanding. | |
ORGANIZATION_DOMAIN (new table name: ORGANIZATION_WITH_INTERACTION_DOMAIN) | |||||
table | Rename Table | organization_domain | organization_with_interaction_domain | Renamed for better understanding. | |
ORGANIZATION_ENTRY (new table name: ORGANIZATION_WITH_INTERACTION_LIST_ENTRY) | |||||
table | Rename Table | organization_entry | organization_with_interaction_list_entry | Renamed for better understanding. | |
ORGANIZATION_INTERACTION_PERSON_ID | |||||
column | Primary Key Change | interaction_date 🔑 | interaction_date | No longer primary key. | |
column | Primary Key Change | type | type 🔑 | Added to primary key to avoid data integrity issues. | |
ORGANIZATION_PERSON_ID (new table name: ORGANIZATION_WITH_INTERACTION_PERSON_ID) | |||||
table | Rename Table | organization_person_id | organization_with_interaction_person_id | Renamed for better understanding. | |
ORGANIZATION_WITHOUT_INTERACTION | |||||
table | New Table | We are now capturing organizations without interactions. | |||
PERSON (new table name: PERSON_WITH_INTERACTION) | |||||
table | Rename Table | person | person_with_interaction | Renamed for better understanding. | |
PERSON_EMAIL (new table name: PERSON_WITH_INTERACTION_EMAIL) | |||||
table | Rename Table | person_email | person_with_interaction_email | Renamed for better understanding. | |
PERSON_WITHOUT_INTERACTION | |||||
table | New Table | We are now capturing persons without interactions. | |||
REMINDER_EMAIL | |||||
table | Deprecated Table | reminder_email | Data can be queried in the PERSON_WITH_INTERACTION_EMAIL and PERSON_WITHOUT_INTERACTION_EMAIL tables. |
January 2024link
Lite connectors are now available for the following sources: