Answer-first summary for fast verification
Answer: The number of columns in each row should be consistent.
Option B is correct because Snowflake requires consistent column counts across all rows in CSV files for successful loading. The community discussion strongly supports this with high upvotes (4 upvotes for the most detailed explanation) and references to official documentation. Option A is incorrect because Snowflake supports various delimiters, not just commas. Option C is incorrect because while compression is recommended for performance, it's not required. Option D is incorrect because Snowflake allows loading files with more columns than the target table by specifying column mappings or transformations in the COPY command.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When loading CSV data from a stage in Snowflake, which guideline for the COPY INTO <table> command should be followed?
A
The CSV field delimiter must be a comma character (‘,’).
B
The number of columns in each row should be consistent.
C
The data file in the stage must be in a compressed format.
D
The data file must have the same number of columns as the target table.
No comments yet.