SSIS Components for Google Data Catalog

Build 21.0.7930

TableProperties

To view the properties of the table

Table Specific Information

Select

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

  • 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