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:
-- 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:
The name of the catalog used to store the parent table.
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.
This is the date and time when data first arrives in the column.
Returns TRUE or FALSE to indicate if this is a primary key column.
The date and time when data last arrived in this column.
The name of the column that was inferred on initial ingestion by Upsolver or defined by the user on creation.
The name of the schema in which the parent table was created.
The name of the table that was defined by the user on creation.
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,