Contributor II
2021-05-20
10:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CSV -> Snowflake. Generated 'Create Table' script replaces column names with smiley face
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
354 Views
1 Reply
Anonymous
Not applicable
2021-05-21
02:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the real column name defined on the schema? Which version of studio you are using?
Regards
Shong
354 Views