SQL publish error

Question

Hi,

I've got an issue in the final output to snowflake.

It used to work well. Not sure why it doesn't work to append new files to the snowflake table anymore.

The error shows an error SQL Prepare:

SQL compilation error: line 1 at position 758 invalid identifier ' "Data Entry Error"'

but even I removed the column, the next column shows the same error. Can I have some tips how to fix it?

MichaelCordoba · Answer

Seems the issue has to do with the double quotes, remember that Snowflake follows SQL standards meaning that  whether is double quotes " " or singles ' ' will make the difference as far as how snowflake will understand the statement.

HannahLiu66 · Answer

I've tried to deselect the column, then the same issue would happen on the next column.

cmcclellan · Answer

Hmmm ... maybe the table doesn't have a column called "Daily Entry Error" any more ?  On the Alteryx side or the Snowflake side ?