Does Snowflake has some issue with Double Precision, Float, Real Data Type

user_13979584 0
Viewed 862

Recently I migrated data from netezza to Snowflake. The problem I am facing is with double precision data type. In netezza DB double precision field has value of .34757853258953 but when I query same in Snowflake UI I see it as .3475785326.

Anyone has any idea why so and how to deal with it.

snowflake-schema snowflake-cloud-data-platform
1 Answers

This is a UI limitation, not a Snowflake limitation. The value stored is correct, but the UI display only shows 9 digits past the decimal point. You can verify like this:

SELECT  0.34757853258953::DOUBLE, 0.34757853258953::DOUBLE * 100000;
user_121789800
Related