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

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.

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.

Jobs

Users

Last modified 4mo ago