September 2018link
One Minute Frequencieslink
Fivetran can now sync as frequently as every minute. Note that syncing every minute will only be possible if both the data source and destination can operate that quickly. Please reach out to Fivetran Support if you would like this enabled for one or more of your connectors.
New connectorslink
Apache Kafkalink
Apache Kafka is an open-source distributed streaming platform.
Link to Apache Kafka documentation
Schema changeslink
AdRolllink
Because AdRoll has deprecated the ByEID
field, this field will no longer be synced as part of the ALL_ADVERTISABLES
report.
Facebook Ad Accountlink
We have removed the rule
column from the CUSTOM_AUDIENCE_HISTORY
table.
HubSpotlink
We have added a new field, transcription_id
, to the ENGAGEMENT_CALL
table.
The HubSpot connector can now sync e-commerce data for your Sales Hub, including products and line items. We have added the following tables to support this feature:
PRODUCT
PRODUCT_PROPERTY_HISTORY
LINE_ITEM
LINE_ITEM_PROPERTY_HISTORY
Marin Softwarelink
We have renamed the following tables:
OLD NAME | NEW NAME |
---|---|
CAMPAIGN_DIMENSION | CAMPAIGN_DIMENSION_HISTORY |
CREATIVE_DIMENSION | CREATIVE_DIMENSION_HISTORY |
GROUP_DIMENSION | GROUP_DIMENSION_HISTORY |
KEYWORD_DIMENSION | KEYWORD_DIMENSION_HISTORY |
PLACEMENT_DIMENSION | PLACEMENT_DIMENSION_HISTORY |
PRODUCT_TARGET_DIMENSION | PRODUCT_TARGET_DIMENSION_HISTORY |
PUBLISHER_DIMENSION | PUBLISHER_DIMENSION_HISTORY |
CREATIVE_TRACKING_VALUE | CREATIVE_TRACKING_HISTORY |
PLACEMENT_TRACKING_VALUE | PLACEMENT_TRACKING_HISTORY |
KEYWORD_TRACKING_VALUE | KEYWORD_TRACKING_HISTORY |
PRODUCT_TARGET_TRACKING_VALUE | PRODUCT_TARGET_TRACKING_HISTORY |
Microsoft Advertisinglink
We have added two new tables, PRODUCT_DIMENSION_PERFORMANCE_REPORT
and PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_REPORT
.
Sailthrulink
Fivetran now sets the _fivetran_deleted
field value to true
for deleted records in the USER
and USER_LIST
tables.
Shopifylink
We have added a new field, note
, to the ORDER
table.
We have added two new fields, script_version_id
and price_rule_id
, to the APPLIED_DISCOUNT
table.
Snowplowlink
We have added support for UA Parser Enrichment.
Taboolalink
We have added the _fivetran_id
field as a primary key in the TOP_CAMPAIGN_CONTENT_REPORT
table. The item
field is no longer a primary key.
Zendesklink
- The fields
ticket_id
andcreated_at
are now the primary keys for theTICKET_SCHEDULE
table. This change accounts for cases where a ticket is repeatedly assigned to a schedule. - In cases where multiple schedule assignment events are triggered in a single ticket audit, we now only create a record in the
TICKET_SCHEDULE
table for the final schedule assignment event. - We now use a Zendesk-supplied list of 100+ time zone names to map times in the
TICKET_SCHEDULE
table to UTC. - We have added two new fields,
via_source_to_name
andvia_source_to_address
, to theTICKET_EVENT
andTICKET
tables.
Improvementslink
Adwordslink
Customer IDs will now be included in the Specific Accounts section of the Fivetran setup form.
Azure Monitorlink
We now support pushing log event data into Azure Monitor. Refer to our Azure Monitor documentation for setup details.
Function Connectorslink
Fivetran now adds a user_agent
string related to the function_connector_name
value to distinguish Fivetran's function trigger from others.
Jiralink
We have improved the response caching process to speed up our historical syncs.
Microsoft Advertisinglink
We now support the yyyy-MM-ddTHH:mm:ss
time format for the last_modified_time
field in the ACCOUNT
table.
MongoDBlink
We have fixed a bug that caused BSON INT32 types to not sync during our initial syncs.
MySQL Connectorlink
The MySQL connector is now able to handle unescaped control characters in textual data as if they had been properly escaped.
MySQL Warehouselink
The MySQL warehouse now uses the load data infile strategy to write data. It requires the load_infile
system variable to be set to on
. For additional details, refer to our MySQL warehouse documentation.
Salesforcelink
System columns, like IsDeleted
and SystemModstamp
, can no longer be excluded in column configuration.
Salesforce Marketing Cloudlink
The Salesforce Marketing Cloud connector now supports the SentEvent endpoint.
SFTPlink
The No Such File Warning message is now fixed on your Fivetran dashboard.
Shopifylink
Users now receive warnings about GDPR data deletion requests.
Warning creation and logginglink
We have limited the rate of user warnings to 100 per minute. File upload connectors now behave more reasonably while recording file skip issues in user facing logs. After 50 skipped file warnings, we will stop logging further file skips.