When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? {Select TWO).

The correct answer is C. output_file D. output_format. When unloading data via SnowSQL on a local machine, two options are required: output_file (C) specifies the local file path where query results will be written, and output_format (D) specifies the format of the exported data (e.g., csv, json, tsv). Without both, SnowSQL cannot…

Data Loading and Unloading

Question

Options

Aecho
Bquiet
Coutput_file
Doutput_format
Eforce_put_overwrite

How the community answered

(27 responses)

A
4% (1)
B
15% (4)
C
74% (20)
E
7% (2)

Explanation

When unloading data via SnowSQL on a local machine, two options are required: output_file (C) specifies the local file path where query results will be written, and output_format (D) specifies the format of the exported data (e.g., csv, json, tsv). Without both, SnowSQL cannot direct output to a file in a structured format. The other options are unrelated to data unloading: 'echo' repeats SQL commands in output, 'quiet' suppresses informational messages, and 'force_put_overwrite' applies to the PUT command for uploading files to stages - not for unloading.

Topics

#SnowSQL#Data Unloading#Configuration#Local File Output

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice