Calling Snowflake stored procedures from Redash

Hi, does Redash support calling Snowflake SP’s? I created a dummy SP which returns Pi constant. It works well on Snowflake. But Redash gives the following error. Any ideas?

Error running query: **002140 (42601): SQL compilation error: Unknown function SP_PI**

Redash isn’t designed to run anything apart from SELECT queries. But nevertheless this should work. Have you tried it from a different query tool other than Snowflake? It sounds like a context issue that isn’t specific to Redash.

Hi! Took a little while until I figure it out but I’ve found out the reason. It wasn’t working because I wasn’t specifying the schema name of the SP while calling.

It was supposed to be like this

call <schema_name>.sp_pi();
1 Like