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