Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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