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?
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.