This is a bit old, but I encountered this problem of calling a stored procedure in Snowflake within Alteryx today and was able to call a stored procedure in Snowflake via Alteryx through a bit of dumb luck, and fairly easily.
I just dropped an input tool that was connected to Snowflake, I defined the warehouse, database and schema in the Pre-SQL statement box in the configuration: (use warehouse XYZ; use database XYZ; use schema XYZ;)
And then in the actual query, I called my stored procedure (call stored_procedure), but the key that made this work is to put a commented out piece of SQL code, with a 'select' and 'from' statement, prior to the calling of the stored procedure.
For instance, I have:
--select a from b
call stored_procedure
as my query and this runs the stored procedure with no issue. I explored this a bit, and it's like Alteryx won't run the stored procedure simply by calling it in the query window, but if you comment out a line of SQL code, it tricks it into running it anyway. I discovered that the commented out line MUST contain a "select" and "from", otherwise it will error out running the stored procedure, hence the "select a from b" in my code above.
Hopefully this works for you, as well!
