Excel Add-In for Google Data Catalog

Build 21.0.7930

TableColumns

To view the columns in the table or view

Table Specific Information

Select

The add-in 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 add-in.

  • ResourceName supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TableColumns 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.
ColumnName String Columns in the table.
Description String Description of the columns.
Mode String Column mode.
DataType String Column Datatype.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930