CSV file upload to redshift failed using S3 copy command. A normal csv file, inside S3 bucket, delimited with ',' failed redshift upload with an error quoting delimiter not found in the load_stl_error table.

Along with the error, while checking values in load_stl_error table, I noticed all the csv data in one row, was encrypted together along with commas while copying data to redshift.

I was able to see proper data if I download manually from S3 bucket, but while copying into redshift fails because of encryption. Can somebody help?

I dont do any sort of encryption while storing data in S3.

0 Answers