Syntax to call a snowflake stored procedure from Alteryx

[Sim]

Hi,
Alteryx forums and online documentation say we can call snowflake stored procedures from the Input tool pre-sql editor even
though not directly possible from the stored_procedure tab.

Has anybody tried and had luck. Please share the syntax.
I tried in multiple ways changing the syntax , but it keeps failing with syntax errors.

Thanks!

[HenrietteH · Accepted solution]

The syntax should be (see help😞

CALL MyStoredProcedure1(argument_1);   

Does the stored procedure run through the Snowflake console? 
What are the syntax errors being returned? 

[ThomasT]

Hi @HenrietteH 

we are currently trialling the same and are facing the same issue. 

I can call the stored procs in the Snowflake UI using the same credentials/warehouse/role, but when I try via Alteryx I get a syntax error. Any ideas how to work around those. Ideally we would like to avoid python as it might expose our database connection credentials.

Using Snowflake DSII ODBC Driver

Error: Input Data (15): Executing PreSQL: "CALL DP_***_MTD.MTD.DP_***_UPDATE();" : [Snowflake][ODBC] (10690) Expected descriptor record does not exist during query execution.

Using Snowflake Simba ODBC Driver

Error: Input Data (15): Executing PreSQL: "CALL DP_***_MTD.MTD.DP_***_UPDATE();" : [Simba][ODBC] (10690) Expected descriptor record does not exist during query execution.