Terminating sessions
This document describes how session termination works in BigQuery. It is intended for users who already have a general understanding of BigQuery sessions.
Before you complete these steps, ensure you have the necessary permissions to terminate a session.
Terminating a session
A session can be terminated manually or automatically. The history of a terminated session is available for 20 days after termination.
Auto-terminate a session
A session is terminated automatically after 24 hours of inactivity or after 7 days, whichever happens first.
Terminate the current session
You can terminate your current session with a SQL statement or in the Google Cloud console, if the session was created there.
Console
In the Google Cloud console, go to the BigQuery page.
Find the editor tab that contains your session and close it. The session is terminated.
SQL
Do the following to terminate your session:
In the Google Cloud console, go to the BigQuery page.
In the query editor, enter the following statement:
CALL BQ.ABORT_SESSION();
Click
Run.
For more information about how to run queries, see Run an interactive query.
Terminate a session by ID
You can terminate a session using its ID. You do not need to be in the session to terminate it this way.
Get the session ID, and then run the following statement:
CALL BQ.ABORT_SESSION(SESSION_ID);
Replace SESSION_ID with the ID of the session to terminate.