April 2022link
Dashboard Improvementslink
Users - Multiple Accounts and Re-authenticationlink
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 Pricinglink
HVR customers 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 customers 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 Corelink
dbt Core version 1.0.5 supportlink
We now support dbt Core 1.0.5. You can use this version to run your projects.
New connectorslink
DocumentDBlink
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 4link
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 changeslink
Asanalink
We have added the following new tables that store data about goals in Asana:
GOAL
GOAL_FOLLOWER
GOAL_STATUS
GOAL_SUPPORTING_WORK
Coupalink
We have added a new table, SUPPLIER_ADDRESS
, that stores the supplier's address.
Criteolink
We have added two new fields, campaign_id
and media_type
, to the ADSET
table.
We have added a new table, CAMPAIGN
.
GitHublink
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
.
Jiralink
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.
Kustomerlink
We have added a new column, source
, to the MESSAGE
table.
Mailchimplink
We have added the following new tables to sync Member Tags and Member Interests:
TAGS
TAG_MEMBER
INTEREST
INTEREST_MEMBER
INTEREST_CATEGORY
Mixpanellink
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.
MongoDBlink
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.
PostgreSQLlink
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.
QuickBookslink
We have added a new table, CREDIT_CARD_PAYMENT_TXN
.
Snowplowlink
We have deprecated the dvce_tstamp
field. Make sure that your queries don't contain this field.
Improvementslink
Branchlink
Our Branch connector is now generally available.
Read our Branch connector documentation.
Google Adslink
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 Consolelink
We have added support for the news
search type in reports.
NetSuite SuiteAnalyticslink
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.
Outbrainlink
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 Concurlink
Our SAP Concur connector is now generally available.
Read our SAP Concur connector documentation.
REST API Improvementslink
Google Search Consolelink
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 controllink
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 resourcelink
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:
- Create account webhook
- Create group webhook
- Retrieve webhook details
- Update webhook
- Delete webhook
- Retrieve the list of webhooks
- Test webhook
Pinterest Adslink
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 Organiclink
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.
Verizon Medialink
We have expanded the Create a Connector and Modify a Connector endpoints of our REST API. Now you can authorize the Verizon Media connector by adding the auth
section to payloads.
YouTube Analyticslink
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.