dotConnect for Google BigQuery Documentation
The SYS_TABLES table lists available tables and views and their parameters. It has the following columns:
Column Name |
Data Type |
Description |
|---|---|---|
| TABLE_CATALOG | VARCHAR(128) | The Google Cloud project that contains the table. |
| TABLE_SCHEMA | VARCHAR(128) | The dataset that contains the table. |
| TABLE_NAME | VARCHAR(128) | The name of the table or view. |
| TABLE_TYPE | VARCHAR(10) | The type of an object. Always "TABLE", for views too; a view has ALLOWED_OPERATIONS equal to 0. |
| CUSTOM | BIT | Not used in dotConnect for Google BigQuery. Always 0. |
| CAN_QUERY | BIT | Indicates whether the SELECT query to this object can be executed. Always 1. |
| ALLOWED_OPERATIONS | INT | Contains a flag value that indicates which DML operations are allowed on this object and is the sum of the following flags:
7 for tables, 0 for views. |
| API_NAME | VARCHAR(128) | The table name qualified with the dataset name, as it is used in SQL statements. |