Snowflake SQL Compilation Error Column Does Not Exist

Question

I keep running into this error trying to use the Bulk Loader:

"sql compilation error: column does not exist"

Error: Output Data (113): Error message from ODBC connection: SQL compilation error:

Also, note that the fields and table load but not the data.

I have been unable to figure this one out over the past 24 hours so I thought I would drop it here in case there any thoughts.

Thanks,

apathetichell · Answer

sorry it's a bit hard to track down there error here without knowing data formats, table schema in snowflake, bulk loader set up etc...

derreck0218 · Answer

Well, I am doing local as well, but now, I am starting to suspect one potential issue where some field names would have been duplicated but they also changed downstream.  I am keeping that theory in mind but I kind of dismiss it because one column being referenced as not existing wasn't a duplicate value.

apathetichell · Answer

can you share more info? are you publishing local and then to snowflake? is it going to s3? what else can you tell us about the workflow and the snowflake objects.