Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Insert pre-made SQL query and perform its function?

Danial_Nawab
7 - Meteor

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 Alumni (Retired)

@Danial_Nawab 

 

Have you seen this option?

AZuc_0-1636407518781.png

 

André Zuccatti

Sales Engineer - LATAM -
Alteryx, Inc.


Danial_Nawab
7 - Meteor

Hi André,

 

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

Labels
Top Solution Authors