September 2020

---

Audit Tables

We have deprecated the two audit tables, fivetran_audit and fivetran_audit_warning. We will stop populating the tables with the sync logs after March 3, 2021.

We recommend you to use the Fivetran Log Connector to track your sync logs.

---

dbt Transformations

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.

---

Single Sign-on Using Azure Active Directory

We have added Azure Active Directory as an officially supported SAML identity provider. Now you can find Fivetran in the Azure AD application gallery. This feature is in beta.

Read our setup guide to learn how to set up SSO with Azure AD.

---

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 sub-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 added a new field, app_id, to the ORDER 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 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.

Campaign Manager

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

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 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 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 a pre-built dbt package for Microsoft Advertising. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

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 a pre-built dbt package for Pinterest Ads. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

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 customers. If you'd like to enable this feature on your connector, contact our support team.

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.

Verizon Media

We have renamed our Yahoo Gemini connector to Verizon Media. This name change applies to the Fivetran dashboard and our documentation.

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 a pre-built dbt package for Zendesk Support. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

---

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 take advantage of the new Retrieve Source Table Columns Config feature.

---

Log events

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