是否有可能在google bigquery中检索扩展或完整的查询历史记录？ [英] Is it possible to retrieve an extended or full query history in google bigquery?

问题描述

由于BigQuery中的表删除操作是永久性的，因此，我们最近发现我从BigQuery中意外删除了一个表，这是通过查询其他表（我仍然有这些表） （对吧？），我想重建丢失的表，最好不重写查询。

webUI中的查询历史记录显然只显示有限数量的查询。我所寻找的是不幸的不在列表中。

所以我的问题是，是否有可能以某种方式恢复查询历史中消失的查询？

（我知道查询的创建日期）

解决方案

使用 JobID ，您可以查询特定作​​业（记录在这里）。这会为您提供作业资源，其中将包含您的查询。

如果您不知道JobID ...取决于我假设的查询运行方式。它可能由App Engine（如果您通过代码运行它）记录在开发者控制台的日志部分。您还可以查看工作列表（贷记给为那一个OP），并在那里寻找你最近的工作。从列表中您也可以获得乔布斯资源，因此它们将包含您需要的全部内容。

I recently discovered I accidentally deleted a table from BigQuery, which was constructed by querying other tables (which I still have).

As table deletes in BigQuery are permanent (right?), I would like to reconstruct the lost table, preferably without rewriting the query.

The Query History in the webUI obviously only displays a limited number of queries. The one I am looking for is unfortunately not in that list.

So my question is, is it possible to somehow recover the queries which have disappeared from the query history?

(I do know the creation date of the query I am looking for)

解决方案

Using the JobID, you can query for a specific job (documented here). This will give you a Jobs resource, which will contain your query.

If you don't know the JobID... it depends on how the query was ran I assume. It's possibly logged by the App Engine (if you ran it via code) in the Logs section of the Developer console. You could also take a look at the Jobs List (credit to the OP for that one) and look in there for your recent jobs. From the list you get Jobs Resources as well, so they will contain all you need.

这篇关于是否有可能在google bigquery中检索扩展或完整的查询历史记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！