Snowpro Associate Platform · Free Practice Question Easy
Question 4
What is the function of the SKIP_HEADER file format option when loading CSV data?
- A To include the header row as data.
- B To automatically create column names from the header row.
- C To ignore empty rows in the data file.
- D To skip a specified number of header rows.
Reveal correct answer
Correct answer: D
Explanation
✅ To skip a specified number of header rows.
Explanation:
The SKIP_HEADER option in a Snowflake FILE FORMAT definition tells Snowflake how many initial rows to skip when loading data — typically used to ignore header rows in CSV files.
For example:
- CREATE FILE FORMAT my_csv_format
- TYPE = 'CSV'
- SKIP_HEADER = 1;
This skips the first row (usually column names) during a COPY INTO operation.
❌ It does not include the header as data
❌ It does not auto-generate column names
❌ It does not ignore empty rows — use SKIP_BLANK_LINES = TRUE for that
You can find this setting in Snowflake’s CREATE FILE FORMAT documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
