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
Copy

Ref: 1244