CData Python Connector for Google Data Catalog

Build 21.0.7930

TableProperties

To view the properties of the table

Table Specific Information

Select

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

  • 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930