Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Getting "error_code": 1207 while validating before loading Redshift database

Hi All, I am trying to load a new redshift table which I have created. While validation, I am getting “error_code”: 1207 “error_message”: "Invalid digit, Value ‘.’, Pos 9, Type: Integer " “co...
mbowen's avatar
mbowen
Employee
4 years ago

@amardeep2021

A Redshift 1207 load error indicates the data contains a value outside of the expected range of 0-9.

You will receive this error if you try to write this value to an INTEGER field in the database which appears to be the case here – maybe changed during your experiments to get this working. If you change the database field to a REAL or DOUBLE PRECISION, you’ll still get a 1207 if I use your value which appears to have a trailing space. After removing the extra space character, I’m able to insert the value into a real or double field.