SQL Apply executes SQL statements on the target that are equivalent to the SQL change operations on the source. For every Update, Insert, or Delete operation on the source, the Applier writes a corresponding Update, Insert, or Delete on the target.
You must perform an initial synchronization of targets prior to starting change data replication in SQL Apply mode.
Data Replication does not support SQL Apply mode for Amazon Redshift,