In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Alteryx

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.