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:
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,
Last updated