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	See the Properties table below.
schema	string	The schema in which the table resides.

Properties

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.

For more information, please refer to the Tables SQL command reference.