February 2023

Lite Connectors

Lite connectors are now available for the following sources:

Transformations for dbt Core

dbt Core version 1.4.1 support

We now support dbt Core 1.4.1. You can use this version to run your projects.

NOTE: For transformations for dbt Core*, we don't support SQL Server, Azure Synapse, and MySQL as destinations.

* 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.

Quickstart Data Models

Our Quickstart dbt Core* - compatible data models are now in Beta.

* 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.

New connectors

BambooHR

BambooHR is a human resources management software as a service.

Read our BambooHR connector documentation.

High-Volume Agent SAP ECC on Oracle with NetWeaver

Oracle is an object-relational database management system created by the Oracle Corporation. Fivetran's integration platform replicates data from your Oracle source database and loads it into your destination.

Read our High-Volume Agent SAP ECC on Oracle with NetWeaver documentation.

Schema changes

Crossbeam

We have added the following new tables:

ACCOUNT_FILTER_EXPRESSION
ACCOUNT_FILTER_PART
ACCOUNT_FILTER_PART_OPERAND
PARTNER_PROPOSAL_RECEIVED
PARTNER_TAG
RECORD_PARTNER_POPULATION
REPORT_FILTER
REPORT_FILTER_EXPRESSION
REPORT_FILTER_PART
REPORT_FILTER_PART_OPERAND

We have added the following new columns to the PARTNER_RECORD table:

top_level_xb_name
top_level_xb_website
top_level_xb_uuid
top_level_account_website
top_level_account_name
owner_xb_name
owner_xb_uuid
owner_account_executive_name

We have added the following new columns to the REPORT table:

created_at
comparison_type
folder_uuid
sort

We have added the following new columns to the THREAD_TIMELINE table:

event_data_acting_user_id
event_data_new_owner_id
event_data_prev_owner_id
is_private
owner_organization_id

We have added two new columns, open_deals_count and open_deals_total_amount, to the PARTNER_OVERLAP_COUNT table.

We have added a new column, field_picture_url, to the USERS table.

We have added a new column, partnership_created_at, to the PARTNER table.

We have added a new column, report_id, to the REPORT_NOTIFICATION_CONFIG table.

We have renamed the PARTNER_RECORD_PARTNER_POPULATION table to RECORD_PARTNER_POPULATION.

We have renamed the USER table to USERS.

We have renamed the organization_id column to partner_organization_id in the PARTNER_POPULATION, REPORT, and REPORT_COLUMN tables.

We have renamed the author_id column to user_id in the THREAD table.

We have renamed the acting_organization_id column to partner_organization_id in the THREAD_TIMELINE table.

We have renamed the feed_id column to user_id in the RECORD table.

If you want to sync historical data for these columns, contact our support team.

Facebook Pages

We have added a new table, LIFETIME_POST_METRICS_BY_VIDEO_INTERVAL, to preserve the following metrics represented as intervals:

post_video_retention_graph
post_video_retention_graph_clicked_to_play
post_video_retention_graph_autoplayed

See Facebook's API documentation for more information.

Gong

We have added the following new tables:

CALL_CONTENT_ACTION_ITEM
CALL_CONTEXT_OBJECT
CALL_CONTEXT_OBJECT_FIELD
CALL_INTERACTION
CALL_INTERACTION_STAT
CALL_INSIGHT
CALL_PARTIE
CALL_PARTIE_OBJECT
CALL_PARTIE_OBJECT_FIELD
CALL_PUBLIC_COMMENT
CALL_SPEAKER
CALL_TRACKER
CALL_TRACKER_OCCURRENCE
CALL_TRACKER_PHRASE
CALL_TRACKER_PHRASE_OCCURRENCE

We have added the following new columns to the CALL table:

media_audio_url
media_video_url
interaction_questions_company_count
interaction_questions_non_company_count

We have added a new column, workspace_id, to the TRANSCRIPT table.

We have renamed the TRANSCRIPT_SENTANCE table to TRANSCRIPT_SENTENCE.

We have renamed the following columns in the USERS table:

settings_emails_imported to emails_imported
settings_non_recorded_meetings_imported to non_recorded_meetings_imported.
settings_prevent_email_import to prevent_email_import
settings_prevent_web_conference_recording to prevent_web_conference_recording
settings_telephony_calls_imported to telephony_calls_imported
settings_web_conferences_recorded to web_conferences_recorded

We have renamed the following columns in the USER_SPOKEN_LANGUAGE table:

language to languages
primary to primarys

We have renamed the following columns in the TRANSCRIPT_SENTENCE table:

end to end_time
start to start_time

We have designated the manager_id column in the USERS table as a foreign key.

We have designated the parent_folder_id column in the LIBRARY_FOLDER table as a foreign key.

Now, the following columns in the tables below have a foreign key relationship to the USERS table:

COLUMN	TABLE
`primary_user_id`	`CALL`
`added_by`	`CALL_IN_FOLDER`
`created_by`	`LIBRARY_FOLDER`
`updater_user_id`	`SCORECARD`
`updater_user_id`	`SCORECARD_QUESTION`

Intercom

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 the CONVERSATIONS table.
We have added the title and team_assignee_id column to the CONVERSATIONS table.
We have added the inbox_seat column to the ADMIN table.
We now support conversation topics data.
We have added support for custom conversation attributes.

Jira

