The following tables are now history tables:
We have migrated the existing data in these tables to history mode.
We have added two new tables,
We are gradually rolling out these changes to all existing connectors.
We have made the following schema changes to all the Salesforce Marketing Cloud connectors:
- Moved the
unique_clickscolumns from the
LINKtable to the
- Changed the primary key for the
LINK_SENDtable from the combination of
link_idcolumns to the
These changes address the data integrity issue caused by the incorrect selection of the primary key and also redistribute the data.
We have changed the primary key of the
LIST_SUBSCRIBER table and performed a table re-sync to ensure data integrity. The new composite key is a combination of the
We have decreased the priority fetch period from 14 to 5 days for all the priority-first sync tables to improve sync speeds and reduce the duration of the first forward sync. For more information, see our priority-first sync documentation.
We have decreased the priority fetch period from 5 days to 1 day for all the priority-first sync tables to improve sync speeds and reduce the duration of the first forward sync. For more information, see our priority-first sync documentation.
We now support syncing HTML-based emails.
We have added the
event_type field as a primary key in the
EVENT table. We don't recommend a re-sync because this change resolves a rare discrepancy that may not have affected you and because the
EVENT table can take a long time to sync. If you do notice data discrepancies in the
EVENT table and must re-sync it, contact Fivetran Support.
We have implemented a new sync schedule to fetch data from the
SUBSCRIBERS table. Every Saturday, the connector performs a historical sync. The additional Saturday sync improves the connector's overall sync speed.
We now store timestamp data using the
TIMESTAMP WITHOUT TIME ZONE type. Previously we used
TIMESTAMP WITH TIME ZONE and when Fivetran received timestamp data that did not have timezone information from Salesforce Marketing Cloud, we incorrectly stored the timestamp data as UTC. Using
TIMESTAMP WITHOUT TIME ZONE fixes this issue.
The following table lists the columns whose type we have converted from
TIMESTAMP WITH TIME ZONE to
TIMESTAMP WITHOUT TIME ZONE:
|Table Name||Modified Columns|
|EVENT||created_date, event_date, modified_date|
|SEND||created_date, modified_date, send_date|
Newly created connectors will use
TIMESTAMP WITHOUT TIME ZONE in these columns by default. To update existing connectors to use
TIMESTAMP WITHOUT TIME ZONE, drop your existing tables and trigger a re-sync. If you wish to continue storing timestamps using
TIMESTAMP WITH TIME ZONE, take no action.
The Salesforce Marketing Cloud connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Salesforce Marketing Cloud's priority-first syncs fetch the most recent 14 days' worth of data from the following tables:
To learn more, see our priority-first sync documentation.
We have started syncing email data from the Content Builder API into the
This change adds the new column
asset_type_id to the
We have added support to authenticate Salesforce Marketing Cloud connectors using OAuth 2.0. Salesforce Marketing Cloud creates new packages with OAuth 2.0 as the only authentication option. Thus, all connectors that use these new packages must use OAuth 2.0 to authenticate with Fivetran.
When you create a new connector, you must now enter your subdomain in the setup form. You must also select New Enhanced Package to indicate that your package uses OAuth 2.0.
- We have added the column
We have introduced a new column
ACTIVITYtable. This field will also have a foreign key relation to
We have moved the
statusfields from the
ACTIVITYtable to the
We have renamed
We dropped the following fields from the
Fivetran now supports the
We have added the new column
unsubscribed_date to the
We have added a new field,
version, to the
The Salesforce Marketing Cloud connector now supports the SentEvent endpoint.
Salesforce Marketing Cloud provides digital marketing automation, analytics, and lead management for B2B and B2C companies.