Columns

The columns system table includes information about all the columns within all the tables created in your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.information_schema.columns;
-- If you have a lot of columns, you can use LIMIT to reduce the result set 
-- LIMIT 50; 

The system.information_schema.columns table includes the following columns:

Column	Type	Description
catalog	string	The name of the catalog used to store the parent table.
data_type	string	The type that was automatically inferred by Upsolver when the data was ingested, or the type that was specified by the user who created the table.
first_seen_on	datetime	This is the date and time when data first arrives in the column.
is_primary_key	Boolean	Returns TRUE or FALSE to indicate if this is a primary key column.
last_seen_on	datetime	The date and time when data last arrived in this column.
name	string	The name of the column that was inferred on initial ingestion by Upsolver or defined by the user on creation.
schema	string	The name of the schema in which the parent table was created.
table	string	The name of the table that was defined by the user on creation.
type_evolution [ data_type (string), first_seen_on (string), last_seen_on (string) ]	string	The history of data type changes discovered during ingestion. Upsolver automatically detects a changed type within a column and records the previous type, and when it was first and last seen. For more information, see Schema evolution and detection.

For more information on tables and columns, please refer to the Tables SQL command reference.