Importing data from Amazon S3 into an RDS

Question

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
					)"

Nitin Pathak · Answer

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

Importing data from Amazon S3 into an RDS

Relevant content