Make Input Data Tool Configure Faster

Question

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?

air0storm · Answer

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

afv2688 · Answer

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-with-some-JSON/td-p/41856

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/POST-request-using-Alteryx-works-with-Postman-not-with-Alteryx/td-p/91443

Regards

air0storm · Answer

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