Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-05 UTC."],[[["Sessions in BigQuery can be terminated either manually or automatically, with a history available for 20 days post-termination."],["Automatic termination occurs after 24 hours of inactivity or 7 days, whichever comes first."],["The current session can be terminated by closing the relevant editor tab in the Google Cloud console, or by using the `CALL BQ.ABORT_SESSION();` SQL statement."],["Any session can be terminated by its unique ID using the SQL statement `CALL BQ.ABORT_SESSION(SESSION_ID);`, even without being in the session."]]],[]]
