SCD2 stands for Slowly Changing Dimension Type 2, which stores historical values for query or audit purposes. SnapLogic AutoSync supports SCD2 when loading data for sources that can provide a last updated timestamp. Each table must have a primary key and a timestamp that is updated each time a change is made to a record. The supported data type for the timestamp field differs by endpoint. Refer to the endpoint specific documentation for details.

If your endpoint does not have a column or field to store the last updated timestamp, you will need to add one to use SCD2. Make sure that the column is not nullable, contains no null values, and updates the timestamp value for all changes.

If you enable synchronization when creating the pipeline, for targets that support incremental load, by default AutoSync does a full load followed by incremental loads (upserts). To use SCD2, edit the data pipeline and change the load type.

To provide SCD2, AutoSync changes the destination schema to add columns that track whether a row contains current or historical value. Some Salesforce objects are only created, such as LeadHistory. These objects do not have a field that tracks updates and should not be used with the SCD2 load type.

You can change a data pipeline using full or incremental load to SCD2. However, use care in the following situations:

• If you need to change a data pipeline from using SCD2 back to using incremental loads, you should first drop the target tables in the destination. Failing to drop tables synchronized with SCD2 before changing the load type can result in errors.
• We do not recommend setting up multiple data pipelines that load the a particular table or object to the same schema in the target. However, if two pipelines load the same table to the same schema and one is set to use incremental loads and the other to use SCD2, the incremental load will fail.

AutoSync supports the SCD2 load type for the source to destination combinations listed in the following table.