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

0

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.

已提问 2 年前347 查看次数
1 回答
0

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

Isaac_P
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则