An error occurred when executing the SQL command:
Copy TR_BUYER_SELLER from 's3://awssampledbuswest2 xxl2/test2. CSV' CREDENTIALS 'aws_access_key_id=AKIAIXJXDM3WQLCESTUQ; Aws_secret_access_key=YyUI + III03p...

ERROR: The specified S3 prefix 'xxl2/test2. CSV' does not exist
Detail:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Error: The specified S3 prefix 'xxl2/test2. CSV' does not exist
Code: 8001
Context:
Query: 17775
Location: s3_utility. CPP: 545
Process: padbmaster [pid=22651]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- [SQL State=XX000]

Execution time: 0.37 s

1 the statement (s) failed.

CodePudding user response:

Perform in SqlWorkbench, copy command the data from the s3 copy to redshift always tip can't find the file

CodePudding user response:

You might as well to perform list xxl2 determine file exists?

CodePudding user response:

Upstairs eldest brother, how to implement the list xxl2? Use the client tools?

CodePudding user response:

Can you leave a contact way, please comment

CodePudding user response:

Every time I use this statement to the backup files: upload a file to S3: aws S3 cp local absolute path \ filename S3://remote_S3_bucket