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 deprecate 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.
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: