Alteryx designer Discussions

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

InDB write No Columns error on Snowflake

Alteryx Certified Partner

I have am trying to update a table in Snowflake on one database with the data from a table in a different database. 

I am using the Dynamic Input In-DB tool with a query that works directly in snowflake but it does not work in alteryx. Is alteryx able to write across databases on the same server or is that a limitation of the tool?


for reference the query is:



Alteryx Certified Partner

so speaking to a colleague, I have found that I was over complicating the process. if I use a fully qualified table name directly in an InDB write tool ie 


then the table will be created in the second database schema