InDB write No Columns error on Snowflake

Question

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")

paul_houghton · Accepted Answer

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