Unload from Redshift to an S3 bucket of a box

Question

I'm trying to unload data from a Redshift cluster in one box to an S3 bucket in another box. I have managed to send the file. However, as the bucket owner is not the owner of the file I'm sending - he cannot access it. As it's a straight unload from Redshift, I don't think I can't specify condition to allow the bucket owner the right permissions. Is it even possible to achieve (without having to unload from Redshift using the same account) and if so - how? Thanks! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

(Attempt #2...) Okay, it seems your situation is: You are doing an UNLOAD from Amazon Redshift into an Amazon S3 bucket that belongs to a different AWS Account A user within that different AWS Account wishes to access the files but says that they are unable to do so There is no concept of a "file owner" in Amazon S3. Instead, there are: Permissions associated with each object in Amazon S3 A bucket policy that applies to a specific bucket IAM policies that can be applied to Users, Groups and Roles As long as at least one of these permissions grants access and none of them specifically deny access, then users will be able to access the files. If the user reports not being able to view the files, then ensure that ListBucket and GetObject permissions have been granted via one of the above methods.