Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Insert pre-made SQL query and perform its function?

Danial_Nawab
5 - Atom

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. 

3 REPLIES 3
cmcclellan
13 - Pulsar

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
Alteryx
Alteryx

@Danial_Nawab 

 

Have you seen this option?

AZuc_0-1636407518781.png

 

André Zuccatti

Sales Engineer - LATAM -
Alteryx, Inc.


Danial_Nawab
5 - Atom

Hi André,

 

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

Labels