What is to be expected when sharing worksheets in Snowsight?
What is to be expected when sharing worksheets in Snowsight?
To run a shared worksheet in Snowsight, a user must be granted the role used for the worksheet session context. This prerequisite ensures that the user has the necessary permissions to execute the queries and view the data associated with that specific role. Without the appropriate role, the user cannot fully interact with the shared worksheet as intended.
Worksheets in Snowsight use unique sessions with specific roles and warehouses assigned in the context of the worksheet. To view shared query results, the Snowflake user must use the same role as the session context for the worksheet. https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs.html#sharing-worksheets-and-folders
https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets-gs.html#sharing-worksheets-and-folders
B. To run a shared worksheet, a user must be granted the role used for the worksheet session context.
B. To run a shared worksheet, a user must be granted the role used for the worksheet session context. No, this is not necessarily correct. Permissions Granted: Edit Recipient Can: Edit the worksheet contents. Run the worksheet, including run the worksheet as a different role. View the results for past versions of the worksheet, if they have the role used to generate the results. C. Snowsight allows users to view and refresh results but not to edit shared worksheets. Yes, that's correct. Permissions Granted: View + Run Recipient Can: • If they have the worksheet role: • Run the worksheet. • View the results of the most recent worksheet version. • View the worksheet contents. Duplicate and run the worksheet using their own role. Source: https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets
What about D: The worksheet role is the primary role last used to run the worksheet and is required to run the worksheet. The worksheet role can change if the worksheet owner or editor runs the worksheet using a different role. https://docs.snowflake.com/en/user-guide/ui-snowsight-worksheets#sharing-worksheets-and-folders
correct
Answer: B