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.