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.

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.

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:

• Re-sync all historical data for a connection
• Sync connection data on demand (custom scheduling)
• Re-sync a specific table within a connection
• Retrieve a connection schema config
• Update a connection schema config