Overview
The ANSI Virtual Catalog tables represent Kinetica's implementation of the Schemata section of the ISO/IEC 9075 (SQL:2003) database specification. This section defines the metadata tables that exist under the INFORMATION_SCHEMA schema. These tables contain information about the database's objects, relationships, & permissions.
Most of the metadata tables are implemented as logical views of the Kinetica Virtual Catalog tables, while some are logical views of other ANSI Virtual Catalog logical views. As such, they will be updated automatically to reflect changes in the database structure and processing state.
The information returned when querying the virtual catalogs is automatically filtered by the permissions of the querying user. For instance, regular users will only see the tables & views to which they have access when querying a virtual catalog table that lists all of the tables in the database, while system administrators will see all tables & views.
Catalog View List
The ANSI Virtual Catalog tables reside in the information_schema schema.
| Virtual Catalog Table | Description | ||||||
|---|---|---|---|---|---|---|---|
| APPLICABLE_ROLES | Users & roles. This is only a simple list, one record per unique user or role--it is not a list of mappings of roles to users and roles to roles.
| ||||||
| CHARACTER_SETS | Contains a single record with the supported character set, UTF-8. | ||||||
| COLUMNS | Columns of tables & views and their respective types & statistics. | ||||||
| CONSTRAINT_COLUMN_USAGE | Columns with constraints and their containing schemas. | ||||||
| CONTEXT_RULES | Rules sections of SQL-GPT contexts. | ||||||
| CONTEXT_SAMPLES | Samples sections of SQL-GPT contexts. | ||||||
| CONTEXT_TABLE_COLUMNS | Columns of tables associated with SQL-GPT contexts. | ||||||
| CONTEXT_TABLES | Tables associated with SQL-GPT contexts. | ||||||
| CONTEXTS | SQL-GPT contexts and their configuration. | ||||||
| DATABASES | Contains a single record with the database name and owner. | ||||||
| ENABLED_ROLES | Users & roles. | ||||||
| FIELDS | Columns of tables & views and their respective types & statistics, also containing the object type of the containing table/view. | ||||||
| FUNCTIONS | Scalar, aggregate, window, and user-defined functions. | ||||||
| INFORMATION_SCHEMA_CATALOG_NAME | Contains a single record with the catalog name, kinetica. | ||||||
| KEY_COLUMN_USAGE | Primary & foreign keys and their associated columns. | ||||||
| KI_CATALOG_VERSION | Contains a single record with the virtual catalog schema version. | ||||||
| KI_LOAD_HISTORY | Record & statistics of each data load or export, subscription event, and data refresh. | ||||||
| KI_QUERY_ACTIVE | Actively running SQL statements, including DML & DDL. | ||||||
| KI_QUERY_HISTORY | History of SQL statements run within the database, including DML & DDL; will not include multi-head ingest/egress. | ||||||
| KI_QUERY_SPAN_METRICS | Processing metrics of SQL statements run within the database, including DML & DDL; will not include multi-head ingest/egress. | ||||||
| KI_QUERY_SPAN_METRICS_BY_SQL_STEP | Processing metrics of SQL statements run within the database, aggregated on each execution phase of a given query/command. | ||||||
| KI_QUERY_WORKERS | Worker ranks' status and their actively running tasks. | ||||||
| OBJECT_PRIVILEGES | Privileges granted, including the grantee, privilege type, and object to which access was granted. | ||||||
| REFERENTIAL_CONSTRAINTS | Foreign keys and their referenced unique constraints. | ||||||
| ROLE_TABLE_GRANTS | Alias for the TABLE_PRIVILEGES table. | ||||||
| SCHEMATA | Schemas, containing all database objects. | ||||||
| TABLE_CONSTRAINTS | Primary & foreign keys and their respective types & statistics. | ||||||
| TABLE_PRIVILEGES | Privileges granted on tables & views. | ||||||
| TABLES | Tables & views and their respective types & statistics. | ||||||
| VIEWS | Views and their respective definitions & statistics. |
