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 Warehouse
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+308are truncated to
Doubles with values less than
-1.79E+308are truncated to
Fivetran will sync values in the Unicode range
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.
Incompletedestination 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 schemafield in the setup form is now populated with the destination dataset ID you selected in the BigQuery DTS UI.
Connector Request Form
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.
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
Braze is a platform for cross-channel marketing automation.
We have removed support for the
CAMPAIGN_GROUP_PERFORMANCE_REPORT because it does not contain a
date field, which we require for incremental updates.
We have added a new field
user_id to the
Apple Search Ads
We have added the following new fields to the
We have added the new table
Apple Search Ads no longer support the
storefrontcolumn in the
CAMPAIGN_HISTORYtable. You can see its data in the
country_or_regioncolumn of the
Google Search Console
We have dropped the following tables because Google Search Console has deprecated the
/urlCrawlErrorsCounts/query endpoints as part of migration. For reference, please check https://support.google.com/webmasters/answer/9073702#resource
- We have added the
WORKLOGtable. To sync the
WORKLOGtable, create a new connector or re-sync the existing one.
We have dropped the following fields from the
AD_ANALYTICS_BY_CREATIVE tables because values for them were coming in null:
We have replaced the dropped fields with the following fields to match with the source:
Salesforce Marketing Cloud
We have introduced a new column
triggered_send_idto the the
ACTIVITYtable. This field will also have a foreign key relation to
We have moved the
statusfields from the
ACTIVITYtable to the
We have renamed
Apple Search Ads
Added support for API v2.
Facebook Ad Insights
- 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.
- 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.
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.
Connect to the new Recurly connector.
Link to Recurly Documentation..