AWS S3 SELECT WebUI error: "Quoted record delimiter found in the file"

Question

I am trying to the Select From for CSV in AWS S3 SELECT Web UI, but I get the following error msg:

Quoted record delimiter found in the file. To allow quoted record delimiters, please set AllowQuotedRecordDelimiter to 'TRUE'.

But there is no option to set AllowQuotedRecordDelimiter to TRUE

Please advise

I think you need python boto module for this to work. Add the parameter to s3.select_object_content. For e.g. InputSerialization = {'CSV': {"FileHeaderInfo": "Use", 'AllowQuotedRecordDelimiter': True,}}, as https://stackoverflow.com/questions/50848573/s3-select-csv-headers — shantanuo, Dec 16 '20 at 06:43
It's a pity that this is not available in the UI. Shouldn't have to run a script just to do an S3 Select — nonpoliticaltag, Mar 05 '21 at 12:48
1 year later - AllowQuotedRecordDelimiter SHOULD default to TRUE in the UI but still doesn't. — dataman, Feb 11 '22 at 04:42
yes, this should have been an easy fix for AWS team and quick win for the UI. — Saqib Ali, Jan 04 '23 at 23:08
This is still an issue. I just submitted a feature request for S3 SELECT to expose all input and output settings using the "Feedback" button in the bottom left-hand corner of the AWS Console. I recommend everyone do the same. — Randy Burden, Jan 30 '23 at 18:03

score -1 · Answer 1 · edited Apr 17 '23 at 21:59

-1

Try adding a " in the custom field under the CSV delimiter section, see picture bellow (This did the trick for me):

Changes require photo here

edited Apr 17 '23 at 21:59

cybersam

answered Feb 24 '23 at 18:42

bigtonito39

1 Answers1