https://community.qlik.com/t5/Talend-Studio/CSV-gt-Snowflake-Generated-Create-Table-script-replaces-column/m-p/2344090#M111783 <P>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<span class="lia-inline-image-display-wrapper" image-alt="0695b00000F7wDlAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153341i1FEEBDC56C473FC4/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000F7wDlAAJ.png" alt="0695b00000F7wDlAAJ.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000F7wDqAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129627iEC51BB91CD666D86/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000F7wDqAAJ.png" alt="0695b00000F7wDqAAJ.png" /></span></P> Sat, 16 Nov 2024 00:08:11 GMT evansdar 2024-11-16T00:08:11Z https://community.qlik.com/t5/Talend-Studio/CSV-gt-Snowflake-Generated-Create-Table-script-replaces-column/m-p/2344090#M111783 <P>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<span class="lia-inline-image-display-wrapper" image-alt="0695b00000F7wDlAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153341i1FEEBDC56C473FC4/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000F7wDlAAJ.png" alt="0695b00000F7wDlAAJ.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000F7wDqAAJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129627iEC51BB91CD666D86/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000F7wDqAAJ.png" alt="0695b00000F7wDqAAJ.png" /></span></P> Sat, 16 Nov 2024 00:08:11 GMT https://community.qlik.com/t5/Talend-Studio/CSV-gt-Snowflake-Generated-Create-Table-script-replaces-column/m-p/2344090#M111783 evansdar 2024-11-16T00:08:11Z https://community.qlik.com/t5/Talend-Studio/CSV-gt-Snowflake-Generated-Create-Table-script-replaces-column/m-p/2344091#M111784 <P>What is the real column name defined on the schema? Which version of studio you are using?</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Fri, 21 May 2021 06:55:42 GMT https://community.qlik.com/t5/Talend-Studio/CSV-gt-Snowflake-Generated-Create-Table-script-replaces-column/m-p/2344091#M111784 Anonymous 2021-05-21T06:55:42Z