Release Noteslink
May 2024link
We have released a new May 2024 schema on May 6, 2024. 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 null primary key issue. We are also deprecating the CONTACT_INTEGRATION_LINK and LEAD_INTEGRATION_LINK 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.
These schema changes are required due to a null primary key issue. We are also deprecating the CONTACT_INTEGRATION_LINK and LEAD_INTEGRATION_LINK 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.
6 total changes • 4 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CONTACT | |||||
column | New Column | integration_links | |||
CONTACT_INTEGRATION_LINK | |||||
table | Deprecated Table | contact_integration_link | Data available in the INTEGRATION_LINK table. | ||
LEAD | |||||
column | New Column | integration_links | |||
LEAD_INTEGRATION_LINK | |||||
table | Deprecated Table | lead_integration_link | Data available in the INTEGRATION_LINK table. | ||
SMS_ATTACHMENT | |||||
column | Primary Key Change | media_id 🔑 | media_id | No longer primary key due to a null primary key issue. | |
column | Primary Key Change | index 🔑 | New primary key. |
March 2024link
We have changed the sync strategy for the CONTACT
and LEAD
tables and their child tables. We no longer capture deletes for these tables.
February 2024link
We now incrementally sync the CONTACT
and LEAD
tables and their child tables to capture new records. We also re-import these tables and their child tables once a week to capture updates and deletes.
January 2024link
You can now configure your Close connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
November 2023link
We now incrementally sync the following tables:
CALL_ACTIVITY
CREATED_ACTIVITY
EMAIL_ACTIVITY
EMAIL_THREAD_ACTIVITY
LEAD_STATUS_CHANGE_ACTIVITY
MEETING_ACTIVITY
NOTE_ACTIVITY
OPPORTUNITY_STATUS_CHANGE_ACTIVITY
SMS_ACTIVITY
TASK_COMPLETED_ACTIVITY
June 2023link
The Close connector now supports table-level re-syncs.
March 2023link
Lite connectors are now available for the following sources: