Skip to content
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
Aurora PostgreSQLPostgreSQLDatabase
Language
English
asked 2 years ago1.2K 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

EXPERT
answered 2 years ago

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.

Relevant content