For the column delimiter in the file format, you can use a symbol that you'll never encounter including a multi-char delimiter. There is a dedicated UI for importing DSV (CSV and TSV) files to the database.
To do that, specify a table with only one column. The first thing you want to do is bring the whole line into Snowflake as a single column. Set data extraction options (how the data will be read.
It looks as if you'll need a custom parser. Exporting table data to CSV format Select a table or tables you want to export.