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();