Data restoration in BigQuery allows users to recover deleted records within a specific time frame using the time travel feature.
BigQuery provides a time travel option for accessing past versions of data within a retention period of up to 7 days, aiding in recovering accidentally deleted records.
Users can query previous versions of data using SYSTEM_TIME AS OF or table decorators, but restoring an entire deleted table requires a special recovery command.
Limitations of data restoration in BigQuery include time-dependent recovery within 7 days, no support for external tables, and the need for a recovery command if the entire table is deleted.