By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Error while importing data from s3 to Aurora Postgres RDS

0

I am using below command to load data from s3 to postgresql database. SELECT aws_s3.table_import_from_s3 ( 'delta.t_etails', '', '(FORMAT csv, HEADER true, DELIMITER '','', QUOTE ''~'', ENCODING ''UTF8'')', aws_commons.create_s3_uri( 'dbkt1-itaaaaa', 'aample_1.csv', 'us-east-1' ) );

Error: ERROR: Unable to validate pre-signed URL. Error: HTTP 404. Requested file does not exist. CONTEXT: SQL function "table_import_from_s3" statement 1

Topics
Database
Tags
PostgreSQLAurora PostgreSQLDatabase
Language
English
Admin
asked 2 years ago1K views
1 Answer
0

404 error code is not found.

Ensure file and bucket name is correct and the correct bucket policy is in place too

profile picture
EXPERT
Gary Mclean
answered 2 years ago
  • Admin
    2 years ago

    What is the bucket policy required? Can you pls share details?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content