Delete table snapshots
This document describes how to delete a table snapshot by using the
Google Cloud console, a
DROP SNAPSHOT TABLE
Standard SQL statement, a
bq rm command,
or a BigQuery API
It also provides information about how to recover a table snapshot that was
deleted or that expired in the past seven days.
It is intended for users who are familiar with
Permissions and roles
To delete a table snapshot, you need the following permission:
||The table snapshot that you want to delete|
The predefined BigQuery roles that provide the required permissions are as follows:
Any of the following:
||The table snapshot that you want to delete.|
Delete a table snapshot
Delete a table snapshot as you would delete a standard table. You don't need to delete a table snapshot that has expired.
For example, delete the
library_backup.books table snapshot as follows:
In the Cloud console, go to the BigQuery page.
In the Explorer pane, expand the project and dataset nodes of the
Click the table snapshot that you want to delete, in this case,
In the table snapshot pane that appears, click Delete.
Confirm, and then click Delete again.
Run the following query:
DROP SNAPSHOT TABLE library_backup.books
Enter the following command in the Cloud Shell:
bq rm library_backup.books
method with the following parameters:
Restore a deleted or expired table snapshot
You can recover a table snapshot that was deleted or that expired in the past seven days in the same way that you recover a standard table. For more information, see Restoring deleted tables.