Release Noteslink
February 2024link
We have updated the Quickstart packages for the following connectors:
- Fivetran Platform Connector to version 1.4.3
- Facebook Ads to version 0.7.2
- Intercom to version 0.9.1
- Zendesk Support to version 0.13.1
November 2023link
We have updated the Quickstart packages for the following connectors:
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
October 2023link
We now re-import the ARTICLE_HISTORY
table in every sync due to limitations in the Intercom API. We perform a re-import to ensure data integrity.
We have updated the Quickstart packages for the following connectors:
- Fivetran Platform Connector to version 1.1.0
- Google Ads to version 0.9.3
- Intercom to version 0.8.0
- Jira to version 0.15.0
- NetSuite SuiteAnalytics to version 0.9.0
- QuickBooks to version 0.12.0
- Zendesk Support to version 0.11.2
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
We have upgraded our Intercom connector from Intercom API version 2.9 to 2.10. As part of the upgrade, we have made the following schema changes:
We have added the following new tables:
HELP_CENTER_HISTORY
TICKET_CONTACT_HISTORY
TICKET_HISTORY
TICKET_LINK_HISTORY
TICKET_PART_ATTACHMENT_HISTORY
TICKET_PART_HISTORY
TICKET_TYPE_ATTRIBUTE_HISTORY
TICKET_TYPE_HISTORY
We have deprecated the
SECTION_HISTORY
table.We have added a new column,
help_center_id
, to theCOLLECTION_HISTORY
table.We have deprecated the
section_id
column from theARTICLE_HISTORY
table.
We are gradually rolling out these changes to all existing connectors.
July 2023link
We have added the following new tables:
ARTICLE_HISTORY
COLLECTION_HISTORY
COMPANY_SEGMENT_HISTORY
CONTACT_DATA_EVENT
CONTACT_SEGMENT_HISTORY
CONTACT_SUBSCRIPTION_HISTORY
DATA_ATTRIBUTE
DATA_ATTRIBUTE_OPTION
NEWS_ITEM_HISTORY
NEWS_ITEM_LABEL_HISTORY
NEWS_ITEM_REACTION_HISTORY
NEWSFEED_ASSIGNMENT
NEWSFEED_HISTORY
SECTION_HISTORY
SEGMENT
SUBSCRIPTION_TYPE
SUBSCRIPTION_TYPE_CONTENT_TYPE
SUBSCRIPTION_TYPE_TRANSLATION
To sync the following tables, you must re-authenticate to grant Fivetran the necessary permissions:
ARTICLE_HISTORY
COLLECTION_HISTORY
NEWS_ITEM_HISTORY
NEWS_ITEM_LABEL_HISTORY
NEWS_ITEM_REACTION_HISTORY
NEWSFEED_ASSIGNMENT
NEWSFEED_HISTORY
SECTION_HISTORY
We have added the following new columns to the tables below:
app_id
column to theCOMPANY
tableformatted_phone
column to theCONTACT
tablestatistics_*
columns to theCONVERSATION
table
We are gradually rolling out these changes to all existing connectors.
We have made the following changes to our history tables:
- Added three new columns,
_fivetran_active
,_fivetran_start
, and_fivetran_end
- Removed the
_fivetran_deleted
column
The history table changes are applicable to connectors created after July 20, 2023. We will be rolling out these changes to all existing connectors after October 31, 2023.
February 2023link
We have upgraded our Intercom connector from Intercom API version 2.0 to 2.8. We have made the following schema changes:
- We now support the
teammate
object in theCONVERSATIONS
table. - We have added the
title
andteam_assignee_id
column to theCONVERSATIONS
table. - We have added the
inbox_seat
column to theADMIN
table. - We now support conversation topics data.
- We have added support for custom conversation attributes.
July 2022link
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Intercom connector by adding the auth
section to payloads.
June 2022link
We now re-import the COMPANY_HISTORY
and COMPANY_TAG_HISTORY
tables once a week. Previously, we re-imported the COMPANY_HISTORY
and COMPANY_TAG_HISTORY
tables once a day. We are gradually rolling out the new feature to all existing connectors.
March 2021link
For all new Intercom connectors created after March 1, we will capture webhook events through the endpoint registered in our OAuth app. This change makes it simpler and faster to set up an Intercom connector. For existing Intercom connectors, we will continue to capture webhook events through the Fivetan endpoint you registered in Intercom during setup.
January 2021link
We have released pre-built, dbt Core-compatible data models for Intercom. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
July 2020link
We now support Intercom REST API V2.0.
April 2020link
You can now configure your Intercom connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
November 2018link
We have released a new version of the Intercom connector, now with an improved schema. You can find additional information in our Intercom documentation.
Thanks to leveraging Intercom webhooks, we now support the delete
function in the following tables:
USER_HISTORY
LEAD_HISTORY
ADMIN
TEAM
SEGMENT_HISTORY
TAG
July 2018link
We have added the conversation_rating
field to the CONVERSATION
table.
May 2018link
We have added three new fields to the COMPANY
table - size
, website
, and industry
.