December 2021link
Cloud Service Provider - Azure supportlink
We now use Microsoft Azure as a cloud service provider in addition to Google Cloud Platform (GCP) and Amazon Web Services (AWS). Depending on the plan you are on, you can now select the cloud service provider (Azure, GCP, or AWS) your connectors are run on.
See our Data Residency documentation for more details.
Dashboard Improvementslink
Edit other users' notificationslink
You can now edit the notifications settings for other users on your account. To edit another user's settings, go to the Notifications tab in the Fivetran dashboard and click Switch Recipient.
IMPORTANT: This feature is only available for users with an Account Administrator or a custom role that has permissions to manage users and view connectors and transformations. Learn more about user roles in our role-based access control documentation.
Learn more about managing other users' notifications in our Notifications documentation.
In-Product Automated Plan Promotionlink
We are gradually rolling out an In-Product Automated Plan Promotion that lets you try out features available on a higher-tier plan for 28 days. To activate the promotion, follow the instructions that appear when you click the Learn more link beside the relevant feature in your Fivetran dashboard.
After the promotion is activated, you can see the Plan Promotion pane displaying the available features on the main dashboard page.
Sync History Chart - Event Indicationslink
We have added indications to the Sync History chart that notify you about major sync events. We generate indications for the following events:
- Sync failures
- Schema changes
- Warnings
- Historical re-syncs
- Requested re-syncs
Fivetran Business Criticallink
Azure Private Linklink
We now support Azure Private Link for Business Critical accounts. Azure Private Link allows allows Virtual Networks (VNets) and Azure-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. You can use Azure Private Link with your source, destination, or both your source and destination.
Learn more in our database connection and destination connection documentation.
Social Media Reporting Data Modellink
Fivetran has created a dbt Core*-compatible social media reporting model that aggregates data from our most popular social media connectors into a unified table. This pre-built model allows you to compare how your posts perform on each social media platform.
The social media reporting model supports the following connectors:
- Facebook Pages
- Instagram Business
- LinkedIn Company Pages
- Twitter Organic
You do not need to have all four social media connectors to use this model, though you should have at least two.
Learn more in our social media reporting model 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.
Transformations for dbt Corelink
dbt 0.21.1 supportlink
We now support dbt 0.21.1. You can use this version to run your projects.
Specify target namelink
Now, you can specify the target name in the dbt project setup form. The specified value overrides the target name value present in deployment.yml
.
Schema changeslink
Asanalink
We have added a new table, PROJECT_STATUS
, that stores historical information about project status changes.
We now sync the following custom field properties to the CUSTOM_FIELD
table:
id
name
description
type
workspace_id
project_id
Iterablelink
We have added a new table, EXPERIMENT_METRICS
, that stores the metrics generated for a given experiment on a particular day.
Leverlink
We have added a new column, hiring_manager_id
, to the POSTING
table.
Stripelink
We added a new column, reporting_category
, to the BALANCE_TRANSACTION
table.
Twitterlink
We have added a new column, duration
, to the MEDIA_LIBRARY
table for storing video length values.
Improvementslink
Adobe Analyticslink
The Adobe Analytics 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. Adobe Analytics' priority-first syncs fetch the last fifteen days' worth of data from the reporting tables.
To learn more, see our priority-first sync documentation.
ADP Workforce Nowlink
The ADP Workforce Now connector now supports history mode for the PERSON
and WORK_ASSIGNMENT
tables.
Criteolink
We have upgraded our Criteo connector from version 2021.01 to 2021.10 of the Criteo API.
Facebook Pageslink
We have released pre-built, dbt Core-compatible data models for Facebook Pages. Find the model in Fivetran's dbt hub. 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.
GitHublink
You can now opt to use a Personal access token to authenticate GitHub. For more information, see our setup instructions.
Google Adslink
We have changed the design of the Authorize and Re-Authorize buttons to comply with Google's Sign-In Branding Guidelines.
Instagram Businesslink
We have released pre-built, dbt Core-compatible data models for Instagram Business. Find the model in Fivetran's dbt hub. 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.
LinkedIn Company Pageslink
Our LinkedIn Company Pages connector is now generally available. Read our LinkedIn Company Pages connector documentation.
We have released pre-built, dbt Core-compatible data models for LinkedIn Company Pages. Find the model in Fivetran's dbt hub. 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.
Microsoft Advertisinglink
To stay up to date with Microsoft Bulk API, we have decreased the lookback period for downloading campaigns from 90 days to 30 days. If you have paused your connector for more than 30 days, the connector may not sync older metadata changes.
MongoDBlink
We now support MongoDB database versions 4.4 to 5.0. To learn more, read MongoDB's 5.0 changelog.
We now support Read-Only and Analytics nodes. You must configure read preference and tags based on the node type. For more information, see Specify Read Preference for a MongoDB Cluster.
Salesforcelink
We now support the IsArchived
field. We are gradually rolling out this improvement to all existing customers. If you'd like to sync the IsArchived
field, contact our support team.
SAP Concurlink
The SAP Concur connector now supports syncing data with individual API endpoint access. For more information, see our setup instructions.
Stripelink
We have added a new table, ISSUING_TRANSACTION
, that contains data from Stripe's /issuing/transactions endpoint.
Twitter Organiclink
We have renamed the Twitter connector to Twitter Organic. The service name remains the same, so you do not have to update your API configuration.
Our Twitter Organic connector is now generally available. Read our Twitter Organic connector documentation.
We have released pre-built, dbt Core-compatible data models for Twitter Organic. Find the model in Fivetran's dbt hub. 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.
Zendesk Supportlink
We now exclude the USER_VOTE
table from syncs by default because it can be a large table and may degrade performance.
If you want to sync the USER_VOTE
table, go to the Schema tab of your Fivetran dashboard and select it. Learn how in our connector schema documentation.
REST API Improvementslink
Added Generate buttonlink
We have removed the Show button in the API config section on the Security tab of your Account Management page. Click the Generate button to view your API key and secret.
Click Generate new secret to generate a new API secret and replace the existing secret.
Changed metadata endpoint pathslink
We now use connector-types
instead of connectors
in the paths for the following metadata endpoints:
- Retrieve source metadata - the new path format is as follows: https://api.fivetran.com/v1/metadata/connector-types
- Retrieve connector config metadata - the new path format is as follows: https://api.fivetran.com/v1/metadata/connector-types/{connector_type}
We support the old path format for backward compatibility. The sunset date for the old path format is April 1, 2022.
Log eventslink
sync_end log event generationlink
We now generate the sync_end
log event in our logs for every possible sync status:
SUCCESSFUL
FAILURE
FAILURE_WITH_TASK
RESCHEDULED
Previously, we generated the sync_end
log event only for successful syncs.