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

Highlighted
thunt
Level 1
Syncing a table from postgres to snowflake and get error: NumberFormatException: For input string: "inf"
 
0 Kudos
1 Reply
Clément_Stenac Dataiker
Dataiker
Re: Syncing a table from postgres to snowflake and get error: NumberFormatException: For input string: "inf"
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
0 Kudos
Labels (3)