January 2024

Dashboard Improvements

Connector list bulk actions

You can now pause, unpause, sync, or delete multiple connectors at once. Select or clear connectors by selecting the connector checkboxes.

You can now change the display mode by clicking Show Selected or Show All in the bulk actions panel.

Pausing and deleting connectors require additional confirmation.

Fivetran GCP US Servers

We have added new servers in the US (Iowa) 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 the US, your data does not leave the US during processing.

For more information, see our data residency documentation.

Lite Connectors

Lite connectors are now available for the following sources:

• Affinity
• Aha!
• Auth0
• Bitly
• Checkout.com
• Codefresh
• Concord
• Copper
• Cvent
• Dropbox Sign
• HappyFox
• Integrate
• Ivanti
• Klarna
• Maxio SaaSOptics
• Moloco
• Oracle Moat Analytics
• Paychex
• Pinterest Organic
• Piwik PRO
• Shortcut
• Standard Metrics
• Thinkific
• Yahoo Search Ads on Yahoo Japan

Proxy Agent

The Fivetran Proxy Agent connection method is now in beta. The Proxy Agent allows you to securely connect Fivetran to your database. Installed behind your firewall, it initiates communication with Fivetran, eliminating the need for other complicated networking options.

You can use Proxy Agent with the following connectors:

• HVA Db2 for i
• HVA Oracle
• HVA SAP ECC on Db2 for i
• HVA SAP ECC on Oracle
• HVA SAP ECC on SQL Server
• HVA SQL Server
• MariaDB
• MySQL
• PostgreSQL
• SQL Server

Transformations for dbt Core

Updated dbt Quickstart package

We have updated the Quickstart packages for the following connectors:

• Fivetran Platform Connector to version 1.4.0
• Google Ads to version 0.10.1

* 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.

Schema changes

Chargebee Product Catalog 2.0

We have added a new column, free_quantity, to the SUBSCRIPTION_ITEM_PRICE table.

ChartMogul

We have added a new column, proration_type, to the INVOICE_LINE_ITEM table.

We have added the following new columns to the INVOICE_TRANSACTION table:

• amount_in_cent
• transaction_fees_currency
• transaction_fees_in_cent

We have removed the activity_arr column from the ACTIVITY table.

Coupa

We have added a new table, BUDGET_LINE_ADJUSTMENT. Be sure to re-sync the connector to backfill the historical data or reach out to Fivetran Support to re-sync it for you.

Criteo

We have added a new table, AUDIENCE_ADSET, with the audienceId and adSetId fields.

We have removed the following fields from the AUDIENCE table:

• nbLines
• nbLinesEmail
• nbMatchesEmail

For more information, see the Criteo ERD.

Facebook Pages

We have added a new field, followers_count, to the PAGE table.

Freshdesk

We have added the following new tables that capture deletes:

• SLA_POLICY
• SLA_POLICY_APPLICABLE_TO
• SLA_POLICY_ESCALATION_NEXT_RESPONSE
• SLA_POLICY_ESCALATION_REMINDER_NEXT_RESPONSE
• SLA_POLICY_ESCALATION_REMINDER_RESOLUTION
• SLA_POLICY_ESCALATION_REMINDER_RESPONSE
• SLA_POLICY_ESCALATION_RESOLUTION
• SLA_POLICY_ESCALATION_RESPONSE
• SLA_POLICY_TARGET

We will sync these tables once daily. We are gradually rolling out this change to all existing connectors.

Google Ads

We have added the following reports:

• ANDROID_PRIVACY_SHARED_KEY_GOOGLE_AD_GROUP
• ANDROID_PRIVACY_SHARED_KEY_GOOGLE_CAMPAIGN
• ANDROID_PRIVACY_SHARED_KEY_GOOGLE_NETWORK_TYPE
• ASSET_GROUP_TOP_COMBINATION_VIEW

We have added a new field, ad_group_ad_asset_view.source, to the AD_GROUP_AD_ASSET_VIEW report.

We have added the following metrics and segments fields related to SKAdNetwork to the CUSTOMER and CAMPAIGN reports:

• metrics.sk_ad_network_installs
• metrics.sk_ad_network_total_conversions
• segments.sk_ad_network_coarse_conversion_value
• segments.sk_ad_network_postback_sequence_index
• segments.sk_ad_network_source_domain
• segments.sk_ad_network_source_type

