December 2022

Browser Upload Sunset

We sunset our Browser Upload feature. This feature was only available for Fivetran accounts created before April 9, 2021. You can use our File connectors to sync CSV files to your destination. For more information, see our What Are My Alternatives to the Browser Upload Feature FAQ page.

Lite Connectors

Lite connectors are now available for the following sources:

• Assembled
• Buildkite

New user notifications ended

We no longer send email notifications when new users are added to your account to keep the volume of notifications low. We will continue to support changes to users and permissions through our external logs integration.

Transformations for dbt Core

dbt Core versions 1.2.3 and 1.3.1 support

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

New destinations support

We now support Transformations for dbt Core for the following destinations:

• Azure Synapse
• MySQL
• SQL Server

You can now run your dbt projects in these destinations. Learn more in our Supported destinations documentation.

New connectors

High-Volume Agent SAP ECC on Oracle

SAP ECC on Oracle is an enterprise resource planning and analytics platform built on top of Oracle database. Fivetran replicates data from your Oracle source database and loads it into your destination using High-Volume Agent connector.

Read our High-Volume Agent SAP ECC on Oracle documentation.

Medallia

Medallia is a customer experience management platform.

Read our Medallia connector documentation.

PayPal

PayPal is an online payment processing platform.

Read our PayPal connector documentation.

Snowflake

Snowflake is a cloud computing-based data warehouse company.

Read our Snowflake connector documentation.

Schema changes

Apple App Store

Apple renamed the Promotional Offer Name report field to Subscription Offer Name in the new versions of the reports. We have renamed the promotional_offer_name column to subscription_offer_name in the following tables:

• SALES_SUBSCRIBER_DETAILED
• SALES_SUBSCRIPTION_SUMMARY
• SALES_SUBSCRIPTION_EVENT_SUMMARY

We now sync new data into the subscription_offer_name column in the destination tables.

We are gradually rolling out this feature to all existing connectors. Contact our support team if you want to backfill older data from the promotional_offer_name column to the new subscription_offer_name column. You may experience slow sync speeds when you backfill the older data into the column.

We have added four new columns to the SALES_SUBSCRIPTION_SUMMARY table:

• free_trial_offer_code_subscriptions
• pay_up_front_offer_code_subscriptions
• pay_as_you_go_offer_code_subscriptions
• subscribers

For more information, see Apple's Subscriber Report Version 1_3, Subscription Report Version 1_3, and Subscription Event Report Version 1_3 reports.

Asana

We have added a new table, GOAL_RELATIONSHIP, which stores information about the relationship between a goal and another goal, a project, or a portfolio.

We will discontinue the GOAL_SUPPORTING_WORK table on February 1, 2023. Be sure to update your queries.

Braze

We have added a new column, channel_in_app_message, to the CAMPAIGN, CANVAS, and CANVAS_STEP tables.

Eloqua

We have added the following new tables:

• CONTACT_FILTER
• CONTACT_FILTER_SEGMENT_ELEMENT
• CONTACT_LIST
• CONTACT_LIST_CONTACT
• CONTACT_LIST_SEGMENT_ELEMENT
• CONTACT_SEGMENT
• SEGMENT

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

Facebook Pages

We have added the following fields to the LIFETIME_POST_METRICS_TOTAL table:

• post_video_retention_graph
• post_video_retention_graph_clicked_to_play
• post_video_retention_graph_autoplayed

Google Ads

We have made the following schema changes to support Google Ads API v12:

• We have added two new reports, ASSET_SET_ASSET and ASSET_SET_TYPE_VIEW.

• We have added the asset_set resource fields to the ASSET_SET_ASSET report.

• We have added the ad_group_ad_asset_view.pinned_field field to the AD_GROUP_AD_ASSET_VIEW report.

• We have added the bidding_strategy.aligned_campaign_budget_id field to the BIDDING_STRATEGY report.

• We have added the campaign_budget.aligned_bidding_strategy_id field to the CAMPAIGN_BUDGET report.

• We have added the campaign_criterion.location_group.enable_customer_level_location_asset_set field to the CAMPAIGN_CRITERION resource.

