Issue while Inserting decimal value in Snowflake by selecting form SAS, having difference of penny most of the time. Seems like that snow is ceiling down to -.1. Please see AMT1 and AMT2 columns in following examples and advise. Is there something I need to set on table level or a special format I need to apply before I insert it? Data from SAS ### xxx AMT1 AMT12 AMT3 203507725 57.97 39.99 17.98 203507728 95.97 75.98 19.99 203507731 57.97 39.99 17.98 203507732 77.97 59.99 17.98 203507733 67.97 49.99 17.98 203507736 188.96 165.98 22.98 Data showing/Appending in Snowflake ### xxx AMT1 AMT12 AMT3 203507725 57.96 39.99 17.98 203507728 95.96 75.98 19.99 203507731 57.96 39.99 17.98 203507732 77.96 59.99 17.98 203507733 67.96 49.99 17.98 203507736 188.95 165.97 22.98
... View more