We have added the following metrics fields to the TRAVEL_ACTIVITY_GROUP_VIEW and TRAVEL_ACTIVITY_PERFORMANCE_VIEW reports:

• metrics.search_absolute_top_impression_share
• metrics.search_budget_lost_absolute_top_impression_share
• metrics.search_budget_lost_impression_share
• metrics.search_budget_lost_top_impression_share
• metrics.search_impression_share
• metrics.search_rank_lost_absolute_top_impression_share
• metrics.search_rank_lost_impression_share
• metrics.search_rank_lost_top_impression_share
• metrics.search_top_impression_share

We have added the following fields to the TRAVEL_ACTIVITY_PERFORMANCE_VIEW report:

• segments.activity_account_id
• segments.activity_rating
• segments.external_activity_id

We have added the metrics.average_impression_frequency_per_user and metrics.unique_users fields to the CAMPAIGN report and segments.device for Display, Video, Discovery, and App campaigns.

We have added multiple fields for the following reports:

• AD_GROUP
• AD_GROUP_AD
• ASSET_GROUP_PRODUCT_GROUP_VIEW
• CAMPAIGN
• CUSTOMER
• KEYWORD_VIEW
• PRODUCT_GROUP_VIEW
• SHOPPING_PERFORMANCE_VIEW

We have renamed the following columns in the AD_LISTING_GROUP_CRITERION_HISTORY metadata table:

• product_bidding_category_country_code to product_category_country_code
• product_bidding_category_id to product_category_id
• product_bidding_category_level to product_category_level

We have renamed the following columns in the CAMPAIGN_CRITERION_LISTING_SCOPE_DIMENSION_HISTORY metadata table:

• product_bidding_category_country_code to product_category_country_code
• product_bidding_category_id to product_category_id
• product_bidding_category_level to product_category_level

We have renamed the metrics.sk_ad_network_conversions metric to metrics.sk_ad_network_installs .

We have made the following changes to the CUSTOMER report:

• added the customer.local_services_settings.granular_insurance_statuses field
• added the customer.local_services_settings.granular_license_statuses field
• removed the customer.offline_conversion_client_summaries field

We have made the following changes to the SHOPPING_PERFORMANCE_VIEW report:

• replaced segments.product_bidding_category_level1 with segments.product_category_level1
• replacedsegments.product_bidding_category_level2 with segments.product_category_level2
• replaced segments.product_bidding_category_level3 with segments.product_category_level3
• replaced segments.product_bidding_category_level4 with segments.product_category_level4
• replaced segments.product_bidding_category_level5 with segments.product_category_level5

We have made the following changes to the CAMPAIGN_SHOPPING_SETTING_HISTORY metadata table:

• added the feed_label field
• removed the sales_country field

Height

We have added a new column, number, to the TASK_FIELD table.

HiBob

We have renamed the following tables:

• EMPLYOEE_HOBBY to EMPLOYEE_HOBBY
• EMPLYOEE_NATIONALITY to EMPLOYEE_NATIONALITY
• EMPLYOEE_SUPER_POWER to EMPLOYEE_SUPER_POWER

Instagram Business

We have added a new field, navigation, to the MEDIA_INSIGHTS table.

We have deprecated the following metrics in the MEDIA_INSIGHTS table:

• carousel_album_engagement
• carousel_album_impressions
• carousel_album_reach
• carousel_album_saved
• carousel_album_video_views
• story_exits
• story_taps_back
• story_taps_forward
• video_photo_engagement

However, we kept the deprecated metrics to provide backward compatibility, and we will continue to fill them with the values that replaced them. For more details, see Instagram's changelog.

Integral Ad Science

We have made the following changes to the REPORT table:

• Removed the end_date and start_date columns from the REPORT table.
• Changed the composite primary key to ensure data integrity. The new composite primary key is a combination of the campaign_id, date, placement_id, and team_id columns. Be sure to update your queries.

Jira Align

We have added the following new tables:

• DEPENDENCY
• DEPENDENCY_LINK
• DEPENDENCY_STORY

Kustomer

We have added the following new tables:

