Syntax to call a snowflake stored procedure from Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
- Mark as New
- Subscribe to RSS Feed
- Permalink
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!
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Subscribe to RSS Feed
- Permalink
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?
Technical Product Manager - Data Connectors
Alteryx, Inc.
- Mark as New
- Subscribe to RSS Feed
- Permalink
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.
