December 2021

Cloud Service Provider - Azure support

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 Improvements

Edit other users' notifications

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.

edit_other_users_

Learn more about managing other users' notifications in our Notifications documentation.

In-Product Automated Plan Promotion

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.

active_promotion

Sync History Chart - Event Indications

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

important_sync_events

Fivetran Business Critical

Azure Private Link

We now support Azure Private Link for Business Critical accounts. Azure Private Link 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 Model

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 Core

dbt 0.21.1 support

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

Specify target name

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 changes

Asana

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

Iterable

We have added a new table, EXPERIMENT_METRICS, that stores the metrics generated for a given experiment on a particular day.

Lever

We have added a new column, hiring_manager_id, to the POSTING table.

Stripe

We added a new column, reporting_category, to the BALANCE_TRANSACTION table.

Twitter

We have added a new column, duration, to the MEDIA_LIBRARY table for storing video length values.

Improvements

Adobe Analytics

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 Now

The ADP Workforce Now connector now supports history mode for the PERSON and WORK_ASSIGNMENT tables.

Criteo

We have upgraded our Criteo connector from version 2021.01 to 2021.10 of the Criteo API.

Facebook Pages

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.

GitHub

You can now opt to use a Personal access token to authenticate GitHub. For more information, see our setup instructions.

Google Ads

We have changed the design of the Authorize and Re-Authorize buttons to comply with Google's Sign-In Branding Guidelines.

Instagram Business

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 Pages

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 Advertising

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.

MongoDB

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.

Salesforce

We now support the IsArchived field. We are gradually rolling out this improvement to all existing connectors. If you'd like to sync the IsArchived field, contact our support team.

SAP Concur

The SAP Concur connector now supports syncing data with individual API endpoint access. For more information, see our setup instructions.

Stripe

We have added a new table, ISSUING_TRANSACTION, that contains data from Stripe's /issuing/transactions endpoint.

Twitter Organic

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 Support

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 Improvements

Added Generate button

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.

api_config_improvements

Changed metadata endpoint paths

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 events

sync_end log event generation

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.