May 2019link
All Warehouseslink
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.
Azure SQL Data Warehouselink
Fivetran now truncates out of bounds double values to fit within the minimum and maximum allowed values for Azure Warehouse.
Doubles with values greater than
1.79E+308
are truncated to1.79E+308
.Doubles with values less than
-1.79E+308
are truncated to-1.79E+308
.
BigQuerylink
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 warehouse, 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.
BigQuery DTSlink
The temporary
Incomplete
destination won't be created during the connector setup process anymore. The connector will be created in the correct destination immediately.When you create a new connector the
Destination schema
field in the setup form is now populated with the destination dataset ID you selected in the BigQuery DTS UI.
Connector Request Formlink
You can now request connectors that we don't yet have, right from your Fivetran dashboard.
To request a new connector:
- Go to your Fivetran dashboard and select +Connector.
- In the Add Connector view, go to the bottom of the list of available connectors and select Request a new connector.
- Fill in the details about the new connector you'd like us to build.
Support Formlink
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 Connectionlink
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 connectorslink
Brazelink
Braze is a platform for cross-channel marketing automation.
Schema changeslink
Adwordslink
We have removed support for the CAMPAIGN_GROUP_PERFORMANCE_REPORT
because it does not contain a date
field, which we require for incremental updates.
Amplitudelink
We have added a new field user_id
to the EVENT
table.
Apple Search Adslink
We have added the following new fields to the
CAMPAIGN_REPORT
,AD_GROUP_REPORT
,SEARCH_TERM_REPORT
andKEYWORD_REPORT
tables:new_downloads
re_downloads
lat_on_installs
lat_off_installs
We have added the new table
COUNTRY_OR_REGION_HISTORY
.Apple Search Ads no longer support the
storefront
column in theCAMPAIGN_HISTORY
table. You can see its data in thecountry_or_region
column of theCOUNTRY_OR_REGION_HISTORY
table .
Google Search Consolelink
We have dropped the following tables because Google Search Console has deprecated the /urlCrawlErrorsSamples
and /urlCrawlErrorsCounts/query
endpoints as part of migration. For reference, please check https://support.google.com/webmasters/answer/9073702#resource
CRAWL_ERRORS_SAMPLE
URLS_CONTAINING_SITEMAP
LINKED_URLS
CRAWL_ERRORS_COUNT_BY_PLATFORM
Jiralink
- We have added the
WORKLOG
table. To sync theWORKLOG
table, create a new connector or re-sync the existing one.
LinkedIn Ad Analyticslink
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 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 Cloudlink
We have introduced a new column
triggered_send_id
to theACTIVITY
table. This field will also have a foreign key relation toTRIGGERED_SEND
table.We have moved the
tags
,definitionId
, andstatus
fields from theACTIVITY
table to theJOURNEY
table.We have renamed
object_id
in theTRIGGERED_SEND
toid
.
Improvementslink
Apple Search Adslink
Added support for API v2.
Facebook Ad Insightslink
You can now configure your Facebook Ad Insights connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
HubSpotlink
- 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.
Recurlylink
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 fields 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.
Link to Recurly Documentation..