Snowflake No Columns Returned
- 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 have a query that is connecting to Snowflake. Alteryx pulls the data from Snowflake fine. My issue is when I try to insert the data into a SQL table. Under Append Field Map, all of my destinations say [None] or the number 1. Since there are no fields to map too, the workflow errors out with No Columns Returned. Anyone have a suggestion?
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey -> I have minimal idea what this means -> My issue is when I try to insert the data into a SQL table. Under Append Field Map, all of my destinations say [None] or the number 1. Since there are no fields to map too, the workflow errors out with No Columns Returned. Anyone have a suggestion?
and I am fairly knowledgeable on Alteryx/Snowflake. Can you explain what you are trying to do - and how you are trying to do this? If you are writing to Snowflake -> and writing on canvas vs In-db - configure your snowflake ouptut connection in your manage in-db connections. stage it locally - if you don't have service account credentials for an S3 bucket. Write via output data tool to snowflake. (or datastream in). You don't need a prexisting schema map. You don't need a SQL table.
