Release Notes
September 2024
Effective September 18, 2024 we use a new September 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
We have made the following schema changes to resolve reserved keyword errors.
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.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: