What happens when a user exits Snowsight during a session that a query is running?
What happens when a user exits Snowsight during a session that a query is running?
When a user exits Snowsight during a session where a query is running, Snowflake will cancel any queries submitted during that session that are still running.
B Correct: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour
Correct, above is a direct quote.
This article says: https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. However, like another user isolated_sniper said, it continued executing. I submitted a query, ended the session, came back, logged out, logged back in, the query continued executing. So D is correct. B is not correct based on testing. Documentation is not correct /up-to-date.
None. Snowflake will continue to execute on the virtual warehouse assigned to the session even after user has logged out.
Should be D
When a user exits Snowsight during a session while a query is running, the query continues to execute in Snowflake independently of the Snowsight interface. Snowflake runs queries on its servers, and Snowsight is simply an interface for interacting with Snowflake's services. Exiting Snowsight does not affect the execution of the query itself. Once a query is submitted to Snowflake, it continues to run until completion, cancellation, or until it reaches a timeout limit, regardless of whether the user remains connected to the Snowsight interface. The user can check the status or results of the query later by reconnecting to Snowsight or by accessing the Snowflake web interface or other client tools. Snowflake also provides options to monitor and manage long-running queries through its web interface or using SQL commands.
its B i checked it here view and scroll to the end https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour
YES I also checked it although the snowflake documentation said the opposite
I executed a query with snowsight verified th session ID then logged out, when I loged in the previous query continued to execute. I ran another query on the same worsheet, the session ID have changed for the new query but the first query continued to run with the previous session ID
Should be B https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour#user-menu
no I tested several times, it continues to run it
B Important: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour
This is confusing. https://docs.snowflake.com/en/user-guide/session-policies --> Caution Active queries are not canceled when the session ends and the user is logged out, even if the ABORT_DETACHED_QUERY parameter is set to true. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour --> Important: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running.
I got this like, 1. If the User exits the session willingly, then it falls in the second link. i.e., Exiting Snowsight. 2. If the session ends due to inactivity even if ABORT_DETACHED_QUERY is set to true, it will run. Which is the first link
B correct
When a user exits Snowsight during a session where a query is running, Snowflake continues to execute the query in the same session. The query will not be canceled or paused due to the user exiting the interface.
From a costing point of view it has to cancel otherwise who is paying for the query especially if its no longer required