Snowpro Associate Platform · Free Practice Question Easy
Question 13
How do you specify a custom delimiter for a CSV file when using COPY INTO <TABLE>
- A Using the COLUMN_SEPARATOR query parameter
- B Using the DELIMITER_CHAR table property.
- C Using the FIELD_DELIMITER file format option
- D Using the FIELD_SEPARATOR stage property.
Reveal correct answer
Correct answer: C
Explanation
✅ Using the FIELD_DELIMITER file format option
Explanation:
To specify a custom delimiter (like a pipe | or semicolon ;) when loading a CSV file with COPY INTO <TABLE>, you define it using the FIELD_DELIMITER option in the FILE_FORMAT clause. For example:
- COPY INTO my_table
- FROM @my_stage
- FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = '|');
This tells Snowflake how to correctly parse the fields in your CSV file.
❌ DELIMITER_CHAR – Not a valid table property
❌ FIELD_SEPARATOR – Not a recognized stage property
❌ COLUMN_SEPARATOR – Not a valid query parameter in Snowflake
You can find this in Snowflake’s COPY INTO documentation
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
