Avatar of jisoo411
jisoo411
 asked on

Problems doing a COPY from AWS S3 to AWS Redshift

I'm admittedly a neophyte when it comes to the AWS ecosystem so please be patient :)

I'm attempting to do a common bulk load of a csv file located in a bucket on S3 to a table on Redshift.  Here is the copy command:

COPY tmp_target_table (column1,column2,column3,column4)
from 's3://reference-data/subfolder1/new_data.csv'
credentials 'aws_access_key_id=<MyAccessKey>;aws_secret_access_key=<MySecretAccessKey>' 
delimiter ',';

Open in new window


But I get the following error message:

ERROR:  S3ServiceException:The AWS Access Key Id you provided does not exist in our records.,Status 403,Error InvalidAccessKeyId...

Open in new window


I've double checked my keys to make sure it wasn't a copy and paste problem.  I also utilize the same keys to access S3 directly through CyberDuck and log into the AWS CLI, both with no problem.  Has anyone had a similar problem?

Thanks,
Glen
AWS

Avatar of undefined
Last Comment
Zephyr ICT

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Zephyr ICT

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jisoo411

ASKER
Yeah these are the right kinds of credentials.  I did find out the problem, which was a combination of two things.  Didn't need to carrots on either side of the keys and the s3 bucket I was trying to access had been renamed *shakes fist*.  Oh well, at least it works now.  Thanks!
jisoo411

ASKER
Good and informative, thanks!
Zephyr ICT

Thanks!

Sorry, I was away for a few days.
Your help has saved me hundreds of hours of internet surfing.
fblack61