When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

The correct answer is D. (15,9). When Snowflake unloads floating-point (FLOAT, DOUBLE, REAL) column values to CSV or JSON files, it truncates the values to approximately 15 significant digits with up to 9 decimal places - represented as (15, 9). This is consistent with the IEEE 754 double-precision…

Data Loading and Unloading

Question

Options

A(12,2)
B(10,4)
C(14,8)
D(15,9)

How the community answered

(21 responses)

A
5% (1)
D
95% (20)

Explanation

When Snowflake unloads floating-point (FLOAT, DOUBLE, REAL) column values to CSV or JSON files, it truncates the values to approximately 15 significant digits with up to 9 decimal places - represented as (15, 9). This is consistent with the IEEE 754 double-precision floating-point standard, which provides roughly 15–17 significant decimal digits of precision. The other options - (12,2), (10,4), and (14,8) - represent lower precision levels that are not aligned with how Snowflake handles floating-point unload operations. Understanding this behavior is important when downstream systems need to ingest unloaded data with full numeric fidelity.

Topics

#Floating-point numbers#Data unloading#CSV/JSON formats#Precision

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice