Dynamic SQL Question

[nickfonze]

Is there a way to create a workflow that runs SQL that references data produced upstream in the same workflow?

For example, I'm currently manually running a SQL query in one database, this output is placed into a SQL temp table in another database, which is then queried alongside additional code/criteria. 

[BrandonB]

The Dynamic Input tool: https://help.alteryx.com/current/designer/dynamic-input-tool and the Dynamic Input In-DB https://help.alteryx.com/current/designer/dynamic-input-db-tool are going to be perfect for these purposes

[nickfonze]

Looks like the Dynamic Input In-DB should work in this situation, do you happen to know of an example workflow where data is placed into a temp table using In-DB tools, followed by that data being referenced and queried against using a separate database connection? Thank you!