Floating point values are truncated when unloaded to which file format?
Floating point values are truncated when unloaded to which file format?
Floating point values are truncated when unloaded to CSV file format. This is because CSV files store numerical data in a text format which can lead to a loss of precision, resulting in truncated floating-point values.
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.
B. CSV
Sorry answer is B
correct answer C 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.
Avro is not supported for unloading.
In that case answer is B why do you choose C