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