March 2022

Fivetran Azure UK Servers

We have added new servers in the Azure UK South (uksouth) region.

If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in UK, your data does not leave UK during processing.

If you're on an Enterprise or Business Critical plan, this is the default region if you choose UK as your data processing location and Azure as your cloud provider.

We now support Azure Private Link connections to sources and destinations in the uksouth region.

For more information, see our data residency documentation.

Transformations for dbt Core

dbt Core versions 1.0.3 and 1.0.4 support

We now support dbt Core 1.0.3 and 1.0.4. You can use these versions to run your projects.

New connectors

Adjust

Adjust is a mobile measurement and fraud prevention platform.

Read our Adjust connector documentation.

Schema changes

Apple App Store

We have added the following new report tables to sync Downloads metrics:

• DOWNLOADS_TERRITORY_SOURCE_TYPE_REPORT
• DOWNLOADS_TERRITORY_APP_REFERRER_REPORT
• DOWNLOADS_TERRITORY_WEB_REFERRER_REPORT
• DOWNLOADS_TERRITORY_CAMPAIGN_REPORT
• DOWNLOADS_SOURCE_TYPE_DEVICE_REPORT
• DOWNLOADS_APP_REFERRER_DEVICE_REPORT
• DOWNLOADS_WEB_REFERRER_DEVICE_REPORT
• DOWNLOADS_CAMPAIGN_DEVICE_REPORT
• DOWNLOADS_PLATFORM_VERSION_SOURCE_TYPE_REPORT
• DOWNLOADS_PLATFORM_VERSION_APP_REFERRER_REPORT
• DOWNLOADS_PLATFORM_VERSION_WEB_REFERRER_REPORT
• DOWNLOADS_TPLATFORM_VERSION_CAMPAIGN_REPORT

The new DOWNLOADS_* tables replace the APP_UNITS_* tables.

We have added support for three new metrics, first_time_downloads, redownloads, and total_downloads.

We will continue to sync the APP_UNITS_* tables for another three months and will discontinue the replaced tables after June 15, 2022. Be sure to update your queries with the new table names before we remove the old tables.

For more information about the new tables and metrics, see our Analytics Tables documentation.

Apple Search Ads

We have added the following new tables:

• AD_HISTORY
• CREATIVE_HISTORY
• PRODUCT_PAGE_HISTORY
• PRODUCT_PAGE_LOCALE

We have added a new report, AD_LEVEL_REPORT.

We have added two new fields, avg_cpm_amount and avg_cpm_currency, for all reports.

Asana

We now sync a new column, created_by_id, to the TASK table.

GitHub

We now sync data for review comments on a pull request to the PULL_REQUEST_REVIEW_COMMENT table. We are gradually rolling out this feature to all existing connectors. Once this feature is available, you will see the PULL_REQUEST_REVIEW_COMMENT table on the Schema tab. To fetch comments for all pull requests, re-sync your connector.

Google Ads

We have added a new report, AD_GROUP_AD_ASSET_COMBINATION_VIEW.

We have added the following fields to the CUSTOMER report:

• customer.status
• customer.conversion_tracking_setting.accepted_customer_data_terms
• customer.conversion_tracking_setting.conversion_tracking_status
• customer.conversion_tracking_setting.enhanced_conversions_for_leads_enabled

We have added the following fields to the reports below:

• ad_group.audience_setting.use_audience_grouped to the AD_GROUP report
• ad_group_criterion.audience.audience to the AD_GROUP_CRITERION report
• campaign.audience_setting.use_audience_grouped and campaign.shopping_setting.use_vehicle_inventory to the CAMPAIGN report
• hotel_reconciliation.campaign to the HOTEL_RECONCILIATION report

Height

We have added a new table, TASK_FIELD_USER, that stores information from custom fields with user type.

Jira

We now sync the following ISSUE custom field types:

• Rank syncs to your destination as a lexorank algorithm string.
• Team syncs to your destination as an integer value. The integer acts a team identifier. We had also added a new table, TEAM, that contains additional team data.

To learn how we sync custom fields for Jira, see our June 2020 release note.

Qualtrics

We have added a new table, DISTRIBUTION_CONTACT.

Snowplow

We have added a new table, BAD_EVENT, that stores the events that do not conform to the Snowplow Canonical Event format.

