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
Copy LinkReport

As I could see the source is from google sheet and it is showing like this. Let me try with BIGINT and get back to you soon.

  • mbowen's avatar
    mbowen
    Employee
    4 years ago
    Copy LinkReport

    is annual_revenue an integer or a decimal? BIGINT will likely raise the same 1207 error trying to write a decimal value. It if should be an integer, then we should modify the pipeline to write this value as a integer.