community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

View SQL Generated by In-DB Tools

Comet

I would like to be able to view the SQL that a workflow leveraging In-DB tools is generating from within the Alteryx application.  I realize that I can likely get to these queries by monitoring the database, but other BI vendors (e.g. Microstrategy) allow the developer to see the SQL commands that are being generated.  This assists in areas such as benchmarking, troubleshooting, and QA.

Founder
Founder
You can see the SQL at any point in the process by hooking up a "Dynamic Output In-DB" tool.
Comet

Oh wow, perfect. Thank you.

Asteroid

Wow! This is great! Thanks!

How do you handle all the extra code generated that contains the tool name?

Meteoroid

@Ned,

 

This is great to be able to see the SQL query at any point in the process, but is there any way that if we rename the tool in the workflow (e.g. tool15 identified below) to something more customized by the user that alteryx can put it into the sql script instead so its more trackable/traceable?  Right now I have to use Ctrl F to open up the find tool window to do the tool number translation for me. 

 

Also, in the results output window where the sql script can be viewed is there only a set number of characters that can be displayed?  I can't seem to see all of the sql script.  Seems to cut short as indicated by the ... at the end.

 

 

WITH "Tool15_08f7" AS (SELECT * FROM "PATIENT"), "Tool14_0da3" AS (Select CLM.PID, CLM.ADMIT_DATE, CLM.DIS_DATE, CLM.AGE_YRS, CLM.GENDER_CODE, CLM...

Labels