Snowflake SQL Compilation Error Column Does Not Exist
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Labels:
- Database Connection
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
