User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
User2 will be unable to view the result set of the query executed by User1. In Snowflake, each user can only view the results for the queries they have executed. Even if User2 has privileges to view the query history, for data privacy reasons, they will not be able to see the actual result set of the query executed by User1.
D correct - You can view results only for queries you have executed. If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result. https://docs.snowflake.com/en/user-guide/ui-history