topic Re: Error while loading from Delimited file to a Table in Talend Studio

Error while loading from Delimited file to a Table

xx_emanis — Sat, 16 Nov 2024 07:18:59 GMT

Hi All,

I have a scenario where I am trying to load data from a CSV file to a table in Snowflake Database and getting the below error.

Below is my Flow.

Below is the error I am getting.

invalid identifier '"Application"'.

I have the Application column in target database. And also I double checked for spelling as well and it matches with the source. Not sure why this is occuring.

Can you please help me on this.

Thanks

Re: Error while loading from Delimited file to a Table

Anonymous — Tue, 13 Nov 2018 03:39:16 GMT

Hello,

Is there any space or special character in your column name?

Have you tried to uncheck "Convert columns and table to uppercase" in advanced settings of tSnowflakeoutput component to see if it is OK with you?

Best regards

Sabrina

Re: Error while loading from Delimited file to a Table

xx_emanis — Tue, 13 Nov 2018 04:01:33 GMT

Thanks for your reply. I do not see any spaces around the column name. Also I do not see the option you asked me to look in Advanced settings.

Re: Error while loading from Delimited file to a Table

Anonymous — Tue, 13 Nov 2018 07:16:29 GMT

Hello,

Are you able to uncheck 'Convert columns and table to uppercase' option in advanced setting of tSnowflakeoutput?

Best regards

Sabrina