Source
How to convert your input data to UTF- 8 before sending it to Snowflake
Snowflake supports three binary formats or encoding schemes: hex, base64, and UTF - 8. Snowflake requires that incoming data files use this encoding. Attempting to load files into Snowflake tables that do not comply with these can result…
Solution: UTF-8 characters are not displayed correctly in SQLWorkbench/J on Windows
CAUSE: It appears when running SQLWorkbench/J on Windows and connecting to Snowflake via the JDBC driver, the data is not getting encoded in UTF - 8; therefore, invalid characters are rendered in the client.