SQL commands supported within Stored Procedures

546 Views Asked by At

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?

1

There are 1 best solutions below

0
brennash On

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.