When a source table column is set as a double and snowflake is the target.  HVR sets the datatype as a float on the target side.  If the source side double column has a value like 0.123456789012346 on the target side has a value of 0.123456789.  When they run a compare they get that the values do not match.  Float may not be the best way to convert a double datatype for snowflake.