Release Notes
February 2025
We have removed the foreign key relationship of the message_id column to the EMAIL_SENT and SMS_SENT tables, in the EMAIL_MESSAGE_LINK_CLICK and SMS_MESSAGE_LINK_CLICK tables.
September 2024
Effective September 18, 2024 we use a new September 2024 schema. Review the latest ERD to better understand the schema changes.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 are updating the connector schema to adhere to standard naming conventions.
9 total changes • 9 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CUSTOM_ATTRIBUTE | |||||
| column | Rename Column | timestamp | timestamps | ||
EMAIL_MESSAGE_LINK_CLICK | |||||
| column | Rename Column | timestamp | timestamps | ||
EMAIL_OPENED | |||||
| column | Rename Column | timestamp | timestamps | ||
EMAIL_SENT | |||||
| column | Rename Column | timestamp | timestamps | ||
SMS_EMAIL_SUBSCRIBED | |||||
| column | Rename Column | timestamp | timestamps | ||
SMS_EMAIL_UNSUBSCRIBED | |||||
| column | Rename Column | timestamp | timestamps | ||
SMS_INBOUND | |||||
| column | Rename Column | timestamp | timestamps | ||
SMS_MESSAGE_LINK_CLICK | |||||
| column | Rename Column | timestamp | timestamps | ||
SMS_SENT | |||||
| column | Rename Column | timestamp | timestamps | ||
May 2024
We have changed the connector type of our Attentive connector from Lite to Standard.
April 2024
We have changed the way we calculate the value for the _fivetran_id column in the CUSTOM_ATTRIBUTE and SMS_INBOUND tables.
March 2024
We have changed the primary key of the SMS_INBOUND table. The new primary key is the _fivetran_id column. Previously, we used subscriber_external_id and _fivetran_id columns as the composite primary key for the table.
November 2023
Lite connectors are now available for the following sources: