Error loading AWS Redshift from S3

Question

I get an error when trying to load a table in Redshift from a CSV file in S3. Error:

   error:  S3ServiceException:All access to this object has been disabled,Status 403,Error AllAccessDisabled,Rid FBC64D9377CF9763,ExtRid o1vSFuV8SMtYDjkgKCYZ6VhoHlpzLoBVyXaio6hdSPZ5JRlug+c9XNTchMPzNziD,CanRetry 1
  code:      8001
  context:   Listing bucket=amazonaws.com prefix=els-usage/simple.txt
  query:     1122
  location:  s3_utility.cpp:540
  process:   padbmaster [pid=6649]

Copy Used:

copy public.simple from 's3://amazonaws.com/mypath/simple.txt' CREDENTIALS 'aws_access_key_id=xxxxxxx;aws_secret_access_key=xxxxxx' delimiter ',';

Since this is my first attempt to use Redshift and S3, I saved the simple.txt file (and its destination table) to one field entry. I ran a copy in both Aginy Workbench and Sql Workbench with the same results.

I clicked the link on the properties tab of the S3 file and uploaded the simple.txt file so that an accessible input file is available. To be sure, I gave him public access.

Unfortunately, I do not see any additional information that would be useful when debugging this tab on the Redshift Loads tab.

Can anyone see anything that I am doing wrong?

Answer 1

URL- amazonaws.com URL- . COPY :

copy public.simple from 's3://mypath/simple.txt' CREDENTIALS 'aws_access_key_id=xxxxxxx;aws_secret_access_key=xxxxxx' delimiter ',';

Answer 2

, IAM IAM aws_access_key aws_secret_access_key. , , . IAM : http://169.254.169.254/latest/meta-data/iam/security-credentials/{{roleName}}.

copy table_name
from 's3://objectpath'
credentials 'aws_access_key_id=<temporary-access-key-id>;aws_secret_access_key=<temporary-secret-access-key>;token=<temporary-token>';