Importing data from Amazon S3 into an RDS

0

Hello,

I'm importing data from S3 to RDS (Postgre) by using aws_s3.table_import_from_s3 extension. Unfortunatelly I'm getting error "Semicolon is not allowed in options". Is semicolon allowed delimeter? Is there any list of allowed/not allowed delimiter options?

Error messsage retunerd: Got exception: state : XX000 message: Semicolon is not allowed in options detail : hint : context: SQL statement "SELECT aws_s3.table_import_from_s3 ( 'l1_stage_year_end_result_tmp', 'surname,first_name,ext_employee_id,performance_year_end_result,behaviour_year_end_result,developmnent_year_end_result', lp_options, lp_s3_uri, lp_file_path, 'eu-west-1'::text )"

MartinT
已提問 1 年前檢視次數 338 次
1 個回答
0

Kindly refer to this documentation from AWS for delimiter option Importing data from Amazon S3 into an RDS for PostgreSQL DB instance.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html

AWS
已回答 1 年前
profile pictureAWS
專家
已審閱 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南