JDBC Driver for Google Data Catalog

Build 22.0.8462

Tables

To view the list of tables and views

Table Specific Information

Select

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

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

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-Columns

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