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")
Solved! Go to Solution.
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