BigQuery-通过UI恢复已删除的表 [英] BigQuery - Restored Deleted Table via UI

问题描述

通过CLI在此发布了一些帖子，但不确定通过UI以及新的alpha用户界面即将发布的当前状态.

There are a few posts on this via the CLI, but not sure on the current state via the UI and with the new alpha UI coming.

是否有办法在2天的删除宽限期限制内，仅使用BQ UI和standardSQL来将查询并保存为恢复"，而不是GCP CLI还原为已删除的表?即

Is there a way, within the 2 day delete grace period limit, to restore a deleted table using ONLY the BQ UI and standardSQL to query-and-save to essentially 'restore', not the GCP CLI? ie

select *
from deleted-table@timstamp

，然后将结果保存在UI中为原始表名?

and then save the result in the UI to the original table name?

考虑到我们大多数人都在BQ UI中花费时间进行其他BQ工作，这使我觉得这是一种更简单的方法吗?

This strikes me as a much simpler way to do this given most of us spend our time in the BQ UI doing other BQ work anyway?

有想法吗?

谢谢

推荐答案

使用标准SQL，您可以运行 SELECT * FROM Deleted-table FOR SYSTEM TIME OF OF ......

With standard SQL you can run SELECT * FROM deleted-table FOR SYSTEM TIME AS OF ...

的作用类似于旧版SQL中的@timestamp. 此处的更多详细信息 https: //cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#for-system-time-as-of

which works like the @timestamp in legacy SQL. More details here https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#for-system-time-as-of

您可以在用户界面的查询选项中设置目标表.

You can set destination table in the query options in UI.

这篇关于BigQuery-通过UI恢复已删除的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！