View SQL Generated by In-DB Tools

[mcarrico]

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.

[Ned · Accepted solution]

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

[mcarrico]

Oh wow, perfect. Thank you.

[timrains]

Wow! This is great! Thanks!

[holmesmeyer00]

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

[ka2yee]

@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...