Ensure precise CSV data exports in Snowflake with the file_extension format option.
Table of Contents
Question
A user wants to unload data from a relational table into a CSV file in an external stage. The table must be named exactly as specified by the user.
Which file format option MUST be used to do this?
A. encoding
B. escape
C. file_extension
D. single
Answer
C. file_extension
Explanation
The correct file format option to use when unloading data from a relational table into a CSV file in an external stage is C. file_extension. This option ensures that the unloaded file has the specified extension, such as .csv, which is necessary for the file to be recognized and processed as a CSV.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.