
Explanation:
The FIELD_OPTIONALLY_ENCLOSED_BY option is specifically designed to handle fields that may be enclosed by quotation marks (single or double quotes) in CSV files. When set to a quote character like '"' or "'", Snowflake will recognize and properly parse these enclosed fields. The community discussion confirms this with 100% consensus on option C, citing official Snowflake documentation that explains how to handle enclosed fields. Other options are less suitable: BINARY_FORMAT is for binary data, ESCAPE_UNENCLOSED_FIELD handles escaping in unenclosed fields, and SKIP_BYTE_ORDER_MARK deals with BOM characters in UTF-encoded files.
No comments yet.
Which option should be selected when creating a CSV file format in Snowflake to handle columns that are enclosed by single quotes (') or double quotes (")?
A
BINARY_FORMAT
B
ESCAPE_UNENCLOSED_FIELD
C
FIELD_OPTIONALLY_ENCLOSED_BY
D
SKIP_BYTE_ORDER_MARK