By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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?

Topics
AnalyticsMigration & ModernizationDatabaseStorage
Tags
AnalyticsAmazon Relational Database ServiceAWS GlueData LakesExtract Transform & Load Data
Language
English
Jess
asked 3 years ago2130 views
1 Answer
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 ().
Jess
answered 3 years ago
AWS
EXPERT
Fabrizio@AWS
reviewed 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content