We now use Salesforce's Bulk API 2.0 for your connector's historical syncs. Previously, we used the REST API for the historical syncs. We are gradually rolling out this new feature to all existing customers. If you'd like to enable this feature on your connector, contact our support team.
We have released Fivetran history mode for Salesforce. You can turn on history mode for any table and capture every version of each record in your destination. With history mode, you can analyze data from a particular point in time or analyze how data has changed over time. To learn more, read our history mode documentation.
We are gradually rolling out history mode to existing customers. If you'd like to access history mode immediately, contact our support team.
We now capture deletes of history tables using the
is_deleted field from Salesforce.
Read our History tables documentation for more information.
We have disabled History mode for Salesforce history tables because history tables track object history by default. The changes made to an object over time are recorded in the Salesforce history tables using field history tracking.
We no longer capture deletes for tables with names ending with
_HISTORY, for example,
OBJECT_NAME_HISTORY. Deletes from these tables contributed an unacceptably high amount of monthly active rows.
You can now select the
FIVETRAN_QUERY tables to sync from the Schema tab on your connector details page.
We now add a fivetran_synced column while syncing empty tables and columns from the source.
We can now re-import tables that can't be incrementally updated. We automatically detect tables with
replicateable = false and
updateable = false values and re-import them in full. We mark the re-imported tables as
notRecommended in the dashboard and exclude them from incremental syncs by default. However, you can choose to include them.
We now force the creation of schemas, even if they contain no data. This is especially helpful for Looker users since Looker's pre-built SQL queries fail if all tables and columns in a schema are not present. Previously, we did not create schemas when they contained no data.
Even if a column is not populated in the source, we create a column for it in the destination with null records.
Note: We will not create a column if you have not selected it in the column config.
We are rolling out this improvement in a phased manner to ensure connector reliability. It may not be available to every customer right away. Contact our support team if you'd like to be included in the early phase of the rollout.
We have upgraded our Salesforce connector from Salesforce API version 41.0 to 45.0. The upgrade supports new objects available in Salesforce API 45.0. We will roll out the new version of our connector to all customers gradually over 3 months starting on July 12th.
- You can now configure your Salesforce connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
- Fivetran will add a log message to Customer Logs when skipping an infrequently updated table.
System columns, like
SystemModstamp, can no longer be excluded in column configuration.
We have upgraded the Salesforce API to v41.