I want to Insert the string of 1 million size into the Redshift. I tried using different compression method given by Redshift but after some particular length, Redshift also truncate the data. Any suggestion?
0
votes
consider adding more information about your question
- Inder
Unfortunately, there is no enough information in your question to provide an answer. (In fact, I don't even know what you are asking!) Please edit your question to provide more information. Are you saying that each row of data is 1 million characters long? Or one column is 1 million characters long? Or are you trying to load 1 million rows? More information please!
- John Rotenstein
if you explain what you are going to do with it once its there - we can then help
- Jon Scott
1 Answers
0
votes
The maximum VARCHAR size in Redshift is 65,535 bytes. You'll have to split your string across multiple columns or multiple rows.
https://docs.aws.amazon.com/redshift/latest/dg/r_Character_types.html
