September 2020

Audit Tables

We have deprecated the two audit tables, _fivetran_audit and _fivetran_audit_warning. We will stop populating the tables on November 6, 2023.

You can use our Fivetran Platform Connector along with our Fivetran Platform Connector data model to recreate the _fivetran_audit table in your destination. The pre-built data model uses the data stored in the log tables to create fivetran_platform__audit_table matching the _fivetran_audit table.

Single Sign-on Using Azure Active Directory

We have added Microsoft Entra ID (formerly Azure Active Directory) as an officially supported SAML identity provider. Now you can find Fivetran in the Microsoft Entra ID application gallery. This feature is in beta.

Read our setup guide to learn how to set up SSO with Microsoft Entra ID.

Transformations for dbt Core

We have released the beta version of dbt Transformations. Now you can connect directly to your Git provider and orchestrate your dbt models through Fivetran.

Read our dbt Transformations documentation to learn more.

We have updated our dbt runtime environment to version 0.18.0. Check the dbt migration guide and make sure your dbt projects work correctly with the new version.

Schema changes

Braintree

We have added a new table, LOCAL_PAYMENT_DETAILS. See Braintree's documentation for more information.

HubSpot

We have added a new child table, CALENDAR_USER, to the CALENDAR_EVENT table.

Pendo

We now sync property data in the TRACK_TYPE_EVENT table. We sync each property to the destination in its own column and add the prefix property_ to the column name. For example, the file property is synced to the destination as the property_file column.

Shopify

We have added two new tables, GIFT_CARD and USER to support Shopify Plus APIs.

We have replaced the COLLECT table with the COLLECTION_PRODUCT table. We have deprecated the COLLECT table because the Shopify API no longer supports the Collect endpoint.

We have added the following new fields to the tables below:

app_id to the ORDER table
note to the CUSTOMER table

Stripe

We have added the following new columns to the tables below:

is_deleted and capabilities_platform_payments to the ACCOUNT table
verification_data_expiry_check to the AUTHORIZATION table
livemode to the ORDER_RETURN table
id to the SUBSCRIPTION_DISCOUNT table

We now support metadata_* columns in the AUTHORIZATION table.

Xero

We have added a new column, manual_journal_id, to the MANUAL_JOURNAL_LINE_HAS_TRACKING_CATEGORY table.

Zendesk Support

We have added a new table, ARTICLE, which stores details about all Help Center articles. Learn more in Zendesk's Articles documentation.

Improvements

Adobe Analytics

We now support Adobe Analytics 2.0 APIs. All new connectors created after September 22, 2020 will support Analytics 2.0 APIs. Existing connectors will continue to use Analytics 1.4 APIs.

Adobe Analytics Data Feed

You can now opt not to split array elements into child tables. By default, Fivetran splits array elements and syncs the multivalued attributes into child tables.

On the connector setup form, set the Should Split Arrays toggle to OFF, and we will sync the arrays as a JSONArray into your destination.

AdRoll

The AdRoll 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. AdRoll's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.

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

Apple App Store

We have renamed our iTunes Connect connector to Apple App Store. This name change applies to the Fivetran dashboard and our documentation.

AWS Inventory

We now sync data from all the regions that are available in your AWS account. To learn how to configure your account to give us access to data from all regions, see our AWS Inventory setup guide.

BigQuery

We have added a new connector setup test to validate if billing has been enabled for the BigQuery project.

Criteo

The Criteo 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. Criteo's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.

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

Google Ads

We improved the way we sync Placement Performance report data. Previously, the only AdNetworkTypes that the report contained were Display Network. Now, it receives placement data for all network types: Display Network, Search Network, YouTube Search, YouTube Videos, and Cross-network.

Google Campaign Manager 360

We now support the Path to Conversion report type in our Google Campaign Manager 360 connector. If you'd like to enable this feature on your connector, contact our support team.

Google Sheets

We simplified setup for our Google Sheets connector. We now only require the URL of the Google spreadsheet. You no longer need to identify the value between the "/d/" and the "/edit" in your spreadsheet URL when setting up new connectors.

Jira

We enable the improved schema by default for connectors set up after September 10, 2020. See our June 2020 release note for details about the improvements, which were previously opt-in, but are now default.

Kustomer

You can now exclude the following tables from the sync:

CARD
COMPANY
CONVERSATION
CUSTOMER
KOBJECT
MESSAGE
NOTE
NOTIFICATION
QUEUE
SHORTCUT
SNOOZE
TAG
TEAM
TEAM_QUEUE
USER

On your connector details page, go to the Schema tab and deselect the tables you want to exclude.

Microsoft Advertising

We have released pre-built, dbt Core-compatible data models for Microsoft Advertising. Find the models in Fivetran's dbt hub or data models documentation. 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.

Optimizely

You can now exclude the following tables from the sync:

DECISION
CONVERSION
RESULT

On your connector details page, go to the Schema tab and deselect the tables you want to exclude.

Pinterest Ads

We have released pre-built, dbt Core-compatible data models for Pinterest Ads. Find the models in Fivetran's dbt hub or data models documentation. 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.

PostgreSQL

We have added a new test in the PostgreSQL destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your PostgreSQL destination, you must grant the fivetran user permission to create temporary tables in your PostgreSQL database. To learn how, see the setup guide for your PostgreSQL implementation:

Redshift

We have added a new test in the Redshift destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your Redshift destination, you must grant the fivetran user permission to create temporary tables in your Redshift destination. To learn how, see our Redshift setup guide.

Salesforce

We now use Salesforce's Bulk API 2.0 for your connector's historical syncs. Previously, we used the REST API for the historical syncs. We are gradually rolling out this new feature to all existing connectors. If you'd like to enable this feature on your connector, contact our support team.

You can now select the FIVETRAN_FORMULA and FIVETRAN_FORMULA_HISTORY tables to sync from the Schema tab on your connector details page. We are gradually rolling out this new feature to all existing connectors. If you'd like to enable this feature on your connector, contact our support team.

Shopify

We have released pre-built, dbt Core-compatible data models for Shopify. Find the models in Fivetran's dbt hub or data models documentation. 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.

Snowflake

We have added a new test in the Snowflake destination setup form to verify CREATE SCHEMA and CREATE TEMPORARY TABLES permissions. When you set up your Snowflake destination, the new test will automatically validate these permissions.

SQL Server

We have optimized the queries that we use to retrieve table and column metadata from your database during our data syncs. Our new queries improve your sync speed, especially if you have large schemas.

Twilio

You can now select the accounts you want to sync in your Twilio connector. See our Twilio setup guide for details.

YouTube Analytics

Our YouTube Analytics connector is now generally available.

Read our YouTube Analytics connector documentation.

Zendesk Chat

We have added a new table, ENGAGEMENT, which stores information about your agents' chat engagements.

Zendesk Support

We have released pre-built, dbt Core-compatible data models for Zendesk Support. Find the models in Fivetran's dbt hub or data models documentation. 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.

REST API Improvements

Connect Card

We have added a new optional parameter, hide_setup_guide, to our Connect Card. It lets you hide the embedded setup guide.

New Public API Endpoints

We have implemented a new Connector Management API endpoint for our REST API. You can now leverage the new Retrieve Source Table Columns Config feature.

Log events

New Log Event

We have added a new log event, change_schema_config_via_sync. See our Logs documentation for more information.