This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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...