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...
amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Thanks for the response Matthew. You are suggesting to use trim() before loading the data for the table data type as double precision or real? Kindly confirm.

Regards,
Amar.

  • mbowen's avatar
    mbowen
    Employee
    4 years ago

    @amardeep2021 yes! well, at least give this a try …