How to insert latin data into a Snowflake Table

Question

We have a scenario, that we need to insert some special characters coming from file to the Snowflake table.

For exp:

emp_id| emp_name
110|Famille immédiate 

As the snowflake only allow UTF-8 format, when running the dml operation the data is not getting inserted into the table and throwing an error.

Have tried updating the file format command but no solution yet.

CREATE OR REPLACE FILE FORMAT DB.LayOut01_FORMAT TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1 ESCAPE_UNENCLOSED_FIELD = NONE REPLACE_INVALID_CHARACTERS = TRUE VALIDATE_UTF8 = FAlSE

What will be changes required to allow special charectors into the table as it is coming from source file ??

Insert Statement:

INSERT INTO DB.EMP_T ( emp_id, emp_name) 
SELECT
(temp.$1)  AS emp_id , (temp.$2)  AS emp_name 
from
$AZURE_FILE_STORAGE_LOCATION (file_format => DB.LayOut01_FORMAT, pattern=>'filename.csv') temp

Answer 1

UTF-8 is the only format for semi-structured data, but for structured you can insert data with different encodings.

Use on the file format the ENCODING parameter and set it to IS-8859-1, like:

CREATE FILE FORMAT ... ENCODING='ISO-8859-1'

For more information have a look here.