Release Notes
June 2024
Effective June 18, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
These schema changes are required due to a weak primary key and for the purposes of establishing a foreign key relationship between the CLIENT_SENT_CAMPAIGN table and its child entities.
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.14 total changes • 6 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CAMPAIGN_BOUNCE | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_CLICK | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_EMAIL_CLIENT | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_LIST | |||||
column | Primary Key Change | client_id 🔑 | New primary key. | ||
CAMPAIGN_OPEN | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_RECIPIENT | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_SEGMENT | |||||
column | Primary Key Change | client_id 🔑 | New primary key. | ||
CAMPAIGN_SPAM_COMPLAINT | |||||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_SUMMARY | |||||
column | Primary Key Change | campaign_id 🔑 | campaign_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
column | New Column | client_id | Added to foreign key. | ||
CAMPAIGN_UNSUBSCRIBE | |||||
column | New Column | client_id | Added to foreign key. | ||
CLIENT_SENT_CAMPAIGN | |||||
column | Primary Key Change | client_id 🔑 | Added to primary key. | ||
SENT_CAMPAIGN_TAG | |||||
column | Primary Key Change | client_id 🔑 | Added to primary key. |
January 2024
You can now configure your Campaign Monitor connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
June 2023
Lite connectors are now available for the following sources: