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.

demandé il y a 2 ans348 vues
1 réponse
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
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions