When unloading data into a stage in Snowflake, the FILE_EXTENSION file format option specifies the extension for the output files (e.g., .csv for CSV files or .json for JSON files). While the TYPE parameter (e.g., CSV or JSON) defines the format itself, FILE_EXTENSION explicitly controls the file extension. This ensures the output files are saved with the correct format-specific suffix.
Why the other options are incorrect:
A. PARSE_HEADER: Used during data loading (not unloading) to parse headers in CSV files.
B. TRIM_SPACE: Trims whitespace during data loading, irrelevant to unloading.
D. SKIP_HEADER: Skips header rows during loading, not applicable to unloading.
FILE_EXTENSION is the only option directly tied to defining the output file format when unloading data.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1 week, 6 days ago