Schemas
To view the list of schemas
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.
- DisplayName supports the 'CONTAINS' comparison.
- Description supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Schemas WHERE CONTAINS (DataSetName, 'prop') SELECT * FROM Schemas WHERE UpdatedTime >= '2018-01-01 01:00:00' SELECT * FROM Schemas WHERE CreatedTime < '2018-06-01' SELECT * FROM Schemas WHERE UpdatedTime > '2018-06-01 12:00:00' AND CreatedTime <= '2019-06-01 11:00' SELECT * FROM Schemas WHERE OrganizationId = '112025358' SELECT * FROM Schemas WHERE ProjectId = 'bigquery-public-data OR ProjectId = 'level-works-253411''
Additionally LastAccessedTime and UpdatedTime columns can be used in the ORDER BY clause, as following:
SELECT * FROM Schemas ORDER BY LastAccessed ASC SELECT * FROM Schemas ORDER BY UpdatedTime DESC
Columns
Name | Type | Description |
DatasetName | String | Dataset Name in the project. |
Type | String | Type of dataset.
使用できる値は次のとおりです。dataset, data_stream |
ProjectId | String | The project which the dataset created in. |
Region | String | Cloud location of the dataset. |
EntryGroup | String | Entry group of data asset.
使用できる値は次のとおりです。bigquery, cloud_pubsub, data_catalog |
OrganizationId | String | The Organization which the dataset created in. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CreatedTime | Datetime | Filter by Dataset created time. |
UpdatedTime | Datetime | Filter by Dataset updated time. |
DisplayName | String | Display name of dataset. |
Description | String | Description of the dataset. |
LastAccessed | String | To sort the response by last accessed datetime. |