SSIS Components for Google Data Catalog

Build 21.0.7930


To view the properties of the table

Table Specific Information


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'


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