Hacktoberfest 2026: los issues que los mantenedores marcaron para octubre, abiertos y aptos para principiantes. Explorar issues de Hacktoberfest

Add Python sample for restoring multiple deleted BigQuery tables concurrently

Abierto
  • ¿Algo no está bien?
#14,641 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 3 días

@alihanoz-google ya está trabajando en esto.

Desde el 13/10/2026.

  • #14642 de @alihanoz-google — abierto

Evaluación

Dificultad
3/5
Tiempo estimado
Medio día
Aptitud para principiantes
15/100
Tipo de issue
Nueva funcionalidad
Claridad
Bien especificado
Estado de actividad
Estancado
Stack tecnológico
gcp, python
Área
databases

Línea de trabajo

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.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

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!

Lenguaje dominante
Jupyter Notebook
Estrellas
8.1k
Forks
6.7k
Merge medio
3 d 11 h
PR fusionados (30 d)
12

Preparar el entorno

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de GoogleCloudPlatform/python-docs-samples

Todos los issues de GoogleCloudPlatform/python-docs-samples

Issues similares

Más issues de Databases

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.