Release Notes
August 2024
Effective August 12, 2024 we use a new August 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
This schema change is required due to the incorrect usage of combined 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.32 total changes • 5 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACCEPTED_EVENT | |||||
table | New Table | ACCEPTED_EVENT | |||
ACCEPTED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | ACCEPTED_EVENT_MESSAGE_ATTACHMENT | |||
ACCEPTED_EVENT_MESSAGE_RECIPIENT | |||||
table | New Table | ACCEPTED_EVENT_MESSAGE_RECIPIENT | |||
ACCEPTED_EVENT_ROUTE | |||||
table | New Table | ACCEPTED_EVENT_ROUTE | |||
ACCEPTED_EVENT_TAG | |||||
table | New Table | ACCEPTED_EVENT_TAG | |||
CLICKED_EVENT | |||||
table | New Table | CLICKED_EVENT | |||
CLICKED_EVENT_TAG | |||||
table | New Table | CLICKED_EVENT_TAG | |||
COMPLAINED_EVENT | |||||
table | New Table | COMPLAINED_EVENT | |||
COMPLAINED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | COMPLAINED_EVENT_MESSAGE_ATTACHMENT | |||
COMPLAINED_EVENT_TAG | |||||
table | New Table | COMPLAINED_EVENT_TAG | |||
DELIVERED_EVENT | |||||
table | New Table | DELIVERED_EVENT | |||
DELIVERED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | DELIVERED_EVENT_MESSAGE_ATTACHMENT | |||
DELIVERED_EVENT_TAG | |||||
table | New Table | DELIVERED_EVENT_TAG | |||
EVENT | |||||
table | Deprecated Table | EVENT | Data now available in the STORED_EVENT , COMPLAINED_EVENT , UNSUBSRCIBED_EVENT , CLICKED_EVENT , OPENED_EVENT , FAILED_EVENT , DELIVERED_EVENT , REJECTED_EVENT , and ACCEPTED_EVENT tables. | ||
EVENT_MESSAGE_ATTACHMENT | |||||
table | Deprecated Table | EVENT_MESSAGE_ATTACHMENT | Data now available in the ACCEPTED_EVENT_MESSAGE_ATTACHMENT , REJECTED_EVENT_MESSAGE_ATTACHMENT , DELIVERED_EVENT_MESSAGE_ATTACHMENT , FAILED_EVENT_MESSAGE_ATTACHMENT , STORED_EVENT_MESSAGE_ATTACHMENT , and COMPLAINED_EVENT_MESSAGE_ATTACHMENT tables. | ||
EVENT_MESSAGE_RECIPIENT | |||||
table | Deprecated Table | EVENT_MESSAGE_RECIPIENT | Data now available in the ACCEPTED_EVENT_MESSAGE_RECIPIENT and STORED_EVENT_MESSAGE_RECIPIENT tables. | ||
EVENT_ROUTE | |||||
table | Deprecated Table | EVENT_ROUTE | Data now available in the ACCEPTED_EVENT_ROUTE table. | ||
EVENT_TAG | |||||
table | Deprecated Table | EVENT_TAG | Data now available in the UNSUBSCRIBED_EVENT_TAG , COMPLAINED_EVENT_TAG , CLICKED_EVENT_TAG , STORED_EVENT_TAG , OPENED_EVENT_TAG , FAILED_EVENT_TAG , DELIVERED_EVENT_TAG , REJECTED_EVENT_TAG , and ACCEPTED_EVENT_TAG tables. | ||
FAILED_EVENT | |||||
table | New Table | FAILED_EVENT | |||
FAILED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | FAILED_EVENT_MESSAGE_ATTACHMENT | |||
FAILED_EVENT_TAG | |||||
table | New Table | FAILED_EVENT_TAG | |||
OPENED_EVENT | |||||
table | New Table | OPENED_EVENT | |||
OPENED_EVENT_TAG | |||||
table | New Table | OPENED_EVENT_TAG | |||
REJECTED_EVENT | |||||
table | New Table | REJECTED_EVENT | |||
REJECTED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | REJECTED_EVENT_MESSAGE_ATTACHMENT | |||
REJECTED_EVENT_TAG | |||||
table | New Table | REJECTED_EVENT_TAG | |||
STORED_EVENT | |||||
table | New Table | STORED_EVENT | |||
STORED_EVENT_MESSAGE_ATTACHMENT | |||||
table | New Table | STORED_EVENT_MESSAGE_ATTACHMENT | |||
STORED_EVENT_MESSAGE_RECIPIENT | |||||
table | New Table | STORED_EVENT_MESSAGE_RECIPIENT | |||
STORED_EVENT_TAG | |||||
table | New Table | STORED_EVENT_TAG | |||
UNSUBSCRIBED_EVENT | |||||
table | New Table | UNSUBSRCIBED_EVENT | |||
UNSUBSCRIBED_EVENT_TAG | |||||
table | New Table | UNSUBSCRIBED_EVENT_TAG |
February 2024
We have added the following new tables to incrementally sync the data for domain events:
EVENT
EVENT_TAG
EVENT_MESSAGE_ATTACHMENT
EVENT_MESSAGE_RECIPIENT
EVENT_ROUTE
April 2023
Lite connectors are now available for the following sources: