Skip to content
Advertisement

Different behaviour of Numeric columns in postgres and Snowflake

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

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement