SQL publish error

[HannahLiu66]

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?

[cmcclellan]

LOTS of questions to ask to debug this more, but can you post exactly where the error is occurring (hopefully a screenshot or three)

[HannahLiu66]

[HannahLiu66]

The workflow looks like this:

[cmcclellan]

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

[HannahLiu66]

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

[MichaelCordoba]

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.