Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
xx_emanis
Contributor
Contributor

Error while loading from Delimited file to a Table

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.

 

0683p000009M13i.png

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

Labels (4)
3 Replies
Anonymous
Not applicable

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

xx_emanis
Contributor
Contributor
Author

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.

Anonymous
Not applicable

Hello,

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

0683p000009M13s.png

Best regards

Sabrina