April 2022

Dashboard Improvements

Users - Multiple Accounts and Re-authentication

We're releasing a functionality that allows users to be added to multiple accounts. When switching between accounts with different authentication methods, users need to re-authenticate to gain access.

HVR - Consumption Based Pricing

HVR users using version 6.1.0/3 and above can now use Fivetran’s pricing model. Once you register your HVR hub systems with a Fivetran account, we calculate your usage based on the number of monthly active rows (MAR) across all of your sources and targets. This change applies to HVR users who renew or join after April 14, 2022.

Consumption-based pricing for HVR has several benefits:

You only pay for what you use
You can move higher data volumes at lower unit costs
You can add or remove sources and targets without needing to adjust your contract
You can view both HVR and Fivetran usage and billing within your Fivetran account

Learn more in our HVR pricing documentation.

Transformations for dbt Core

dbt Core version 1.0.5 support

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

New connectors

DocumentDB

DocumentDB is a fully-managed NoSQL database service that is built for JSON data management and integrated with AWS.

Read our DocumentDB database documentation.

Google Analytics 4

Google Analytics 4 is an analytics service that enables you to measure traffic and engagement across your websites and applications.

Read our Google Analytics 4 connector documentation.

Schema changes

Asana

We have added the following new tables that store data about goals in Asana:

GOAL
GOAL_FOLLOWER
GOAL_STATUS
GOAL_SUPPORTING_WORK

Coupa

We have added a new table, SUPPLIER_ADDRESS, that stores the supplier's address.

Criteo

We have added two new fields, campaign_id and media_type, to the ADSET table.

We have added a new table, CAMPAIGN.

GitHub

We have added a new table, PULL_REQUEST_READY_FOR_REVIEW_HISTORY, that stores the history of the convert_to_draft and ready_for_review events.

We are gradually rolling out this feature to all existing connectors. Once this feature is available, you will see the PULL_REQUEST_READY_FOR_REVIEW_HISTORY table on the Schema tab. To fetch events for all pull requests, re-sync your connector.

NOTE: The readyForReview column defines events in two ways:
false - marks an event as convert_to_draft.
true - marks an event as ready_for_review.

Jira

We now sync issue watchers to the ISSUE_WATCHER table. We are gradually rolling out this feature to all existing connectors. Once this feature is available, you will see the ISSUE_WATCHER table on the Schema tab. To fetch data for all issues, re-sync your connector.

NOTE: We apply this feature both to new issues and existing issues once they are changed. Fivetran does not consider assigning and unassigning issue watchers a change in an existing issue since there is no initial state in an existing issue for us to compare to.

Kustomer

We have added a new column, source, to the MESSAGE table.

Mailchimp

We have added the following new tables to sync Member Tags and Member Interests:

TAGS
TAG_MEMBER
INTEREST
INTEREST_MEMBER
INTEREST_CATEGORY

Mixpanel

We no longer sync the event_id column to the EVENT table. We now use the system column _fivetran_id to identify unique records. Previously, we used the event_id column to identify unique records.

MongoDB

For new MongoDB connectors, we now sync UUID in the STANDARD representation, which means that binary data is synced in BINARY format instead of transformed to VARCHAR. We will roll this change out to existing connectors on August 1, 2022. We will notify you before we apply this change to your connector so you can update your downstream queries.

PostgreSQL

The PostgreSQL connectors now only use soft deletes in the Soft Delete sync mode with all incremental update mechanisms. History mode doesn't use soft deletes regardless of your incremental update mechanism.

We fixed a bug that made our PostgreSQL connectors fail to parse arrays of complex types like POINT, TSRANGE, and TSTZRANGE for tables without primary keys. For these types, we now sync the raw values to the destination.

QuickBooks

We have added a new table, CREDIT_CARD_PAYMENT_TXN.

Snowplow

We have deprecated the dvce_tstamp field. Make sure that your queries don't contain this field.

Improvements

Branch

Our Branch connector is now generally available.

Read our Branch connector documentation.

Google Ads

We no longer support the AdWords API, because Google has deprecated the AdWords API. We have migrated all the existing active Google Ads connectors to the Google Ads API.

Google Search Console

We have added support for the news search type in reports.

NetSuite SuiteAnalytics

You can now use the NetSuite2.com data source to configure your NetSuite SuiteAnalytics connector. This feature is in beta. For more information, see our NetSuite SuiteAnalytics documentation.

Outbrain

The Outbrain connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Outbrain's priority-first syncs fetch the most recent 30 days' worth of data from the reporting tables.

To learn more, see our priority-first sync documentation.

SAP Concur

Our SAP Concur connector is now generally available.

Read our SAP Concur connector documentation.

REST API Improvements

Google Search Console

We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Google Search Console connector by adding the auth section to payloads.

New REST API endpoints to manage role-based access control

We have implemented the following new API endpoints for our REST API:

New resources: Team Management Private Preview
New endpoints in User Management: Connector memberships Private Preview

New Webhooks Management resource

We have implemented a new resource, Webhook Management, for our REST API. This feature is in beta. You can now leverage the following new features:

Pinterest Ads

We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Pinterest Ads connector by adding the auth section to payloads.

Twitter Organic

We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Twitter Organic connector by adding the auth section to payloads.

YouTube Analytics

We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the YouTube Analytics connector by adding the auth section to payloads.