Copying DynamoDB to Redshift table while mapping columns

I have a DynamoDB table which using Lambdas now feeds all newly added/modified rows into a Redshift table. Now I'm trying to backfill the rest of the Dynamo table into the Redshift table however the names don't correspond at all. For example, the "id" column in Dynamo has been named to "person_id" (to be more consistent with our other services). Is there a way to tell the COPY command to map (id -> person_id, ...)?

Looking at the AWS documentation, it appears a jsonpaths file help but thereI'm not really finding much documentation about it.

Recent Questions...