Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Extract SQL from Dynamic Input

caboose8402
5 - Atom

Is there a way to get the SQL that was actually run through a Dynamic Input tool (not In-DB) out of that tool for review? I need to check it against the original data store for accuracy.

3 REPLIES 3
CharlieS
17 - Castor
17 - Castor

The Results window will display the query that was actually executed by the Dynamic Input tool. After the workflow is finished, you should be able to click on the Dynamic Input tool and the results window (Ctrl+Alt+R) should filter to only messages related to that tool. 

caboose8402
5 - Atom

That works great and allows me to see and copy/paste the code for review. For reporting purposes, is there a way to extract that?

CharlieS
17 - Castor
17 - Castor

Happy to help!

 

In Options > Advanced Options > System Settings > Engine there's a field for a logging directory. Point that to a folder to enable logging and see if that saves what you're looking for. Otherwise, on the Workflow Configuration window, You can configure an event to send an email with the complete "%OutputLog%" when the workflow is finished reporting if you prefer that.

Labels