When unloading data, which file format preserves the data values for floating-point number columns?
When unloading data, which file format preserves the data values for floating-point number columns?
When unloading data, the Parquet file format preserves the data values for floating-point number columns without truncation. Parquet is designed to handle complex data types and ensures that the precision of floating-point numbers is maintained. In contrast, formats like CSV and JSON may truncate floating-point numbers, losing their precision.
https://docs.snowflake.com/en/user-guide/data-unload-considerations#floating-point-numbers-truncated
Floating-point Numbers Truncated When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). The values are not truncated when unloading floating-point number columns to Parquet files.
Correct Answer is D. * When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9). * The values are not truncated when unloading floating-point number columns to Parquet files. https://docs.snowflake.com/en/user-guide/data-unload-considerations#floating-point-numbers-truncated
D. Parquet https://docs.snowflake.com/en/user-guide/data-unload-considerations
Paraquet
D. Parquet is correct
correct
https://docs.snowflake.com/en/user-guide/data-unload-considerations#floating-point-numbers-truncated
Avro is correct
Parquet is more relevant to this question
And which format doesn't?
Avro is not supported for unload.