escape caracter in AWS glue
Hi team, I have an AWS glue job that reads data from the CSV file in s3 and injects the data on a table in MySQL RDS Aurora DB.
The issue is all lines in the CSV file with escaped characters are completely ignored by the glue job and they are not inserted on the table.
For example on my CSV file the line containing this string is ignored by glue :
"Return "1" if the number is zero; "0" if the number is non-zero. xxxxxxxxxxxxxx."
how can I configure glue to not ignore those lines that contain escaped double quotes?
I found a solution :
In the AWS Glue console => Tables, choose the table and edit Edit table details.
add this detail :
- escapeChar, enter a backslash ().
How to escape a comma in a csv file in AWS Glue?Accepted AnswerMODERATORasked 3 years ago
AWS Glue RDS to single file CSVasked 5 months ago
AWS Glue - Read a 'local' file in Pythonasked 12 days ago
How to keep the source file name in the target output file with a AWS Glue jobAccepted Answerasked 2 years ago
backslash in CSV with glue
How to upload a parquet format file of RDS table data to S3 without using snapshotsasked 5 months ago
Glue Crawler CSV file with a field containing commasAccepted Answerasked a year ago
Partition schema mismatch in Glue Tableasked a month ago
escape caracter in AWS glueAccepted Answer
AWS Glue - setting data target for RDS mysqlasked 2 months ago