Skip to main content

Snowflake Numeric value is not recognized

Comments

3 comments

  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    The error being returned by Snowflake "Numeric value 'Other' is not recognized" makes me think that the column in Snowflake is not a VARCHAR (i.e. it is likely setup as an INTEGER or equivalent).  Can you double check this?  If you are positive it is setup correctly in Snowflake, then I def recommend contacting support.

    0
  • Alex Baeza
    Answer Pro
    Celigo University Level 4: Legendary
    Awesome Follow-up

    No need to contact support, I am now importing the entire record as a variant.

    From there I should be able to manipulate the data in snowflake from there. I think the data type issues were caused by shifting columns in snowflake due to missing key value pairs in some records in the JSON response.

    Thanks for all your help.

    0
  • Scott Henderson CTO
    Answer Pro
    Top Contributor

    My pleasure!

    0

Please sign in to leave a comment.