SSIS Components for Google Data Catalog

Build 21.0.7930

Tables

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

Name Type Description
DataSetName String Dataset name in the project.
TableName String Tables in the dataset.
Type String Table type of either table or view.

使用できる値は次のとおりです。table, view

ProjectId String The project which the table created in.
Region String The cloud location of the table.
EntryGroup String The source dataset type.

使用できる値は次のとおりです。bigquery, cloud_pubsub, data_catalog

ResourceName String Resource name of the table.
OrganizationId String The Organization which the dataset created in.

Pseudo-Columns

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

Name Type Description
TagName String Filter by tagname in the tables.
CreatedTime Datetime Filter by table created time.
UpdatedTime Datetime Filter by table updated time.
DisplayName String Display name of the table.
SearchColumn String Search columns in the list of tables by column name.
Description String Description of the table.
LastAccessed String Sort the response by last accessed datetime.

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