March 2022link
Fivetran Azure UK Serverslink
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 Corelink
dbt Core versions 1.0.3 and 1.0.4 supportlink
We now support dbt Core 1.0.3 and 1.0.4. You can use these versions to run your projects.
New connectorslink
Adjustlink
Adjust is a mobile measurement and fraud prevention platform.
Read our Adjust connector documentation.
Schema changeslink
Apple App Storelink
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 deprecate 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 Adslink
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.
Asanalink
We now sync a new column, created_by_id
, to the TASK
table.
GitHublink
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 Adslink
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 theAD_GROUP
reportad_group_criterion.audience.audience
to theAD_GROUP_CRITERION
reportcampaign.audience_setting.use_audience_grouped
andcampaign.shopping_setting.use_vehicle_inventory
to theCAMPAIGN
reporthotel_reconciliation.campaign
to theHOTEL_RECONCILIATION
report
Heightlink
We have added a new table, TASK_FIELD_USER
, that stores information from custom fields with user
type.
Jiralink
We now sync the following ISSUE
custom field types:
Rank
syncs to your destination as alexorank 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.
Qualtricslink
We have added a new table, DISTRIBUTION_CONTACT
.
Snowplowlink
We have added a new table, BAD_EVENT
, that stores the events that do not conform to the Snowplow Canonical Event format.
TikTok Adslink
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.
Twiliolink
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.
Xerolink
We have added a new column, add_to_watch_list
, to the ACCOUNT
table.
Zoho CRMlink
We have added a new column, parent_id
, to the NOTE
table.
Improvementslink
AWS MSKlink
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.
Databrickslink
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 Ad Accountlink
We have upgraded our Facebook Ad Account 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.
Facebook Ad Insightslink
We have upgraded our Facebook Ad Insights 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.
Facebook Pageslink
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 Adslink
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.
Google Analyticslink
We now check for deprecated dimensions and metrics during the sync and display a warning in your Fivetran dashboard if we find any deprecated dimensions or metrics.
Heightlink
The Height connector now supports OAuth authorization.
Instagram Businesslink
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.
Kustomerlink
We now capture deletes for the TEAM_MEMBER
and CONVERSATION_TAG
tables.
Mailchimplink
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.
MariaDBlink
Fivetran Teleport Sync is now available in beta. Learn more in our Fivetran Teleport Sync for MariaDB documentation.
MySQLlink
Fivetran Teleport Sync is now available in beta. Learn more in our Fivetran Teleport Sync for MySQL documentation.
NetSuite SuiteAnalyticslink
We have added support for the NetSuite2.com data source. We are gradually rolling out this feature to all our existing customers.
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.
Pendolink
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 Intacctlink
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.
Salesforcelink
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.
Snowflakelink
You no longer need to include the word "fivetran" in your Snowflake username.
SurveyMonkeylink
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 Improvementslink
Google Adslink
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 Businesslink
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 CRMlink
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.