sql take forever to run in Alteryx

[gin_nguyen]

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

[BrandonB]

Do you know what driver Alteryx is using to query the data? Also maybe try the OLEDB connection instead of ODBC. Sometimes this can be faster for a Microsoft SQL Server. 

[gin_nguyen]

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

[BrandonB]

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]

@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?