Skip to main content

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

Syntax
SELECT *
FROM sys.project."tables"

Example Output

table_idsource_idtable_nameschema_idpathtagtypeformat_typeapprox_statistics_allowedcreatedowner_idowner_typemasking_policiesrow_access_policies
54191051-40a8-4474-82b0-0ab8bb6a2cd8edfcefa9-ac64-4a41-8406-c362801236dbarctic_events2ed4e396-e896-4802-98ca-4ba8bf782b99[dev, internaldatalake, arctic_events]01603-96c6e626-5ed0-454f-93a2-ee05d5887b80NESSIE_TABLEICEBERGfalse2023-07-26 23:10:23.273$unowned$$unowned$[][]
00cf3b4c-4042-4474-bad8-3a5c8bb6ffe97c8f019b-2e48-4d40-8a2f-038dae416dc4CATALOGSempty text[INFORMATION_SCHEMA, CATALOGS]nqoL6Ab63EE=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.880$unowned$$unowned$[][]
ab94e588-6efa-4cbc-8641-6ac35887808f7c8f019b-2e48-4d40-8a2f-038dae416dc4COLUMNSempty text[INFORMATION_SCHEMA, COLUMNS]nn9iIx6sBXM=SYSTEM_TABLEempty textfalse2021-12-08 15:47:52.022$unowned$$unowned$[][]
88bc523d-814c-464f-b794-b0a123da15c57c8f019b-2e48-4d40-8a2f-038dae416dc4SCHEMATAempty text[INFORMATION_SCHEMA, SCHEMATA]2B2bcqtiiRY=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.922$unowned$$unowned$[][]
776c727b-93a7-4ede-86de-f2c117b81aaa7c8f019b-2e48-4d40-8a2f-038dae416dc4TABLESempty text[INFORMATION_SCHEMA, TABLES]R2+uXXdzCD8=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.953$unowned$$unowned$[][]
448136c0-65d0-4182-af42-3f2015acec1d7c8f019b-2e48-4d40-8a2f-038dae416dc4VIEWSempty text[INFORMATION_SCHEMA, VIEWS]DzR2AE93Xi0=SYSTEM_TABLEempty textfalse2021-12-08 15:47:51.987$unowned$$unowned$[][]
eb5e9ee9-dbd7-40a8-b48a-5aa0170383fdbd02d9ed-9a1e-4fba-b59b-d0d74b6d7232NYC-taxi-trips8e7d637e-dc4f-4372-83cc-08e51bc81cc7[Samples, samples.dremio.com, NYC-taxi-trips]1wa3yogWHHM=PHYSICAL_DATASETPARQUETfalse2021-12-10 06:56:55.364$unowned$$unowned$[function_name: "\"@dremio\".long_dist" args: "trip_distance" column_name: "distance_mi"][]
a0f0edb3-b333-4c8e-880c-2d89648113f9bd02d9ed-9a1e-4fba-b59b-d0d74b6d7232zips.json8e7d637e-dc4f-4372-83cc-08e51bc81cc7[Samples, samples.dremio.com, zips.json]rFfpVH9umtQ=PHYSICAL_DATASETJSONfalse2022-01-05 22:10:42.528$unowned$$unowned$[][]

Fields

FieldData TypeDescription
table_idvarcharThe UUID to identify the table.
source_idvarcharThe UUID to identify the source that the table is associated with.
table_namevarcharThe user- or system-defined name of the table.
schema_idvarcharThe UUID for the schema/folder in which the table is contained.
pathvarcharThe string array representation of the path of the table.
tagvarcharThe UUID that is generated to identify the instance of the table. Dremio changes this tag whenever a change is made to the table.
typevarcharThe type of table.
Enum: PHYSICAL_DATASET, SYSTEM_TABLE, NESSIE_TABLE
format_typevarcharThe format type of the data.
Enum: DELTA, EXCEL, ICEBERG, JSON, PARQUET, TEXT, UNKNOWN, XLS, _empty text_
approx_statistics_allowedbooleanWhen set, COUNT DISTINCT queries will return approximate results. This value will be true if approximate results will be returned and false otherwise.
createdtimestampThe date and time that the table was created.
owner_idvarcharThe UUID for the owner (user or role) of the table. This UUID corresponds to the id in the users or roles system table.
owner_typevarcharThe 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_policiesvarcharThe masking policies set on the view.
row_access_policiesvarcharThe row-access policies set on the view.