We are facing performance issues while reading data in Alteryx designer from one of the Snowflake database objects using ‘Input’ as well as ‘In-Db Data Input’ tools.
We are seeing that when we run the workflow, the query finishes within 5 seconds on Snowflake end (when checked the query log on snowflake). But the Alteryx input tool keeps showing ‘running’ state and takes more than 3 hours to fetch the same data.
I am experiencing the same exact issue. Running Version 2021.3.4.00445. Using both this driver and the Simba Driver (64bit). I have plenty of RAM available on the server. From what I can tell, the issue revolves around the number of records being output (even if you selected very few columns and the total size of the data is small).
My most recent experience is a query that takes 35 seconds to run in Snowflake takes 1:36 hours to output into a Browse within Alteryx. I am only trying to retrieve 405 MB of data. Something seems very off.