JDBC Driver for Google Data Catalog

Build 22.0.8462

TableProperties

To view the properties of the table

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 ResourceName is required to make a request and the rest of the filter is executed client side within the driver.

  • ResourceName supports the '=' comparison.

SELECT * FROM TableProperties WHERE ResourceName = 'projects/bigquery-public-data/locations/US/entryGroups/@bigquery/entries/cHJvamVjdHMvYmlncXVlcnktcHVibGljLWRhdGEvZGF0YXNldHMvZ2VvX2NlbnN1c19ibG9ja2dyb3Vwcy90YWJsZXMvYmxvY2tncm91cHNfMTE'

Columns

Name Type Description
ResourceName [KEY] String Resource name of the table.
DataSetName String The dataset name.
TableName String Table Name in the dataset.
TableSourceType String Table datasource.
TableCreatedTime Datetime Table created time.
TableUpdatedTime Datetime Table updated time.
TableExpiryTime Datetime Table expiry time.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462