Make Input Data Tool Configure Faster

[air0storm]

I have an Input Data tool connected to a ODBC database. The warehouse is enormous, although the individual table I am querying is not that big. When I run the workflow it doesn't take too long. But when I want to tweak my SQL query it takes forever. I click on the three dots by "Table or Query" and it takes 4 minutes to open the SQL statement. I just want to quickly change something in the where clause but that takes ages. I think it's because Alteryx is loading the entire table list from the warehouse.

I already went to settings and disabled auto configure. Is there any way to speed this up further so that I can make small changes to my SQL query quickly?

[afv2688]

Hello @air0storm ,

There is a way to do something that would maybe help on this topic. What I am talking about is adding your intput tool into a batch macro and selecting the query to modify it. Adding then afterwards the query you want to edit or modify could help you in improving the overall speed. You might not even need to select the whole thing and just a few parameters, depending on your needs.

This for sure is not pretty but might solve the issue you are having.

Regards

[air0storm]

Hi Nebula, thanks for the reply. That might work for me. Do you know any examples of this setup that I could work off?

[afv2688]

Hello @air0storm ,

There are many examples about how to do post methods on alteryx. I will leave you some here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Use-an-HTTP-POST-call-to-this-endpoint...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/POST-request-using-Alteryx-works-with-...

Regards

[air0storm]

As a Hail Mary, I'm still hoping for a solution that will actually get the Input Data tool itself to run faster. But forgetting that, I think a slightly easier way than the batch macro is to use a Dynamic Input tool. And then set the entire query as the "String to Replace" and just write my SQL query in an "input text" tool