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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南