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!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

remove character limit from pre/post SQL statements in input tool

I 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?

 

 

6 Comments
ryan_richardson
7 - Meteor

Completely agree- I don't appear to have any restrictions on the length of a SQL statement in the main query but a pretty restrictive limit on the pre-SQL. Please remove this or substantially increase it-

 

Thank you!

timfrost79
5 - Atom
what is the limit set at now?
ryan_richardson
7 - Meteor

I'm honestly not certain but I had a pretty sizable pre-SQL statement that works in a Tableau report, but which was too large for Alteryx. Since it works in Tableau, makes me think it's feasible to have it work in Alteryx as well--

 

Thank you

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Coming Soon

Thank you for your idea!

 

We're currently working to include this idea in an upcoming release and will update this idea again once it's available!

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Implemented

Thank you for your idea! This feature has been implemented in the latest release, 2020.1, which you can download here! Also check out the release notes for this version here!

ryan_richardson
7 - Meteor

That's wonderful news!! Thank you