String length exceeds DDL length

Question

When creating the temporary table to perform the MERGE in Redshift, I get the error "**String length exceeds DDL length.**" I am using visual ETL. How can I make Redshift use the maximum length for a varchar column instead of the default 256 when creating the temporary table?

asser_m · Answer

To complement the answer given by Vinit.

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

AWS TAM · Answer

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

String length exceeds DDL length

Add your answer

Relevant content