This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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")