Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the real column name defined on the schema? Which version of studio you are using?
Regards
Shong