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:

ColumnTypeDescription

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,

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

Last updated