Procedures (caller’s rights): SQL statements that include PUT and GET commands produce a compiler error¶
Attention
This behavior change is in the 2023_06 bundle.
For the current status of the bundle, refer to Bundle History.
In the current Snowflake release, caller’s rights procedures written in JavaScript or Snowflake Scripting will throw a compiler error if their handler code attempts to execute a PUT or GET statement.
- Previously
In the JavaScript or Snowflake Scripting handler code of a caller’s rights procedure, attempting to use PUT or GET in a SQL statement neither succeeds nor throws an error. In other words, the PUT or GET has no effect even though the procedure continues and appears to succeed.
- Currently
In the JavaScript or Snowflake Scripting handler code of a caller’s rights procedure, attempting to use PUT or GET in a SQL statement will throw a compiler error such as the following:
Unsupported statement type PUT_FILES
Ref: 1244