Add Python sample for restoring multiple deleted BigQuery tables concurrently
維護者通常 3 天內回覆
評估
研究方向
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.
由索引模型根據 Issue 內容生成。
描述
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!
- 主要語言
- Jupyter Notebook
- 星號
- 8.1k
- 分支
- 6.7k
- 平均合併
- 3 天 11 小時
- 30 天內合併 PR
- 12
環境準備
- 沒有 Dockerfile 或 Docker Compose 檔案
- 有 Pull Request 範本
- 閱讀貢獻指南
從這裡開始
- 先讀完整個 Issue，再讀專案的貢獻指南。
- 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
- Fork 儲存庫，在一個分支上完成修改。
- 送出 Pull Request，並在描述裡引用這個 Issue 編號。
GoogleCloudPlatform/python-docs-samples 的其他 Issue
-
run/logging-manual: clarify Artifact Registry setup for deployment可能已有人在做 @jungwonenjoyericl 於 4 天前認領。 未關閉api: run samples
難度 2/5 1-3 小時 新手友好度 62/100
GoogleCloudPlatform/python-docs-samples#14633 ·
維護者通常 3 天內回覆
-
Developer Knowledge fallback search response is not iterable可能已有人在做 @aniruddhaadak80 於 22 天前認領。 未關閉samples
難度 2/5 1-3 小時 新手友好度 88/100
GoogleCloudPlatform/python-docs-samples#14609 ·
維護者通常 3 天內回覆
-
RAG quickstart entry point passes an unsupported paths argument可能已有人在做 @aniruddhaadak80 於 22 天前認領。 未關閉samples
難度 1/5 1 小時以內 新手友好度 92/100
GoogleCloudPlatform/python-docs-samples#14610 ·
維護者通常 3 天內回覆
-
Static external IP sample entry point passes invalid keyword arguments可能已有人在做 @aniruddhaadak80 於 22 天前認領。 未關閉samples
難度 2/5 1-3 小時 新手友好度 88/100
GoogleCloudPlatform/python-docs-samples#14611 ·
維護者通常 3 天內回覆
-
chore(generative_ai) Update model references for generative_ai samples可能已有人在做 @XrossFox 於 172 天前認領。 未關閉samples
GoogleCloudPlatform/python-docs-samples#14117 · 已指派 1 人 ·
維護者通常 3 天內回覆
查看 GoogleCloudPlatform/python-docs-samples 的全部 Issue
相似的 Issue
-
clawsweeper:fix-shape-clear clawsweeper:queueable-fix clawsweeper:source-repro impact:session-state issue-rating: 🦞 diamond lobster no-stale P2
難度 2/5 1-3 小時 新手友好度 74/100
openclaw/wacli#503 · 1 則留言 · 1 個 reaction ·
維護者通常 1 天內回覆
-
area:casework criticality:p3
難度 1/5 1 小時以內 新手友好度 94/100
registrystack/registry-stack#2084 ·
維護者通常 1 天內回覆
-
area/indexing bug package/core triage
難度 2/5 1-3 小時 新手友好度 75/100
維護者通常 1 天內回覆
-
Add: AVA Media未關閉channels:add check:failed
難度 2/5 1-3 小時 新手友好度 63/100
-
難度 2/5 1-3 小時 新手友好度 72/100
維護者通常 1 天內回覆