Thanks!
The solution I used was to not set the S3 Filename pattern to {date} since that caused the overwrite behavior. When setting it to {timestamp} there was no duplication issue. I would recommend removing the {date} pattern suggestion for those using the Redshift destination with S3 staging.