December 2018

Change to notifications for sunsetting connectors

When an old version of a connector is approaching the end of its active period, all users in your destination will be alerted, even those who have turned off most notifications.

Setup form changes

Fivetran's per-customer key feature is currently in beta testing. Customer-specific public keys for SSH connections will now appear on the setup forms for databases, destinations, and SFTP connections.

New connectors

AppsFlyer

AppsFlyer is a mobile app tracking and attribution analytics platform.

Read our AppsFlyer connector documentation.

Schema changes

MailChimp

We have added a new column, campaign_id, to the composite primary key in the CAMPAIGN_RECIPIENT_ACTIVITY table.

We have added a new column, automation_email_id, to the composite primary key in the AUTOMATION_RECIPIENT_ACTIVITY table.

Shopify

We have removed the ABANDONED_CHECKOUT table. All checkout data can now be found in the CHECKOUT table. Abandoned checkouts have null values in the completed_at field.

Stripe

The Stripe connector now supports top-up objects. This data appears in the TOPUP table.

Improvements

BigQuery destination

We now import BIGDECIMAL values to the BigQuery destination as NUMERIC data types.

Google Ad Manager

We have upgraded the connector to the DoubleClick API version 201811.

Klaviyo

We have migrated to the Lists API V2 because Klaviyo will be deleting their v1/lists endpoint in January.

Mixpanel

During its initial sync, the Mixpanel connector now syncs 30 days' worth of recent data, followed by alternating syncs of historical and recent data. This ensures that you see your most recent data right away.

MongoDB

You can now assign multiple hosts (master and replicas) for the MongoDB connector.

ServiceNow

The ServiceNow connector now supports Data Blocking.

You must now enter your username and password in your Fivetran setup form, rather than entering your credentials on your ServiceNow home page.

Snapchat Ads

We now fetch data with HOUR granularity for some reports. For the campaign, ad, and ad squad reports, there will be three new tables per report:

• All summable metrics with HOUR granularity
• Non-summable metrics with HOUR granularity
• Non-summable metrics with DAY granularity