Bigquery如何在列表操作期间过滤数据集中的表 [英] Bigquery how to filter tables in dataset during List operation

问题描述

在调用List操作时，是否可以使用表名从数据集中搜索或过滤特定表?我了解文档中提到使用Label来过滤表格，但是在我的情况下这是不够的，因为在具有或不带有Label的数据集下可以创建的表格数量没有限制.我正在使用Node库进行操作.

Is there any way to search or filter for particular Table from Dataset using Table name while calling List operation? I understand that documentation mentions use of Labels to filter Tables but in my case this will not suffice as there is no restriction on number of Tables that can be created under a Dataset with or without Label . I am using Node library for my operations.

推荐答案

搜索或过滤特定表(或任何其他元数据对象)的首选方法是查询 INFORMATION_SCHEMA .可以使用多个 INFORMATION_SCHEMA 表- INFORMATION_SCHEMA.TABLES ， INFORMATION_SCHEMA.TABLE_OPTIONS ， INFORMATION_SCHEMA.COLUMNS 等.有关更多信息，请参见 https://cloud.google.com/bigquery/docs/information-schema-tables

The prefered way to search or filter for particular Table (or any other metadata object) is to query INFORMATION_SCHEMA. There are multiple INFORMATION_SCHEMA tables which could be used - INFORMATION_SCHEMA.TABLES, INFORMATION_SCHEMA.TABLE_OPTIONS, INFORMATION_SCHEMA.COLUMNS etc. More info at https://cloud.google.com/bigquery/docs/information-schema-tables

这篇关于Bigquery如何在列表操作期间过滤数据集中的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！