Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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