May 2019

Azure Synapse

Fivetran now truncates out of bounds DOUBLE values to fit within the minimum and maximum allowed values for Azure Synapse.

• DOUBLE with values greater than 1.79E+308 are truncated to 1.79E+308.

• DOUBLE with values less than -1.79E+308 are truncated to -1.79E+308.

BigQuery

Fivetran will sync values in the Unicode range D800-DFFF as BASE64 encoded strings if the column is a primary key column.

Because these values are synced as �� in the BigQuery destination, conflict occurs when these values are present for a primary key column as there will be multiple rows with same primary key ��.

According to Google's documentation, Unicode range D800-DFFF is not allowed in identifiers, because these are surrogate unicode values.

Connector Request Form

You can now request connectors that we don't yet have, right from your Fivetran dashboard.

To request a new connector:

1. Go to your Fivetran dashboard and select +Connector.
2. In the Add Connector view, go to the bottom of the list of available connectors and select Request a new connector.
3. Fill in the details about the new connector you'd like us to build.

Destinations

Fivetran parses date values in ISO format. If we receive date values exceeding the valid range for ISO date values (for example 10000-01-01), we convert them to null. The valid range for ISO dates is 0001-01-01 to 9999-12-31.

Support Form

Fivetran has released a new support form. Instead of sending us an email when you need help from our support team, go to fivetran.com/support. The support form will reduce back and forth emails and help us respond to your issue more efficiently.

Access the new support from your Fivetran dashboard by selecting Support at the bottom left. Select the type of issue you'd like to report and provide details about it. We will then respond to your submission ASAP via email.

This change will not impact any cases that you’ve already submitted; it just means that you will submit any future issues through the support form instead of via email.

Test source or destination connection

You can now test connection for your sources and destinations for new IPs. Go to your Account Settings page and select Test source or destination connection for new IPs.

New connectors

Braze

Braze is a platform for cross-channel marketing automation.

Read our Braze connector documentation.

Schema changes

Amplitude

We have added a new column, user_id, to the EVENT table.

Apple Search Ads

We have added the following new fields to the CAMPAIGN_REPORT,AD_GROUP_REPORT, SEARCH_TERM_REPORT, and KEYWORD_REPORT tables:

• new_downloads
• re_downloads
• lat_on_installs
• lat_off_installs

We have added a new table, COUNTRY_OR_REGION_HISTORY.

Apple Search Ads no longer support the storefront column in the CAMPAIGN_HISTORY table. You can see its data in the country_or_region column of the COUNTRY_OR_REGION_HISTORY table .

Google Ads

We have removed support for the CAMPAIGN_GROUP_PERFORMANCE_REPORT because it does not contain a date field, which we require for incremental updates.

Google Search Console

We have dropped the following tables because Google Search Console has deprecated the /urlCrawlErrorsSamples and /urlCrawlErrorsCounts/query endpoints as part of migration:

• CRAWL_ERRORS_SAMPLE
• URLS_CONTAINING_SITEMAP
• LINKED_URLS
• CRAWL_ERRORS_COUNT_BY_PLATFORM

For more information, see Google's documentation.

Jira

We have added a new table, WORKLOG. To sync the WORKLOG table, create a new connector or re-sync the existing one.

LinkedIn Ad Analytics

We have dropped the following fields from the AD_ANALYTICS_BY_CAMPAIGN and AD_ANALYTICS_BY_CREATIVE tables because values for them were coming in as null:

• video_mid_point_completions
• viral_video_mid_point_completions
• viral_comments_likes

We have replaced the dropped fields with the following fields to match with the source:

• video_midpoint_completions
• viral_video_midpoint_completions
• viral_comment_likes

Salesforce Marketing Cloud

We have added a new column, triggered_send_id, to the ACTIVITY table. This column will also have a foreign key relation to TRIGGERED_SEND table.

We have moved the tags, definitionId, and status columns from the ACTIVITY table to the JOURNEY table.

We have renamed object_id column in the TRIGGERED_SEND table to id.

Improvements

Apple Search Ads

We added support for API v2.

HubSpot

Changes made through contact batch updates are processed asynchronously, so it can take several minutes for changes to be applied to contact records. To capture all the changes, once a day we take the cursor back by 1 day to capture all the updates.

Recurly

We have released a new version of the Recurly connector. The new version contains changed, added, and deprecated tables. In the existing tables we have added new columns and removed the deprecated ones. See the schema for details.

• Added tables:

  • ACCOUNT_BALANCE
  • ACCOUNT_NOTE
  • ACCOUNT_ACQUISITION
  • BILLING_INFO
  • COUPON_PLAN
  • CREDIT_PAYMENT
  • INVOICE_SUBSCRIPTION
  • LINE_ITEM
  • PAYMENT_METHOD
  • PLAN_ADD_ON_CURRENCY
  • PLAN_CURRENCY
  • SUBSCRIPTION_CHANGE
  • SUBSCRIPTION_COUPON_REDEMPTION
  • TRANSACTION_SUBSCRIPTION

• Deprecated tables

  • ADJUSTMENT
  • CURRENCY

Connect to the new Recurly connector.

Read our Recurly connector documentation..