sql take forever to run in Alteryx

Question

Hi,

Hope you can give me some insights. I have an SQL code. I tested in SQL Studio, it takes only a few seconds to get the result (about 5000+ rows only) but when i use this code in Alteryx, it takes "forever" to run (no error show). Do you have any idea?

P/s: i am very sure the SQL code has no error and i already checked query error in alteryx.

Thank you

alteryx pic test.PNG

gin_nguyen · Answer

@BrandonB i changed to connect directly to an online server on Alteryx Gallery but it is the same. it takes "forever" to run... i think it shouldnt be odbc issue?

BrandonB · Answer

ODBC should work just fine, but because the driver is the way that your computer is effectively transferring the data over to your computer, sometimes using a different one can be more efficient. I would also recommend taking a look at our data sources page for more information about your specific source: https://help.alteryx.com/current/designer/data-sources

gin_nguyen · Answer

Hi @BrandonB : i am using ODBC. it is the issue? thank you