escape caracter in AWS glue
0
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?
asked 6 months ago116 views
1 Answers
0
Accepted Answer
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 ().
answered 6 months ago
Relevant questions
How to escape a comma in a csv file in AWS Glue?
Accepted AnswerAWS Glue RDS to single file CSV
asked 5 months agoAWS Glue - Read a 'local' file in Python
asked 12 days agoHow to keep the source file name in the target output file with a AWS Glue job
Accepted Answerasked 2 years agobackslash in CSV with glue
asked 6 months agoHow to upload a parquet format file of RDS table data to S3 without using snapshots
asked 5 months agoGlue Crawler CSV file with a field containing commas
Accepted Answerasked a year agoPartition schema mismatch in Glue Table
asked a month agoescape caracter in AWS glue
Accepted Answerasked 6 months agoAWS Glue - setting data target for RDS mysql
asked 2 months ago
Hi, you are right, please also see the Glue Documentation Page https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html