Cmdlets for Google Data Catalog

Build 21.0.7930

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930