Snowflake No Columns Returned

kimeryml

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?

apathetichell

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.