S3 -> COPY -> Redshift Staging Database -> Redshift Database

Reference