TikTok Ads

We have added new IN-APP METRICS fields to the following reports:

• CAMPAIGN_REPORT_DAILY
• CAMPAIGN_REPORT_HOURLY
• ADGROUP_REPORT_DAILY
• ADGROUP_REPORT_HOURLY
• AD_REPORT_DAILY
• AD_REPORT_HOURLY

For more information about the fields, see our prebuilt reports documentation.

Twilio

We are now testing an alternative approach using Twilio's Participant Summary resource to fetch data for conference participants. We have added two new tables, CONFERENCE_PARTICIPANT_EXTENDED and COACHED_CALL. If you'd like to enable this feature on your connector, contact our support team.

Xero

We have added a new column, add_to_watch_list, to the ACCOUNT table.

Zoho CRM

We have added a new column, parent_id, to the NOTE table.

Improvements

AWS MSK

We have added support for AWS PrivateLink connections to AWS MSK. If you're on a Business Critical plan, you can now opt to connect using AWS PrivateLink. In the connector setup form, select the Connection method as Connect via PrivateLink. For more information, see our setup instructions.

Databricks

We now use Azure Blob Storage as the staging location for our temporary files if:

• Your Databricks cluster is hosted on Azure
• Your Databricks cluster is a SQL Endpoint cluster
• Your Databricks cluster is a general purpose cluster with DBR version 10.2 or greater

Facebook Pages

We have upgraded our Facebook Pages connector from version 12.0 to 13.0 of the Facebook Marketing API. Learn more about the changes in the Facebook Marketing API v13.0 changelog.

Google Ads

We have upgraded our Google Ads connector to version 10 of the Google Ads API. For more information, see Google's v10.0 release note.

Height

The Height connector now supports OAuth authorization.

Instagram Business

We have upgraded our Instagram Business connector from version 12.0 to 13.0 of the Graph API. Learn more about the changes in the Facebook API v13.0 changelog.

Kustomer

We now capture deletes for the TEAM_MEMBER and CONVERSATION_TAG tables.

Mailchimp

We have fixed a bug where we imported the recipient data for each automated email to the AUTOMATION_RECIPIENT table only once, and in the subsequent syncs, we skipped new email recipient data. Now, if we find new email recipient data, we re-import the AUTOMATION_RECIPIENT table in full.

MariaDB

Fivetran Teleport Sync is now available in beta. Learn more in our Fivetran Teleport Sync for MariaDB documentation.

MySQL

Fivetran Teleport Sync is now available in beta. Learn more in our Fivetran Teleport Sync for MySQL documentation.

NetSuite SuiteAnalytics

We have added support for the NetSuite2.com data source. We are gradually rolling out this feature to all our existing users.

You can now create new NetSuite connectors that sync data from the NetSuite2.com data source into your destination.

NOTE: If your NetSuite account provides access to both data sources, you can sync data from both data sources using a separate connector for each data source. However, we do not support switching data sources for existing NetSuite connectors.

Pendo

Pendo processes data at the top of each hour, and it can take up to 15 minutes past the hour for that data to be available. As a result, events data is not immediately available to Fivetran through the API but within 15 minutes past the hour. We have updated our API calls for the VISITOR, EVENT, and POLL_EVENT tables to include a rollback time for the end cursors to fetch the data.

Sage Intacct

We have released pre-built, dbt Core*-compatible data models for Sage Intacct. Find the models 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.

Salesforce

The Salesforce connector no longer supports Live mode. We have migrated the existing connectors on Live mode to Soft Delete mode. You can also use history mode to track the history of your data.

Snowflake

You no longer need to include the word "fivetran" in your Snowflake username.

SurveyMonkey

We have fixed a bug where we didn't sync the following columns to the RECIPIENT table:

• mail_status
• custom_fields
• remove_link
• extra_fields
• survey_link

To sync these columns for surveys that already have been synced to your destination, trigger a historical sync.

REST API Improvements

Google Ads

We've updated the REST API config format for the Google Ads connector. See the Google Ads configuration section in our REST API documentation for details.

Instagram Business

We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Instagram Business connector by adding the auth section to payloads.

Zoho CRM

We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Zoho CRM connector by adding the auth section to payloads.