• ASSISTANT
• ASSISTANT_DIALOG
• ASSISTANT_DIALOG_NODE
• CONVERSATION_TIME
• CONVERSATION_TIME_CREATED_BY_TEAM
• CUSTOMER_SHARED_WHATSAPP
• CUSTOMER_WHATSAPP

We have added the following new columns to the CONVERSATION and CONVERSATION_HISTORY tables:

• assistant_emulation
• assistant_id
• assistant_status
• assistant_transferred_at
• assistant_type

We are gradually rolling out these changes to all existing connectors.

We now sync custom columns to the USER table. To identify a custom column, we add a prefix, custom_, to the column name.

Linear

We have added the following new tables:

• ISSUE_LABEL
• LABEL
• LABEL_CHILDREN

LinkedIn Ad Analytics

We have added the following new tables:

• LEAD_FORM_HISTORY
• LEAD_FORM_CONSENT
• LEAD_FORM_HIDDEN_FIELD
• LEAD_FORM_MULTIPLE_CHOICE_QUESTION_OPTION
• LEAD_FORM_QUESTION
• LEAD_FORM_REJECTION_REASON

We have added two new tables, SPONSORED_MESSAGE_CONTENT and SPONSORED_MESSAGE_OPTION.

We now retrieve Posts and Shares by the reference field from the CREATIVE_HISTORY table using the /posts endpoint.

To store this new data, we have added the following tables:

LinkedIn Company Pages

We have changed the schema of the following tables according to the Posts API.

Mailchimp

We have added the following new tables:

• CART
• CART_LINE
• CUSTOMER
• ORDERS
• ORDER_LINE
• ORDER_PROMO_CODE
• PRODUCT
• PRODUCT_VARIANT
• PROMO_CODE
• PROMO_RULE
• STORE

We are gradually rolling out these changes to all existing connectors.

Microsoft Advertising

We have added the following reporting tables:

• AD_DYNAMIC_TEXT_PERFORMANCE_DAILY_REPORT
• AD_DYNAMIC_TEXT_PERFORMANCE_HOURLY_REPORT
• AUDIENCE_PERFORMANCE_DAILY_REPORT
• AUDIENCE_PERFORMANCE_HOURLY_REPORT
• CONVERSION_PERFORMANCE_DAILY_REPORT
• CONVERSION_PERFORMANCE_HOURLY_REPORT
• DESTINATION_URL_PERFORMANCE_DAILY_REPORT
• DESTINATION_URL_PERFORMANCE_HOURLY_REPORT
• PUBLISHER_USAGE_PERFORMANCE_DAILY_REPORT
• PUBLISHER_USAGE_PERFORMANCE_HOURLY_REPORT

We are gradually rolling out these change to all existing connectors.

By default, we select all new tables for the sync. You can sync these tables for free until January 31, 2024. Be sure to exclude all new tables that you don't want to count towards paid Monthly Active Rows (MAR) before this date.

Oracle Fusion Cloud Applications

We have stopped marking the Oracle Fusion Cloud Applications connector tables as Excluded By System on the Schema tab of your connector dashboard if the datastore is inactive.

Outbrain

We have added a new table, CAMPAIGN_CONVERSION_REPORT, which has a composite primary key consisting of the day, campaign_id, name, and platform columns. The campaign_id column refers to the CAMPAIGN_HISTORY table. We have made this change to sync campaign-related conversion metrics.

Qualtrics

We have changed the composite primary key of the DISTRIBUTION_CONTACT table to ensure data integrity. The new composite primary key is a combination of the distribution_id, contact_id, and contact_lookup_id columns. Be sure to update your queries. We are gradually rolling out this changes to all existing connectors.

Rootly

We have added a new table, RETROSPECTIVE_PROCESS.

We have added a new column, retrospective_process_id, to the RETROSPECTIVE table.

Salesforce

We have added two new tables, EXTERNAL_STRING and EXTERNAL_STRING_LOCALIZATION. We are gradually rolling out this change to all existing connectors.

Salesforce Commerce Cloud

We have added the following new tables:

• CUSTOMER_GROUP
• CUSTOM_OBJECT
• CUSTOM_OBJECT_ATTRIBUTE_DEFINITION
• CUSTOM_OBJECT_ATTRIBUTE_GROUP
• INVENTORY_LIST
• INVENTORY_LIST_RECORD
• SHARED_PRODUCT_OPTION
• SHARED_PRODUCT_OPTION_VALUE
• SOURCE_CODE_GROUP
• STORE