We have added a new column, is_active, to the USER table.

Kantata

We have added a new table, BILLABLE_UTILIZATION. For more information, see Kantata's Billable Utilizations documentation. We are gradually rolling out this change to all existing connectors.

Marketo

We have added a new table, ACTIVITY_TYPE_ATTRIBUTE.

Pendo

You can now exclude the following tables from your syncs:

ACCOUNT_APPLICATION_HISTORY
ACCOUNT_HISTORY
APPLICATION_HISTORY
EVENT
FEATURE_ELEMENT_PATH_RULE_HISTORY
FEATURE_EVENT
FEATURE HISTORY
GUIDE_EVENT
GUIDE_HISTORY
PAGE_EVENT
PAGE_HISTORY
PAGE_RULE_HISTORY
POLL_EVENT
TRACK_TYPE_EVENT
TRACK_TYPE_HISTORY
TRACK_TYPE_RULE_HISTORY

By default, we include these tables in syncs. To exclude the tables, go to the Schema tab of your connector details page and deselect the tables.

Pipedrive

We have added two new columns, org_id and lead_id, to the NOTE table.

QuickBooks

We have added a new column, customer_type_id, to the CUSTOMER table. To backfill the missing data for the customer_type_id column, contact our support team or trigger a connector re-sync.

Zendesk Support

We have added two new columns, phone_number_id and call_group_id, to the CALL_METRIC table.

Improvements

ADP Workforce Now

You can now select the following tables to sync from the Schema tab on your connector details page:

BUSINESS_COMMUNICATION
PERSON_COMMUNICATION
PERSON_GOVERNMENT_ID

Azure Cosmos DB

We have changed the sync strategy of our Azure Cosmos DB connectors. We no longer:

Enable Teleport Capture Deletes by default for new connectors. Contact our support team to enable this feature if you want to track deleted Azure Cosmos DB source data.
Trigger automatic re-syncs when a connector's Teleport data is missing or corrupted. Instead, we generate a warning message that prompts you to trigger the re-sync manually.

These changes prevent the unnecessary processing of source data and improve the performance of connectors that don't require capturing deleted source data.

Braze

The Braze connector now supports table blocking for all Braze tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables. If you want to sync a child table, you must include the parent table in the sync.

Crossbeam

We now capture deletes for all Crossbeam tables.

Facebook Ads

We have upgraded our Facebook Ads connector to version 16.0 of the Facebook API. For more information, see Facebook's v16.0 changelog.

Functions

We have added an optional field, sync_id, to Fivetran's request format. sync_id is the Fivetran sync identifier (UUID). You can use the sync_id to debug and link function logs with connector logs. For more information, see our Request format documentation. We are gradually rolling out this feature to all existing connectors.

Gong

You can now configure your Gong connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

Google Ads

We have changed our sync strategy and no longer perform an automatic table re-sync if:

A field is added to or removed from a custom report
The report name has changed

Previously, when we changed the available field set to match changes in the Google API, we performed a table re-sync for the affected reports, which may have contributed to higher MAR.

Google Campaign Manager 360

We have upgraded our Google Campaign Manager 360 connector from version 3.5 to 4 of the Campaign Manager 360 API. For more information about the changes, see Campaign Manager 360 API's changelog.

High-Volume Agent Db2 for i

You can now configure your High-Volume Agent Db2 for i connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.

HubSpot

For connectors created after November 11, 2022, we have removed the sync dependency of the DEAL_STAGE table on the DEAL_PROPERTY_HISTORY table. To sync the DEAL_STAGE table, you no longer need to select the DEAL_PROPERTY_HISTORY table in the Schema tab. We are gradually rolling out this improvement for connectors created before November 11, 2022.

MongoDB

We now use Change Streams as the default incremental sync strategy. For more information about change streams, see our documentation.

PostgreSQL

We added an additional layer of validation to proactively catch mismatches between PostgreSQL sources and Snowflake destinations, such as missing rows. We are gradually rolling out this new feature to all PostgreSQL connectors sending data to Snowflake.

Reddit Ads

You can now sync multiple linked Reddit accounts to your Reddit Ads connector. Learn how in our Reddits Ads setup guide.

Our Reddit Ads connector is now generally available. Read our Reddit Ads connector documentation.

Salesforce Commerce Cloud

The Salesforce Commerce Cloud connector now supports table blocking for all Salesforce Commerce Cloud tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables. If you want to sync a child table, you must include the parent table in the sync.

Stripe

We now update the three_d_secure column of the CARD table in the destination as 'attempted' when we receive a JSON response. For more information about three_d_secure fields, see Stripe's documentation.

You can backfill the data for the three_d_secure columns in the CARD and PAYMENT_METHOD_CARD tables. Perform a re-sync for the CARD and PAYMENT_METHOD_CARD tables. This will result in re-syncing the associated parent and child tables.

Webhooks

We have added support for Hash-based Message Authentication Code (HMAC) and Token based authentication to authenticate incoming events. For more information, see our setup instructions and the REST API configuration parameters.

Workday HCM

We now capture deletes for the POSITION table. Perform a table re-sync if you want to capture deletes for the data we have already synced to the destination table.

REST API Improvements

Crossbeam

You can now configure your Crossbeam connector using the Fivetran REST API. This feature is available only for Free, Standard, Enterprise, and Business Critical accounts.