INFORMATION_SCHEMA."TABLES"
The INFORMATION_SCHEMA."TABLES" view contains metadata for the tables and views in a project.
note
-
The name of the view must be encapsulated in quotes ("TABLES") so that it is parsed as the view name instead of the reserved keyword tables.
-
You may not see some rows in the table if you do not have access to the metadata storage container.
SELECT *
FROM INFORMATION_SCHEMA."TABLES"
Example Output
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE |
|---|---|---|---|
| DREMIO | INFORMATION_SCHEMA | CATALOGS | SYSTEM_TABLE |
| DREMIO | INFORMATION_SCHEMA | COLUMNS | SYSTEM_TABLE |
| DREMIO | INFORMATION_SCHEMA | SCHEMATA | SYSTEM_TABLE |
| DREMIO | INFORMATION_SCHEMA | TABLES | SYSTEM_TABLE |
| DREMIO | INFORMATION_SCHEMA | VIEWS | SYSTEM_TABLE |
| DREMIO | sys | boot | SYSTEM_TABLE |
| DREMIO | Weather | SFWeatherElevation | VIEW |
| DREMIO | Samples.samples.dremio.com | SF weather 2018-2019.csv | TABLE |
| DREMIO | Samples.samples.dremio.com | SF_incidents2016.json | TABLE |
| DREMIO | sys.cache | datasets | SYSTEM_TABLE |
Fields
| Field | Data Type | Description |
|---|---|---|
| TABLE_CATALOG | varchar | Name of the catalog, which is always DREMIO. |
| TABLE_SCHEMA | varchar | The path (source, space, folders) to the table or view. |
| TABLE_NAME | varchar | The name of the table or view. |
| TABLE_TYPE | varchar | The type of the object. Enum: SYSTEM_TABLE, TABLE, VIEW |