Alteryx designer Discussions

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

InDB write No Columns error on Snowflake

Highlighted
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:

INSERT OVERWRITE INTO "FINANCE"."FINANCE_RPT"."DASHBOARD1"
(SELECT * FROM "FINANCE"."FINANCE_STG"."_DASHBOARD_DELETE")

 

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 

"FINANCE"."FINANCE_RPT"."DASHBOARD1"

then the table will be created in the second database schema

Labels