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
>Solution :
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