Redshift tips

How to ignore errors in Redshift COPY?

Recently I had to upload multiple big datasets on Redshift just for test purposes. To do that, I used COPY command which makes data loading very fast. Everything was working great for all datasets exc...

Continue Reading →

How to solve Redshift 'maximum column length exceeds 255 code:' error?

I encountered that problem at table's creation time: [Amazon](500310) Invalid operation: ----------------------------------------------- error: Maximum column length exceeds 255 code: 8001 cont...

Continue Reading →