Copying earlier version of object in S3 bucket to Redshift with COPY command

Question

I am able to use the COPY command in Redshift to copy over the most recent version of the object in my S3 bucket, but I am wondering if it's possible to do this but specify a version ID with it. This way a specific version of the object in the bucket can be copied over instead of the default. If anyone knows how to do this or can let me know if it is even possible it would be greatly appreciated.

Answer

Hello,
I see you are trying to COPY a specific version of an object in an S3 bucket using Redshift. While you are not able to specify a certain version of an object to copy, you can work-around this by restoring the object to the version you want to copy, and then copy that object. The only option with Redshift is to copy the most up-to-date version, but users can restore versions using the AWS Management console, and then copy that version. More information can be found here:
https://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html
https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-source-s3.html

Copying earlier version of object in S3 bucket to Redshift with COPY command

Contenus pertinents