在BigQuery中查找创建表的查询 [英] Finding the query that created a table in BigQuery

问题描述

我是公司的新员工.我之前的人已经在BigQuery中建立了一些表格.我想调查该特定表的创建表查询.

I am a new employee at the company. The person before me had built some tables in BigQuery. I want to investigate the create table query for that particular table.

我想使用查询检查的是:

Things I would want to check using the query is:

1. 使用了哪些联接?
2. 用于制作相关表格的其他表格有哪些?

我以前从未使用过BigQuery，但是我通过阅读教程和文档进行了尽职调查.我在那里找不到任何相关内容.

I have not worked with BigQuery before but I did my due diligence by reading tutorials and the documentation. I could not find anything related there.

推荐答案

下面简要介绍您的操作:

Brief outline of your actions below:

第1步-使用收集该用户的所有查询作业Jobs.list API -您必须具有相应项目的所有者"权限才​​能获得其他人的工作

Step 1 - gather all query jobs of that user using Jobs.list API - you must have Is Owner permission for respective projects to get someone else's jobs

第2步-仅提取

Step 2 - extract only those jobs run by the user you mentioned and referencing your table of interest - using destination table attribute

第3步-对于那些提取的作业-只需简单地检查相应的 查询 ，可让您了解该表格的填充方式

Step 3 - for those extracted jobs - just simply check respective queries which allow you to learn how that table was populated

Hth！

这篇关于在BigQuery中查找创建表的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！