We support the tables using the Salesforce Open Commerce APIs. For more information, see our Salesforce Commerce Cloud Setup Guide. We do not support syncing these tables using our REST API.

Snapchat Ads

We have added the following new columns corresponding to separate "swipe-up" and "view" metric variants to the campaign reporting tables, ad reporting tables, and ad squad reporting tables:

Learn more in our Snapchat Ads Report Tables documentation.

Workday HCM

We have added the following new tables:

• PERSONAL_INFORMATION_HISTORY
• WORKER_HISTORY
• WORKER_PAY_GROUP_ASSIGNMENT_HISTORY
• WORKER_POSITION_HISTORY
• WORKER_POSITION_COMPENSATION_HISTORY
• WORKER_POSITION_JOB_CLASSIFICATION_HISTORY
• WORKER_POSITION_ORGANIZATION_HISTORY
• WORKER_POSITION_PAYROLL_REPORTING_CODE_HISTORY

To sync these tables, you must enable the security domains necessary for the HR module. We are gradually rolling out these changes to all existing connectors.

Zoho CRM

The USER_TERRITORY table is now the child table of the USERS table.

Improvements

15Five

We now incrementally sync the USER_VACATION table and its child tables to capture new records.

Amazon S3

We have added a new toggle, Non-standard character escaping?, to the connector setup form to support the non-standard ways of escaping characters. If your CSV generator uses non-standard ways of escaping characters, set the toggle to ON and in the Character Escaping options drop-down menu, select one of the following options:

• Custom Escape Character: To process CSV files that use custom escape characters to escape quotation marks.
• Delimited Only: To process CSV files that don't use escape characters to escape quotation marks and process with delimiter only.

For more information, see our setup instructions and REST API config. We are gradually rolling out this change to all existing connectors.

We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information see our setup instructions.

Box

Our Box connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.

Buildkite

You can now configure your Buildkite connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Campaign Monitor

You can now configure your Campaign Monitor connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

ChartMogul

You can now configure your ChartMogul connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Chorus

You can now configure your Chorus connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Close

You can now configure your Close connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Criteo

We have upgraded our Criteo connector from version 2023.01 to 2023.10 of the Criteo API. For more information about the changes, see Criteo API's changelog.

Customer.io

Our Customer.io connector now supports table-level re-syncs.

Fountain

We have added a new configuration option, URL format, to the connector setup form to support all regional variants of the Fountain URL. For more information, see our setup instructions and REST API config.

Freightview

You can now configure your Freightview connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Google Ads

We now support Google Ads API 15.

Integral Ad Science

We no longer use your Integral Ad Science client ID and client secret to access and sync your data. To support this enhancement, we have made the following changes:

• Removed the Client ID and Client Secret fields from the connector setup form.
• Removed the client_id and client_secret parameters from the REST API configuration.

For more information, see our setup instructions and REST API config.

Jira Align

We now capture deletes for all tables. To support this feature, we have changed the connector's sync strategy. We now re-import all tables. Previously, we incrementally synced all the tables.

Klaviyo

We have migrated all Klaviyo connectors created before December 19, 2023, to Klaviyo API v2023-10-15. For more information, see our December 2023 changelog.

We have introduced a new option in our connector setup form that allows you to sync only events associated with active profiles in Klaviyo. By default, we sync events associated with both active and deleted profiles.

Kustomer

You can now exclude the following child tables of the MESSAGE table from your syncs:

• MESSAGE_ASSIGNED_TEAM
• MESSAGE_ASSIGNED_USER
• MESSAGE_ATTACHMENT
• MESSAGE_CREATED_BY_TEAM
• MESSAGE_SHORTCUT

On your Connector Details page, go to the Schema tab and deselect the tables.

NOTE: If you exclude the child tables and later want to sync the tables, perform a full re-sync to backfill the data in the child tables.

Lob

You can now configure your Lob connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Mailchimp

