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
Advertisement
Answer
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