Syncing a table from postgres to snowflake and get error: NumberFormatException: For input string: "

Options
thunt
thunt Registered Posts: 2 ✭✭✭✭

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    Hi,

    This is a known limitation of the Snowflake driver which supports inserting infinity values represented with the standard "inf" string but does not support re-reading them.

    You'll need to use a prepare recipe to create your Snowflake dataset in order to remove the infinity values
Setup Info
    Tags
      Help me…