Does anyone know how the Redshift-target updates/persists data in S3. Per the docs it inserts the data into S3, then runs the COPY command to move the data into Redshift? In particular, how does it handle: • updates to an existing row (e.g. an existing users email address is changed) • hard-deletes (the pipelinewise variant claims to handle these) We have data-retention policies and I need to make sure an update or a delete would be applied anywhere that data exists.