Recover BigQuery dataset and content

Problem

A BigQuery user has deleted a dataset and all tables within it.

Environment

  • BigQuery

Solution

Tables from a deleted dataset within time travel window can be recovered either by undeleting the entire dataset or manually by creating a dataset with the same name and in the same location as the original and restoring the deleted tables.

Note: Undelete Dataset feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms at the time of writing this. Pre-GA features are available "as is" and might have limited support.
Note: Undelete Dataset has some limitations.