Release Notes

December 2024

We have added table re-sync support. Previously, we only supported connector-level re-syncs.

NOTE: Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.

November 2024

Effective November 4, 2024 we use a new November 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are making these schema changes to improve schema usability.

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.

4 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`FIELD_VALUE`
table	Discontinued Table	`FIELD_VALUE`		Data is available in the `OPPORTUNITY_FIELD_VALUE`, `ORGANIZATION_FIELD_VALUE`, and `PERSON_FIELD_VALUE` tables.
`OPPORTUNITY_FIELD_VALUE`
table	New Table		`OPPORTUNITY_FIELD_VALUE`
`ORGANIZATION_FIELD_VALUE`
table	New Table		`ORGANIZATION_FIELD_VALUE`
`PERSON_FIELD_VALUE`
table	New Table		`PERSON_FIELD_VALUE`

April 2024

Effective April 22, 2024 we use a new April 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We have made these schema changes 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	Discontinued Table	`INTERACTION_CHAT_PERSON_EMAIL`		Data is available in the `PERSON_WITH_INTERACTION_EMAIL` table.
`INTERACTION_FROM_EMAIL`
table	Discontinued Table	`INTERACTION_FROM_EMAIL`		Data is available in the `PERSON_WITH_INTERACTION_EMAIL` table.
`INTERACTION_MEETING_CALL`
table	Discontinued Table	`INTERACTION_MEETING_CALL`
`INTERACTION_MEETING_CALL_ATTENDEE`
table	Discontinued Table	`INTERACTION_MEETING_CALL_ATTENDEE`
`INTERACTION_MEETING_CALL_EMAIL`
table	Discontinued Table	`INTERACTION_MEETING_CALL_EMAIL`
`INTERACTION_MEETING_CALL_NOTE`
table	Discontinued Table	`INTERACTION_MEETING_CALL_NOTE`
`INTERACTION_MEETING_CALL_PERSON`
table	Discontinued Table	`INTERACTION_MEETING_CALL_PERSON`
`INTERACTION_TO_EMAIL_COMBINED`
table	Discontinued Table	`INTERACTION_TO_EMAIL_COMBINED`
`INTERACTION_TO_PERSON_EMAIL (new table name: INTERACTION_EMAIL_TO)`
table	Rename Table	`INTERACTION_TO_PERSON_EMAIL`	`INTERACTION_EMAIL_TO`
`LIST_ENTRY`
column	Primary Key Change	`list_id`	`list_id` 🔑	Added to primary key.
`NOTE`
table	New Table		`NOTE`
`OPPORTUNITY_LIST_ENTRY`
column	Primary Key Change	`opportunity_id`	`opportunity_id` 🔑	Added to primary key.
`OPPORTUNITY_ORGANIZATION`
column	Discontinued Column	`type`
`OPPORTUNITY_ORGANIZATION_COMBINED (new table name: OPPORTUNITY_ORGANIZATION)`
table	Rename Table	`OPPORTUNITY_ORGANIZATION_COMBINED`	`OPPORTUNITY_ORGANIZATION`
`ORGANIZATION (new table name: ORGANIZATION_WITH_INTERACTION)`
table	Rename Table	`ORGANIZATION`	`ORGANIZATION_WITH_INTERACTION`
`ORGANIZATION_DOMAIN (new table name: ORGANIZATION_WITH_INTERACTION_DOMAIN)`
table	Rename Table	`ORGANIZATION_DOMAIN`	`ORGANIZATION_WITH_INTERACTION_DOMAIN`
`ORGANIZATION_ENTRY (new table name: ORGANIZATION_WITH_INTERACTION_LIST_ENTRY)`
table	Rename Table	`ORGANIZATION_ENTRY`	`ORGANIZATION_WITH_INTERACTION_LIST_ENTRY`
`ORGANIZATION_INTERACTION_PERSON_ID`
column	Primary Key Change	`interaction_date` 🔑	`interaction_date`	No longer a primary key.
column	Primary Key Change	`type`	`type` 🔑	Added to primary key.
`ORGANIZATION_PERSON_ID (new table name: ORGANIZATION_WITH_INTERACTION_PERSON_ID)`
table	Rename Table	`ORGANIZATION_PERSON_ID`	`ORGANIZATION_WITH_INTERACTION_PERSON_ID`
`ORGANIZATION_WITHOUT_INTERACTION`
table	New Table		`ORGANIZATION_WITHOUT_INTERACTION`
`PERSON (new table name: PERSON_WITH_INTERACTION)`
table	Rename Table	`PERSON`	`PERSON_WITH_INTERACTION`
`PERSON_EMAIL (new table name: PERSON_WITH_INTERACTION_EMAIL)`
table	Rename Table	`PERSON_EMAIL`	`PERSON_WITH_INTERACTION_EMAIL`
`PERSON_WITHOUT_INTERACTION`
table	New Table		`PERSON_WITHOUT_INTERACTION`
`REMINDER_EMAIL`
table	Discontinued Table	`REMINDER_EMAIL`		Data is available in the `PERSON_WITH_INTERACTION_EMAIL` and `PERSON_WITHOUT_INTERACTION_EMAIL` tables.

January 2024

Lite connectors are now available for the following sources: