CSV -> Snowflake. Generated 'Create Table' script replaces column names with smiley face

[evansdar]

Today in weird talend things...Trying to load data from a csv to a snowflake table with 'drop if exists and create' select as the option. The query fails due to the letters in some column names being replaced with a :). Every column name is simple and works with encoding us-ascii or utf-8, changing this doesn't seem to affect the end result. I could manually create the tables, but would rather not. In some instances it replaces the entire column name with smiley faces, in other cases it keeps portions of the original name, and replaces only a substring

[Anonymous]

What is the real column name defined on the schema? Which version of studio you are using?

Regards

Shong