title: Amazon Redshift COPY with transformation
body: <p>Redshift has a COPY operation that allows you to copy files from S3 into Redshift (<a href="http://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html" rel="nofollow">http://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html</a>).</p>
  
  <p>The .json files that are in S3 are ``dirty"; they are not ready to be copied into Redshift directly and need to run through a transformation first. My question is; do I need to write the new cleaned JSON files back to S3, then perform the COPY from those cleaned files, or is there a way to run the jsons through this transformation as part of the copy procedure?</p>