Join us, on May 27th, for an introduction to the new Dataiku Academy Learn more

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

Level 1
Syncing a table from postgres to snowflake and get error: NumberFormatException: For input string: "inf"
 
0 Kudos
1 Reply
Dataiker
Dataiker
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)