Release Notes

---

July 2020

We have added a warning to your Fivetran dashboard that asks you to increase your sync frequency if your COMPANY and COMPANY_PROPERTY_HISTORY tables have huge recurring updates. Previously, if these tables had more than 9900 updates, we initiated a complete re-sync to prevent data integrity issues. The re-sync caused high MAR (monthly active rows) consumption.

You can prevent these re-syncs and avoid impact on your MAR by increasing your sync frequency.

---

May 2020

You can now configure your HubSpot connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

---

April 2020

We now support future timestamp values in the following tables:

• CALENDAR_EVENT
• COMPANY_PROPERTY_HISTORY
• CONTACT_FORM_SUBMISSION
• CONTACT_PROPERTY_HISTORY
• DEAL_PROPERTY_HISTORY
• EMAIL_SUBSCRIPTION_CHANGE
• ENGAGEMENT
• LINE_ITEM_PROPERTY_HISTORY
• IDENTITY_PROFILE_IDENTITY

If you have previously synced future timestamp values, re-sync the tables to ensure data integrity.

---

March 2020

We have added three new fields to the CONTACT table:

• canonical_vid
• merged_vids
• profile_url

We have added three new tables:

• CONTACT_MERGE_AUDIT
• CONTACT_IDENTITY_PROFILE
• IDENTITY_PROFILE_IDENTITY

---

January 2020

We are gradually rolling out a new feature to capture deletes via webhooks for the following tables:

• COMPANY
• CONTACT
• DEAL

To take advantage of the new feature, you will need to reconnect the connector and provide additional information in the required new fields in the setup form.

---

August 2019

• We have added the column activityType to the ENGAGEMENT table.

---

July 2019

We have added the table blocking feature to all HubSpot tables. You can now choose which tables you'd like to sync or omit from syncing. To select or deselect tables, go to the schema page of your Fivetran dashboard.

If you wish to sync a child table, you must also sync its parent table.

---

February 2019

New fields in ENGAGEMENT_* tables will be synced automatically.

---

January 2019

• We have added the new column web_conference_meeting_id to the ENGAGEMENT_MEETING table.
• We have also added the new column unknown_visitor_conversation to the ENGAGEMENT_CALL table.

---

September 2018

We have added a new field, transcription_id, to the ENGAGEMENT_CALL table.

The HubSpot connector can now sync e-commerce data for your Sales Hub, including products and line items. We have added the following tables to support this feature:

• PRODUCT
• PRODUCT_PROPERTY_HISTORY
• LINE_ITEM
• LINE_ITEM_PROPERTY_HISTORY

---

August 2018

We have added two new columns, attachedVideoOpened and attachedVideoWatched, to the ENGAGEMENT_EMAIL table.

---

July 2018

We have added the media_processing_status column to the ENGAGEMENT_EMAIL table.

---

May 2018

We have added two new fields, callee_object_type and callee_object_id, to the ENGAGEMENT_CALL table.

---

April 2018

We will now re-sync the entire ENGAGEMENTS table when there are more than 10,000 changed records, because HubSpot can no longer complete incremental queries to the engagements endpoint when there are so many changed records.

Some HubSpot records have very old timestamps (for example,Jan 1 1970). These values no longer cause our syncs to fail.

We have added the following columns to the tables below:

TABLE	COLUMN
ENGAGEMENT_META_EMAIL	post_send_status
ENGAGEMENT_EMAIL	recipient_drop_reasons