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
)"
AWS 官方已更新 2 年前
Hi, I did read this AWS documentation but there is no mentios about any excetoptions regarding delemiter. Can you please again check my error message?
In stackoverflow there is mention that semicolon is not supported but I would like to verify it.
https://stackoverflow.com/questions/62302191/importing-csv-file-with-semicolon-delimiters-from-s3-to-rds-postgres-database
Thank you MArtin