• We have added the following fields to the ASSET resource:

  • asset.location_asset.business_profile_locations
  • asset.location_asset.location_ownership_type
  • asset.location_asset.place_id

• We have added the following fields to the CAMPAIGN report:

  • campaign.primary_status
  • campaign.primary_status_reasons

• We have added two new metadata tables, DISCOVERY_CAROUSEL_AD_HISTORY and DISCOVERY_MULTI_ASSET_AD_HISTORY.

• We have removed the ad_group_ad.ad.gmail_ad.* fields from AD_GROUP_AD report and the GMAIL_AD_HISTORY table, since the Google Ads API no longer supports GMAIL_AD.

Pardot

We have added a new table, LIST_EMAIL, which stores the text and HTML content of emails. For more information about the table, see Pardot's documentation.

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

• campaign_id
• client_type
• created_by_id
• list_email_id
• list_id
• prospect_id
• sent_at We are gradually rolling out this feature to all existing connectors.

Pendo

We have added a new primary key column, _fivetran_id, to the PAGE_EVENT and FEATURE_EVENT tables to avoid data integrity issues. This functionality is enabled by default for new connectors created after December 15, 2022. We are gradually rolling out the feature to all the existing connectors.

SAP Business ByDesign

We have added a new table, IDENTIFIED_STOCK. For more information about the table, see SAP Business ByDesign's documentation.

Snapchat Ads

We have added new columns to the campaign reporting, ad reporting, and ad squad reporting tables:

• conversion_subscribe
• conversion_purchases_swipe_up
• conversion_purchases_view

Learn more in our Snapchat Ads Report Tables documentation.

TikTok Ads

We have added the following new tables:

• PIXEL_HISTORY
• PIXEL_EVENT_HISTORY
• PIXEL_EVENT_RULE_HISTORY
• PIXEL_STATISTICS

Typeform

We have added a new column, phone_number, to the RESPONSE_ANSWER table.

Zendesk Support

We have added a new table, SCHEDULE_HOLIDAY. For more information, see Zendesk's documentation.

Improvements

Amazon DynamoDB

We have changed the sync strategy of our Amazon DynamoDB connectors. We now schedule:

• Automatic full source re-syncs if we detect expired change streams cursor.
• Automatic full table re-syncs if we detect:
  • Change in pack mode
  • Expired change streams cursor

Previously, we never automatically re-synced Amazon DynamoDB connectors.

Eloqua

You can now exclude the VISITOR table from your syncs. On your Connector Details page, go to the Schema tab and deselect the table.

Google Ad Manager

We have upgraded our Google Ad Manager connector from version 202205 to 202211 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google's Ad Manager API documentation.

• Removed columns:

  • OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS
  • OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS
  • OPTIMIZATION_CONTROL_CLICKS
  • OPTIMIZATION_CONTROL_CTR
  • OPTIMIZATION_CONTROL_ECPM
  • OPTIMIZATION_CONTROL_IMPRESSIONS
  • OPTIMIZATION_CONTROL_REVENUE
  • OPTIMIZATION_COVERAGE
  • OPTIMIZATION_ECPM_LIFT
  • OPTIMIZATION_EXTRA_CLICKS
  • OPTIMIZATION_FREED_UP_IMPRESSIONS
  • OPTIMIZATION_LIFT
  • OPTIMIZATION_NON_OPTIMIZED_CLICKS
  • OPTIMIZATION_NON_OPTIMIZED_IMPRESSIONS
  • OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS
  • OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS
  • OPTIMIZATION_OPTIMIZED_CLICKS
  • OPTIMIZATION_OPTIMIZED_CTR
  • OPTIMIZATION_OPTIMIZED_ECPM
  • OPTIMIZATION_OPTIMIZED_IMPRESSIONS
  • OPTIMIZATION_OPTIMIZED_REVENUE
  • OPTIMIZATION_SPONSORSHIP_IMPRESSIONS

