December 2019

Sunset connectors

Desk.com

We will sunset our Desk.com connector. The connector will stop working after March 2020.

Schema changes

Amplitude

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 discontinue the separate custom field columns after three months, so adjust your queries 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 Ads

We have added a new table, CREATIVE_SET_REPORT, to support the Creative Set Report.

Kustomer

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 Advertising

We have added a new column, final_url_suffix, to the KEYWORD_PERFORMANCE_DAILY_REPORT and KEYWORD_PERFORMANCE_HOURLY_REPORT tables.

Recharge

We have added the following columns to the CUSTOMER table:

has_card_error_in_dunning
has_valid_payment_method
reason_payment_method_not_valid

Shopify

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 columns 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 added a new table, CUSTOMER_TAX_EXEMPTION, which lists the tax exemptions associated with a customer.

Stripe

We have added a new table, EARLY_FRAUD_WARNING, which contains the following fields:

id
charge_id
actionable
created
fraud_type
livemode

Zendesk Support

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.

Improvements

Azure Synapse

We have renamed Azure SQL Data Warehouse to Azure Synapse. This name change applies to the Fivetran dashboard and our documentation.

Oracle

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.

PostgreSQL

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.

Salesforce

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 Ads

When setting up your connector, you can now select which organizations you'd like to sync. Previously, Fivetran synced all organizations by default.

Snapchat Org Menu

SQL Server

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 Improvements

We have implemented new Connector Management API endpoints for our REST API. You can now leverage the following new features: