To view the list of tables and views

Table Specific Information

Select

The 本製品 will use the Google Data Catalog API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

• DataSetName supports the 'CONTAINS' comparison.
• Type supports the '=' comparison.
• ProjectId supports the '=' comparison.
• EntryGroup supports the '=' comparison.
• CreatedTime supports the '=, <, <=, >, >=' comparisons.
• UpdatedTime supports the '=, <, <=, >, >=' comparisons.
• OrganizationId supports the '=' comparison.
• TagName supports the 'CONTAINS' comparison.
• DisplayName supports the 'CONTAINS' comparison.
• SearchColumn supports the 'CONTAINS' comparison.
• Description supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Tables WHERE UpdatedTime <= '2018-06-01 11:00:00.0'

SELECT * FROM Tables WHERE UpdatedTime >= '2018-06-01'

SELECT * FROM Tables WHERE UpdatedTime > '2018-06-01 12:00:00' AND CreatedTime < '2019-06-01 11:00:00'

SELECT * FROM Tables WHERE OrganizationId = '112025358'

SELECT * FROM Tables WHERE ProjectId = 'bigquery-public-data'

SELECT * FROM Tables WHERE CONTAINS (SearchColumn, 'name')

SELECT * FROM Tables WHERE TagName = 'test'

SELECT * FROM Tables WHERE Type = 'table' OR Type = 'view'

Additionally LastAccessedTime and UpdatedTime columns can be used in the ORDER BY clause, as following:

SELECT * FROM Tables ORDER BY LastAccessed DESC

SELECT * FROM Tables ORDER BY UpdatedTime ASC

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。