Insert pre-made SQL query and perform its function?

[Danial_Nawab]

Hello everybody, 

I have a pre-made complex SQL query that I plan on integrating with workflow in Designer but I don't plan on performing the query functions in Designer using Alteryx provided tools(such as the In-DB or Preparation palette tools). I simply want to copy-paste the query into a tool that would perform the function mentioned in the SQL query. 

Note: I believe that this could not be achieved using the Dynamic Input and Connect In-DB tool as they only deal with reading-in data.

Any advice would be appreciated. 

[cmcclellan]

If it's a query (ie SELECT) then I would always use a Connect in-DB tool and paste the query into the SQL Editor window

[AZuc]

@Danial_Nawab 

Have you seen this option?

[Danial_Nawab]

Hi André,

Unfortunately, I am unaware of this option. Can you please specify where I can find this?