I have a tbale both inm snowflake and postgres in postgres the numeric column is defined as numeric(20,6) in snowflake also it is defined as numeric(20,6) but when I am doing the sum of that column I am getting value like :

 0.00123 in postgres and
 0.000124 in snowflake

Now again I jumped into snowflake and changed the column definition to (20,5) then, I got the same result as in postgres that is 0.00123

can anyone explain this strange behaviour of snowflake

Thanks in Advance

CodePudding user response：

Please review, if the below migration guide might be of help: https://community.snowflake.com/s/article/PostgreSQL-to-Snowflake-ETL-Steps-to-Migrate-Data