• New columns:

  • AD_SERVER_BEGIN_TO_RENDER_IMPRESSIONS
  • AD_SERVER_UNFILTERED_BEGIN_TO_RENDER_IMPRESSIONS
  • NIELSEN_IN_TARGET_RATIO
  • PARTNER_SALES_FILLED_QUERIES
  • PARTNER_SALES_GOOGLE_AUCTION_IMPRESSIONS
  • PARTNER_SALES_GOOGLE_IMPRESSIONS
  • PARTNER_SALES_GOOGLE_RESERVATION_IMPRESSIONS
  • PARTNER_SALES_PARTNER_CODE_SERVED
  • PARTNER_SALES_PARTNER_IMPRESSIONS
  • PARTNER_SALES_QUERIES
  • PARTNER_SALES_SELL_THROUGH_RATE
  • VIDEO_CREATIVE_SERVE_REAL_TIME
  • VIDEO_IMPRESSIONS_REAL_TIME
  • VIDEO_MATCHED_QUERIES_REAL_TIME
  • VIDEO_TOTAL_QUERIES_REAL_TIME
  • VIDEO_UNMATCHED_QUERIES_REAL_TIME
  • VIDEO_VAST3_ERROR_100_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_101_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_102_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_200_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_201_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_202_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_203_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_300_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_301_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_302_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_303_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_400_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_401_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_402_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_403_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_405_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_500_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_501_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_502_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_503_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_600_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_601_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_602_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_603_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_604_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_900_COUNT_REAL_TIME
  • VIDEO_VAST3_ERROR_901_COUNT_REAL_TIME
  • VIDEO_VAST4_ERROR_406_COUNT_REAL_TIME
  • VIDEO_VAST4_ERROR_407_COUNT_REAL_TIME
  • VIDEO_VAST4_ERROR_408_COUNT_REAL_TIME
  • VIDEO_VAST4_ERROR_409_COUNT_REAL_TIME
  • VIDEO_VAST4_ERROR_410_COUNT_REAL_TIME
  • VIDEO_VAST_TOTAL_ERROR_COUNT_REAL_TIME

• New dimensions:

  • EXCHANGE_BIDDING_DEAL_ID
  • EXCHANGE_BIDDING_DEAL_TYPE

• New dimension attributes:

  • CHILD_PARTNER_NAME

Google Ads

We now support Google Ads API v12.

Iterable

We now sync the additional_properties column to the EVENT table for all Iterable connectors. If you want to sync the historical data for this column, contact our support team.

Marketo

We have added a new button, SUPPORTS UPDATEDAT IN BULK EXPORT?, to the connector setup form. You can now determine if your Marketo subscription supports the updatedAt filter for BULK exports. For more information, see Enable updatedAt filter for your subscription.

NetSuite SuiteAnalytics

We now incrementally sync the SystemNote table for the Netsuite2.com data source. We don't capture deletes or updates because the table is immutable.

PostgreSQL

We no longer support PostgreSQL version 8. We only support PostgreSQL versions 9 - 14.x.

Salesforce

We have upgraded our Salesforce connector from version 55.0 to 56.0 of the Salesforce REST API. We are gradually rolling out this new feature to all existing connectors.

Shopify

We have upgraded our Shopify connector from version 2022-01 to 2022-7 of the Shopify API and made the following schema changes:

• We have added two new tables, CUSTOMER_SEGMENT and PRICE_RULE_PREREQ_CUSTOMER_SEGMENT.

• We have added the following new fields to the CUSTOMER table:

  • email_marketing_consent_state
  • email_marketing_consent_consent_updated_at
  • email_marketing_consent_marketing_opt_in_level

• We have deprecated the CUSTOMER_SAVED_SEARCH and PRICE_RULE_PREREQ_SAVED_SEARCH tables.

• We have deprecated the following fields from the CUSTOMER table:

  • accepts_marketing
  • accepts_marketing_updated_at
  • marketing_opt_in_level

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

Snowflake destination

We now set base64 as the default BINARY input format for the Snowflake destination.

WooCommerce

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

Log events

New log event

We now generate the CANCELED sync status for the sync_end log event in our logs.