December 2019link
Deprecated Connectorslink
Desk.comlink
Fivetran has deprecated the Desk connector. The connector will stop working after March 2020.
Schema changeslink
Amplitudelink
We no longer deliver a separate column for each custom field in the EVENTS
table. The EVENTS
table now syncs custom fields as JSON objects in the following columns:
data
event_properties
groups
group_properties
user_properties
Storing custom fields as JSON objects speeds up syncs and avoids hitting column limits in your destination.
We will deprecate the separate custom field columns after three months, so adjust your scripts accordingly. You must also re-sync your EVENTS
data during this time so that all your custom field data is in the new format before the separate columns are deprecated.
Apple Search Adslink
We have added the new table CREATIVE_SET_REPORT
to support the Creative Set Report.
Facebook Ad Insightslink
We have added support for following fields and action_breakdowns:
Fields:
website_purchase_roas
purchase_roas
conversion_rate_ranking
conversion_values
conversions
cost_per_conversion
cost_per_estimated_ad_recallers
cost_per_thruplay
engagement_rate_ranking
estimated_ad_recall_rate
estimated_ad_recallers
full_view_impressions
full_view_reach
instant_experience_clicks_to_open
instant_experience_clicks_to_start
instant_experience_outbound_clicks
quality_ranking
video_p95_watched_actions
video_play_actions
video_play_curve_actions
video_thruplay_watched_actions
Action Breakdowns:
action_carousel_card_id
action_carousel_card_name
Kustomerlink
We now sync satisfaction level to the CONVERSATION
table. Each new satisfaction level column has the prefix satisfaction_level_
(for example, satisfaction_level_rating
).
Microsoft Advertisinglink
We have added a new column, final_url_suffix
, to the KEYWORD_PERFORMANCE_DAILY_REPORT
and KEYWORD_PERFORMANCE_HOURLY_REPORT
tables.
Rechargelink
We have added the following columns to the CUSTOMER
table:
has_card_error_in_dunning
has_valid_payment_method
reason_payment_method_not_valid
Shopifylink
We have added the following new tables:
COUNTRY
PROVINCE
CUSTOMER_SAVED_SEARCH
We have added the following new tables associated with the
PRICE_RULE
table:PRICE_RULE_ENT_PRODUCT
PRICE_RULE_ENT_VARIANT
PRICE_RULE_ENT_COLLECTION
PRICE_RULE_ENT_COUNTRY
PRICE_RULE_PREREQ_COLLECTION
PRICE_RULE_PREREQ_CUSTOMER
PRICE_RULE_PREREQ_PRODUCT
PRICE_RULE_PREREQ_SAVED_SEARCH
PRICE_RULE_PREREQ_VARIANT
We have added the following fields to the
PRICE_RULE
table:allocation_limit
prerequisite_subtotal_range
prerequisite_quantity_range
prerequisite_shipping_price_range
quantity_ratio_prerequisite_quantity
quantity_ratio_ entitled_quantity
We have add the new table,
CUSTOMER_TAX_EXEMPTION
, which lists the tax exemptions associated with a customer.
Stripelink
We have added a new table, EARLY_FRAUD_WARNING
, which contains the following fields:
id
charge_id
actionable
created
fraud_type
livemode
Zendesklink
We have added a new table, TICKET_ALERT
, to sync the following event types:
- CC
- Notification
- OrganizationActivity
- External
We have added a new table, ALERT_RECIPIENT
, to store the recipients of an alert.
Improvementslink
Azure Synapselink
Azure SQL Data Warehouse is now Azure Synapse.
Facebook Ad Accountlink
We now sync archived ad data in the AD_HISTORY
table and archived ad_set data in the AD_SET_HISTORY
table. Previously we did not sync data for ad and ad_set records with archived status, because the Facebook API's default settings exclude archived data.
Facebook Ad Insightslink
We now sync ads with the IN_PROGRESS
or WITH_ISSUES
Facebook status. Previously we omitted ads with either of these statuses.
Oraclelink
We now create a task in your Fivetran dashboard that reminds you to re-sync your data when you have a transaction that has been uncommitted for more than six hours. The re-sync ensures that we do not miss any data from our syncs.
We are rolling out support for RAW column types.
PostgreSQLlink
We now create a task on your Alerts page when we encounter concurrent usage errors for your replication slot. Only one process can access the same replication slot at a time. For more details, see PostgreSQL's logical decoding documentation.
We can now use unique indexes to import tables without a primary key, making imports more efficient and reliable. This fix will be gradually rolled out over the next few weeks.
Salesforcelink
We now force the creation of schemas, even if they contain no data. This is especially helpful for Looker users since Looker's pre-built SQL queries fail if all tables and columns in a schema are not present. Previously, we did not create schemas when they contained no data.
Even if a column is not populated in the source, we create a column for it in the destination with null records.
Note: We will not create a column if you have not selected it in the column config.
We are rolling out this improvement in a phased manner to ensure connector reliability. It may not be available to every customer right away. Contact our support team if you'd like to be included in the early phase of the rollout.
Snapchat Adslink
When setting up your connector, you can now select which organizations you'd like to sync. Previously, Fivetran synced all organizations by default.
SQL Serverlink
Our SQL Server connector can now sync empty tables. You do not need to take any action to leverage this improvement. All the empty tables you previously selected to sync will now sync.
REST API Improvementslink
We have implemented new Connector Management API endpoints for our REST API. You can now leverage the following new features: