When can user session variables be accessed in a Snowflake scripting procedure?
When can user session variables be accessed in a Snowflake scripting procedure?
User session variables can be accessed in a Snowflake scripting procedure when the procedure is defined to execute as CALLER. This is because caller rights ensure that the procedure runs with the privileges of the user who calls it, allowing access to session variables specific to that user.
https://community.snowflake.com/s/article/Using-session-variables-in-a-stored-procedure
Using session variables in a stored procedure Session variables can only be used in a Javascript Stored Procedure when it's created with Caller rights.
correct