We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Snowflake No Columns Returned

kimeryml
5 - Atom

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?

1 REPLY 1
apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors