Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesI use redshift which does not support stored procedures.
I want to use Alteryx scheduled workflows as stored procedures, in that I run a set of queries using the Pre SQL statement of an input tool, and do simple counts in the actual Input tool query for error handling and notification (linked to Slack api using download tool)
There is a Pre SQL statement character limit in the GUI, preventing me from running the whole set of queries.
I got around this by putting the set of Sql queries in a formula tool and then feeding that into a macro that uses a control parameter and action tool to update the presql of an input tool.
Please remove the character limit in the input tool configuration GUI. Not sure why there is one?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.