SQL commands supported within Stored Procedures

Question

I'm trying to execute a series of SQL statements from within a Stored Procedure in SnowFlake (v3.49.2) and it's throwing errors when executing certain commands, e.g.,

"Unsupported statement type 'SET'."

Would there be a list of SQL commands which are supported/unsupported when executed within Stored Procedures?

I think this is specific to SnowFlake. You can check the docs. Ideally, you would post the code along with the question, so we can get a better idea about the context. Most of the times this helps, even if you think it might be redundant. — Radu Gheorghiu

brennash brennash · Accepted Answer · 2019-11-05T09:39:21

Found a list of what's supported here - https://docs.snowflake.net/manuals/sql-reference/stored-procedures-usage.html

In short - any commands which can could affect other user's sessions are prohibited.

SQL commands supported within Stored Procedures

1 Answers