AWS Glue Studio Job Failed An error occurred while calling o106.pyWriteDynamicFrame. Data truncation: Data too long for column [insertcolumnname] at row 1

0

I am trying to add csv files to RDS MySQL database and successfully created my files in Glue Databrew, crawled them in Glue, but when I run my Job in Glue Studio I get an error: "An error occurred while calling o106.pyWriteDynamicFrame. Data truncation: Data too long for column [insertcolumnname] at row 1". I recreated the files in jupyter notebook and there are no columns with len >255 and most are around len~80 characters. A job for one of my tables (a very simple one) did successfully run and is in my MySQL database, but all the other tables fail with this error. What am I missing here?

asked 3 months ago54 views
No Answers

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