Comment on page
Tables
The tables system table includes information about the tables in your organization.
From a worksheet within Upsolver, run the following query:
SELECT *
FROM system.information_schema.tables;
-- If you have a lot of tables, you can use LIMIT to reduce the result set
-- LIMIT 50;
The system.information_schema.tables table includes the following columns:
Column | Type | Description |
---|---|---|
catalog | string | The name of the catalog used to store the table. |
comment | string | An optional comment to describe the table. |
created_at | datetime | The date and time when the table was created. |
created_by | string | The name of the user who created the table. |
id | string | The unique identifier for the table. |
modified_at | datetime | The date and time when the table was last modified. |
modified_by | string | The name of the user who modified the table. |
name | string | The name of the table. |
properties | string | |
schema | string | The schema in which the table resides. |
The properties column comprises information on the options specified when the table was created:
Column | Type | Description |
---|---|---|
COMMENT | string | An optional comment to describe the table |
COMPACTION_PROCESSES | integer | The number of compaction processes the table can do in parallel when it periodically compacts the data. |
COMPRESSION | string | The type of compression for the table data. |
COMPUTE_CLUSTER | string | The name of the compute cluster that processes the table. |
DISABLE_COMPACTION | Boolean | Returns TRUE or FALSE . If TRUE , compaction is disabled. |
EXPOSE_IN_CATALOG | Boolean | Returns TRUE or FALSE to determine if the table is exposed in the AWS Glue Data Catalog so it can be queried from data lake query engines. |
GLOBALLY_UNIQUE_KEYS | Boolean | Returns TRUE or FALSE to define whether primary keys should be unique across partitions. |
STORAGE_CONNECTION | string | The default storage connection configured for the metastore connection where the table is created. |
STORAGE_LOCATION | string | The default storage location configured for the metastore connection where the table is created. |
TABLE_DATA_RETENTION | string | The number of days that the data will be retained prior to deletion. |
Last modified 4mo ago