SYS.PROJECT."TABLES"
The sys.project."tables" table contains metadata for tables in a project.
note
-
The name of the table must be encapsulated in quotes (
"tables") so that it is parsed as the table name instead of the reserved keywordtables. -
You may not see some rows in the table if you do not have access to the metadata storage container.
SELECT *
FROM sys.project."tables"
Example Output
| table_id | source_id | table_name | schema_id | path | tag | type | format_type | approx_statistics_allowed | created | owner_id | owner_type | masking_policies | row_access_policies | clustering_keys |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5d78cc0a-dc43-0319-ad01-f4a4990ccada | 6ae7ed51-449b-4826-8745-af31602d1f90 | PoliceIncidents | 063ca5a3-be0e-766c-8f6f-d59ada26b0cf | [testsource, FolderA, v1] | 00001-983af174-4d55-4556-b36f-fde125672f1e | NESSIE_TABLE | ICEBERG | false | 2023-12-01 17:23:20.204 | $unowned$ | $unowned$ | [] | [] | empty text |
| 00cf3b4c-4042-4474-bad8-3a5c8bb6ffe9 | 7c8f019b-2e48-4d40-8a2f-038dae416dc4 | CATALOGS | empty text | [INFORMATION_SCHEMA, CATALOGS] | nqoL6Ab63EE= | SYSTEM_TABLE | empty text | false | 2021-12-08 15:47:51.880 | $unowned$ | $unowned$ | [] | [] | empty text |
| ab94e588-6efa-4cbc-8641-6ac35887808f | 7c8f019b-2e48-4d40-8a2f-038dae416dc4 | COLUMNS | empty text | [INFORMATION_SCHEMA, COLUMNS] | nn9iIx6sBXM= | SYSTEM_TABLE | empty text | false | 2021-12-08 15:47:52.022 | $unowned$ | $unowned$ | [] | [] | empty text |
| 88bc523d-814c-464f-b794-b0a123da15c5 | 7c8f019b-2e48-4d40-8a2f-038dae416dc4 | SCHEMATA | empty text | [INFORMATION_SCHEMA, SCHEMATA] | 2B2bcqtiiRY= | SYSTEM_TABLE | empty text | false | 2021-12-08 15:47:51.922 | $unowned$ | $unowned$ | [] | [] | empty text |
| 776c727b-93a7-4ede-86de-f2c117b81aaa | 7c8f019b-2e48-4d40-8a2f-038dae416dc4 | TABLES | empty text | [INFORMATION_SCHEMA, TABLES] | R2+uXXdzCD8= | SYSTEM_TABLE | empty text | false | 2021-12-08 15:47:51.953 | $unowned$ | $unowned$ | [] | [] | empty text |
| 448136c0-65d0-4182-af42-3f2015acec1d | 7c8f019b-2e48-4d40-8a2f-038dae416dc4 | VIEWS | empty text | [INFORMATION_SCHEMA, VIEWS] | DzR2AE93Xi0= | SYSTEM_TABLE | empty text | false | 2021-12-08 15:47:51.987 | $unowned$ | $unowned$ | [] | [] | empty text |
| eb5e9ee9-dbd7-40a8-b48a-5aa0170383fd | bd02d9ed-9a1e-4fba-b59b-d0d74b6d7232 | NYC-taxi-trips | 8e7d637e-dc4f-4372-83cc-08e51bc81cc7 | [Samples, samples.dremio.com, NYC-taxi-trips] | 1wa3yogWHHM= | PHYSICAL_DATASET | PARQUET | false | 2021-12-10 06:56:55.364 | $unowned$ | $unowned$ | [function_name: ""@dremio".long_dist" args: "trip_distance" column_name: "distance_mi"] | [] | empty text |
| a0f0edb3-b333-4c8e-880c-2d89648113f9 | bd02d9ed-9a1e-4fba-b59b-d0d74b6d7232 | zips.json | 8e7d637e-dc4f-4372-83cc-08e51bc81cc7 | [Samples, samples.dremio.com, zips.json] | rFfpVH9umtQ= | PHYSICAL_DATASET | JSON | false | 2022-01-05 22:10:42.528 | $unowned$ | $unowned$ | [] | [] | empty text |
Fields
| Field | Data Type | Description |
|---|---|---|
| table_id | varchar | The UUID to identify the table. |
| source_id | varchar | The UUID to identify the source that the table is associated with. |
| table_name | varchar | The user- or system-defined name of the table. |
| schema_id | varchar | The UUID for the schema/folder in which the table is contained. |
| path | varchar | The string array representation of the path of the table. |
| tag | varchar | The UUID that is generated to identify the instance of the table. Dremio changes this tag whenever a change is made to the table. |
| type | varchar | The type of table. Enum: PHYSICAL_DATASET, SYSTEM_TABLE, NESSIE_TABLE |
| format_type | varchar | The format type of the data. Enum: DELTA, EXCEL, ICEBERG, JSON, PARQUET, TEXT, UNKNOWN, XLS, _empty text_ |
| approx_statistics_allowed | boolean | When set, COUNT DISTINCT queries will return approximate results. This value will be true if approximate results will be returned and false otherwise. |
| created | timestamp | The date and time that the table was created. |
| owner_id | varchar | The UUID for the owner (user or role) of the table. This UUID corresponds to the id in the users or roles system table. |
| owner_type | varchar | The type of owner of the table. This value will be $unowned$ if ownership has not been granted for the table. Enum: USER_OWNER, ROLE_OWNER, $unowned$ |
| masking_policies | varchar | The masking policies set on the view. |
| row_access_policies | varchar | The row-access policies set on the view. |
| clustering_keys | varchar | The clustering columns defined in the table DDL. |