String length exceeds DDL length

In the AWS Glue Studio, when creating a new job, add a source node that connects to your data source. In the source node properties, you can specify the desired column length for the VARCHAR columns. For example, you can set the name column to have a length of 1000 characters. When creating the target node for the temporary table, the column definitions will be automatically generated based on the source schema. Verify that the VARCHAR column lengths are set as desired.

Alternatively, you can create the temporary table first, outside of the visual ETL job, and then use the MERGE statement to insert data from the source table into the temporary table

To complement the answer given by Vinit.

https://docs.aws.amazon.com/glue/latest/dg/edit-jobs-source.html