CData Python Connector for Google Data Catalog

Build 21.0.8137


To view the list of tables and views

Table Specific Information


The provider 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 provider.

  • 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:




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.

The allowed values are 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.

The allowed values are bigquery, cloud_pubsub, data_catalog.

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


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137