Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Syntax to call a snowflake stored procedure from Alteryx

Sim
5 - Atom

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!

2 REPLIES 2
HenrietteH
Alteryx Alumni (Retired)

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? 

Henriette Haigh
Technical Product Manager - Data Connectors
Alteryx, Inc.

ThomasT
8 - Asteroid

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.