SOL-C01 · Question #155
You are using the 'COPY INTO' command to load data from an Amazon S3 bucket into a Snowflake table named 'employees'. The data in S3 is in CSV format, compressed with gzip, and contains a header…
The correct answer is A. Option A. Option A is correct because it includes all three required parameters for this scenario: FILE_FORMAT = (TYPE = CSV, COMPRESSION = GZIP, SKIP_HEADER = 1) to handle the compressed CSV with a header row, and ON_ERROR = CONTINUE to allow the load to proceed past data conversion…
Question
You are using the 'COPY INTO' command to load data from an Amazon S3 bucket into a Snowflake table named 'employees'. The data in S3 is in CSV format, compressed with gzip, and contains a header row. You want to skip the header row during the load and handle any data conversion errors by continuing the load operation. Which of the following 'COPY INTO' commands is most appropriate?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(26 responses)- A81% (21)
- B4% (1)
- C12% (3)
- E4% (1)
Explanation
Option A is correct because it includes all three required parameters for this scenario: FILE_FORMAT = (TYPE = CSV, COMPRESSION = GZIP, SKIP_HEADER = 1) to handle the compressed CSV with a header row, and ON_ERROR = CONTINUE to allow the load to proceed past data conversion errors rather than aborting. The other options likely fail on one or more of these requirements - common mistakes include using ON_ERROR = ABORT_STATEMENT (the default, which stops the entire load on any error), ON_ERROR = SKIP_FILE (which skips the whole file rather than just bad rows), omitting SKIP_HEADER = 1 (which would attempt to load the header row as data), or missing/incorrect compression settings. A helpful memory tip: think of the three requirements as a checklist - Format (CSV + GZIP), Filter (SKIP_HEADER = 1), and Fault tolerance (ON_ERROR = CONTINUE) - if any one of these is missing or wrong in an option, eliminate it.
Topics
Community Discussion
No community discussion yet for this question.