We now use List webhooks to sync data regarding campaign and automation email unsubscribes in the UNSUBSCRIBE table. During an incremental sync, our connector registers Fivetran webhooks for every list with unsubscribe events triggered from all possible sources. During the initial sync, our connector use the Reports endpoint to sync the UNSUBSCRIBE table for all campaigns and automation emails.

Monday.com

You can now configure your Monday.com connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

MySQL

We now support replication using global transaction identifiers (GTIDs). In GTID mode, we stream incremental updates from your database using each transaction's GTID instead of its binary log position.

Oracle Fusion Cloud Applications

We now convert the data types for the following columns to DOUBLE irrespective of their original data types at the source:

• FaBalanceExtractBeginningBalance column in the FA_BALANCES_EXTRACT_PVO table
• reverse_uom_rate column in the UOM_INTERCLASS_PVO table

We also convert the data types for columns with amount, duration, and price suffixes from NUMERIC to DOUBLE. We are making these improvements to avoid data integrity issues.

Pardot

We now perform rollback syncs with a window of three days to capture all the updates made to the EMAIL_TAG table. This addresses the issue where email sent_at dates occurring after their related tag created_at dates led to missed updates. In some cases, if the difference between the email sent_at dates and the related tag object created_at date is more than three days, the email tag objects may not be synced. To resolve this issue, contact our support team.

We are gradually rolling out this improvement to all the existing connectors.

Ramp

You can now configure your Ramp connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Rarible

You can now configure your Rarible connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Rollbar

We now use both project access tokens and account access tokens to access and sync your Rollbar data. To facilitate this enhancement, we have made the following changes:

• Added a new field, Project access token, and renamed the Access Token field to Account access token in the connector setup form
• Added a new parameter, project_access_token, and renamed the access_token parameter to account_access_token in the Fivetran REST API

For more information, see our setup guide and API connector configuration documentation.

Salesforce

We have added support for fields that reference the following Global Variables:

• $Label
• $Permission
• $Profile
• $RecordType
• $Setup
• $User
• $UserRole

NOTE: These global variables rely on specific tables. You must select these tables on the Schema tab of your connector details page.

NOTE: $Label, $Permission, $Profile, $Setup, $User, and $UserRole are user-dependent global variables, and their translations are generated dynamically based on the connecting user's details.

We are gradually rolling out this feature to all existing connectors. For more information about formula translations, see our documentation.

We have changed our sync strategy for the ContentDocumentLink object to improve connector performance. Previously, we synced the object using filters on the parentId, resulting in longer sync times. We now sync the object directly without any filters if you have enabled the Query All Files permission to sync the ContentDocumentLink object. For more information, see Salesforce's release notes.

Salesforce Commerce Cloud

We have changed our sync strategy for the CATALOG table to fix data integrity issues of the child tables. We now re-import the table. Previously, we incrementally synced the table.

Salesforce Marketing Cloud

We have released a pre-built, dbt Core-compatible data model for Salesforce Marketing Cloud. Find the model 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.

We have added the option to select the event types that you want to sync. In the connector setup form, you can now select the event types in the Select Event Type(s) drop-down menu.

SAP ERP on HANA

Our SAP ERP on HANA connector is now generally available. Read our SAP ERP on HANA connector documentation.

ServiceNow

We have released a pre-built, dbt Core-compatible data model for ServiceNow. Find the model 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.

SFTP

We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.

Snapchat Ads

We now support additional fields corresponding to separate "swipe-up" and "view" variants of selected metrics for custom reports. For more information, see our Custom Report Fields and Limitations documentation.

SonarQube

We have added support for SonarQube URLs with different domains. You can now authenticate your connector using a different domain URL. Be sure to update your subdomain in the connector setup form. For more information, see our SonarQube documentation.

Statsig

You can now configure your Statsig connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

Workday RaaS

We have changed the sync strategy for our Workday RaaS connector. We now support incremental syncs for the reports whose URL contains dynamic query parameters. For more information, see our documentation.

REST API Improvements

HVR Registration Management API

Our HVR Registration API resource is now in beta. You can now leverage the Register a new hub feature.

Log events

Removed dashboard activity log event

We have removed the forced_pause_connector dashboard activity log event. We now send an automated pause event, pause_connector with the actor:Fivetran attribute. We issue the automated pause event either for broken or trial expired connectors.