Hacktoberfest 2026: as issues que os mantenedores marcaram para outubro, abertas e boas para iniciantes. Ver issues do Hacktoberfest

Add Python sample for restoring multiple deleted BigQuery tables concurrently

Aberta
  • Algo errado?
#14,641 0 comentários 0 reações 0 responsáveis Ver no GitHub

Mantenedores costumam responder em até 3 dias

@alihanoz-google já está trabalhando nisso.

Desde 13/10/2026.

  • #14642 de @alihanoz-google — aberto

Avaliação

Dificuldade
3/5
Tempo estimado
Meio dia
Facilidade para iniciantes
15/100
Tipo de issue
Funcionalidade
Clareza
Claramente especificada
Status de atividade
Estagnada
Stack de tecnologia
gcp, python
Domínio
databases

Direção de pesquisa

The work is a Python sample that queries INFORMATION_SCHEMA.TABLE_STORAGE for recently deleted tables, computes time-travel timestamps, and restores them concurrently with a ThreadPoolExecutor. Pull request #14642 is already open against this issue, so review or coordinate on that PR rather than starting a parallel implementation. Done means the sample runs against a test dataset and restores the tables to the destination dataset.

Escrita pelo modelo de indexação a partir do texto da issue.

Descrição

priority: p3 samples triage me type: feature request

Is your feature request related to a problem? Please describe.

Yes. Customers often need to restore multiple deleted BigQuery tables at once (e.g., after an accidental bulk deletion or dropping a dataset). Currently, the public documentation only provides examples for restoring a single table at a time, leaving users to figure out how to write their own concurrent restoration logic using time travel decorators and the INFORMATION_SCHEMA.

Describe the solution you'd like.

Add a Python sample script demonstrating how to programmatically query INFORMATION_SCHEMA.TABLE_STORAGE to find all recently deleted tables in a dataset, calculate their time travel timestamps, and restore them concurrently to a new destination dataset using the BigQuery Python client and a ThreadPoolExecutor.

This sample will be surfaced in the public BigQuery documentation via an include tag to help customers perform bulk restorations.

Describe alternatives you've considered.

The alternative is requiring users to manually restore tables one-by-one via the bq CLI or write their own custom bulk-restore scripts from scratch, which is error-prone and tedious for large datasets.

Additional context.

This sample was explicitly requested by the BigQuery tech writing team to be surfaced in the public documentation for recovering deleted tables (Internal tracking: cl/998554059, b/533404964).

I already have the code prepared and will open a Pull Request linking to this issue shortly!

Linguagem predominante
Jupyter Notebook
Estrelas
8.1k
Forks
6.7k
Merge médio
3d 11h
PRs com merge (30d)
12

Preparar o ambiente

Primeiros passos

  1. Leia a issue inteira e depois o guia de contribuição do projeto.
  2. Comente na issue dizendo que vai assumir — evita que duas pessoas façam o mesmo trabalho.
  3. Faça um fork do repositório e trabalhe em uma branch.
  4. Abra um pull request que referencie o número da issue.

Mais de GoogleCloudPlatform/python-docs-samples

Todas as issues de GoogleCloudPlatform/python-docs-samples

Issues semelhantes

Mais issues de Databases

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.