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

Redshift varchar(max) not enough to store json data type column from Postgres

0

Redshift varchar(max) not enough to store json data type column from Postgres. Which data type should I use to store the column, I am using glue to perform the ETL and storing to Redshift, Postgres has Json data type but in Redshift the limit is exceeding even by varchar(max). Getting below error in STL_LOAD_ERRORS table-redshift ->String length exceeds DDL length
Is there any workaround or direct solution, as super data type is not supported in Glue, so can't map that to the column.

1 Answer
0

Hi,

In Redshift for storing JSON data we have introduced the SUPER data type.

However, the SUPER data type only supports up to 1MB of data for an individual SUPER field or object. For more information, see Ingesting and querying semistructured data in Amazon Redshift.

hope this helps,

EXPERT
answered 7 months 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