---
title: System Catalog
slug: system-catalog
description: Explore the system catalog table reference for metadata, schema management, and system monitoring in the Ocient System.
docTags: 
createdAt: Fri Apr 10 2026 19:53:00 GMT+0000 (Coordinated Universal Time)
updatedAt: Fri Apr 10 2026 20:03:05 GMT+0000 (Coordinated Universal Time)
---

The system catalog exposes read-only virtual tables that contain metadata about the system.

# Alphabetical List of Tables

- sys.active\_operator\_instances
- sys.active\_query\_scheduler\_info
- sys.addendum\_directories
- sys.all\_operator\_instances
- sys.association\_rules\_models
- sys.average\_bb\_sizes
- sys.average\_column\_sizes
- sys.bagging\_models
- sys.boosting\_models
- sys.channel\_endpoint\_parameters
- sys.clusters
- sys.column\_cardinalities
- sys.column\_distributions
- sys.columns
- sys.columns\_compression\_info
- sys.completed\_operator\_instances
- sys.completed\_queries
- sys.compute\_configurations
- sys.config
- sys.connectivity\_pool\_participants
- sys.connectivity\_pools
- sys.constraints
- sys.current\_osn
- sys.data\_usage
- sys.databases
- sys.decision\_tree\_models
- sys.degraded\_segment\_groups
- sys.feedforward\_network\_models
- sys.function\_signatures
- sys.functions
- sys.gaussian\_mixture\_models
- sys.global\_map\_table\_info
- sys.gradient\_boosted\_trees\_models
- sys.group\_roles
- sys.groups
- sys.index\_advisor\_enabled
- sys.index\_advisors
- sys.index\_columns
- sys.index\_recommendations
- sys.index\_usage
- sys.indexes
- sys.k\_means\_models
- sys.k\_nearest\_neighbors\_models
- sys.linear\_combination\_regression\_models
- sys.linear\_discriminant\_analysis\_models
- sys.load\_errors
- sys.load\_events
- sys.load\_metrics
- sys.locations
- sys.locks
- sys.logistic\_regression\_models
- sys.lts\_cluster\_info
- sys.machine\_learning\_model\_options
- sys.machine\_learning\_models
- sys.mcp\_tools
- sys.merge\_eligibilities
- sys.merge\_policies
- sys.metric\_levels
- sys.multiple\_linear\_regression\_models
- sys.naive\_bayes\_models
- sys.network\_interface\_models
- sys.network\_interface\_usage\_types
- sys.node\_clusters
- sys.node\_config
- sys.node\_network\_interfaces
- sys.node\_status
- sys.nodes
- sys.nonlinear\_regression\_models
- sys.oidc\_integrations
- sys.oidc\_sessions
- sys.op\_inst\_debug\_info
- sys.orphaned\_segments
- sys.osn\_acquisitions
- sys.pipeline\_errors
- sys.pipeline\_events
- sys.pipeline\_files
- sys.pipeline\_files\_pending
- sys.pipeline\_functions
- sys.pipeline\_metrics
- sys.pipeline\_metrics\_info
- sys.pipeline\_partitions
- sys.pipeline\_tables
- sys.pipeline\_tasks
- sys.pipelines
- sys.plans
- sys.polynomial\_regression\_models
- sys.principal\_component\_analysis\_models
- sys.privileges
- sys.procedures
- sys.queries
- sys.random\_forest\_models
- sys.regression\_tree\_models
- sys.reserved\_words
- sys.result\_cache
- sys.retention\_policies
- sys.rights
- sys.roles
- sys.sample\_segment\_io\_pipelines
- sys.scheduled\_tasks
- sys.schemas
- sys.security\_integrations
- sys.security\_settings
- sys.segment\_batch\_events
- sys.segment\_directories
- sys.segment\_generation\_events
- sys.segment\_group\_transfers
- sys.segment\_groups
- sys.segment\_part\_inventory
- sys.segment\_part\_redundancy\_info
- sys.segment\_parts
- sys.segments
- sys.segments\_compression\_info
- sys.service\_classes
- sys.service\_classes\_for\_user
- sys.service\_role\_channel\_endpoints
- sys.service\_role\_status
- sys.service\_roles
- sys.sessions
- sys.simple\_linear\_regression\_models
- sys.sql\_messages
- sys.stacking\_models
- sys.stats\_files
- sys.stop\_osn\_reap\_requests
- sys.storage\_capacity
- sys.storage\_device\_files
- sys.storage\_device\_metrics
- sys.storage\_device\_status
- sys.storage\_scopes
- sys.storage\_spaces
- sys.storage\_used
- sys.stored\_leaf\_segment\_part\_inventory
- sys.stored\_segments
- sys.subtasks
- sys.support\_vector\_machine\_models
- sys.system\_information
- sys.system\_table\_columns
- sys.system\_tables
- sys.table\_cardinalities
- sys.tables
- sys.tasks
- sys.tkt\_table\_clustering\_column\_indices
- sys.tkt\_table\_info
- sys.unhealthy\_segments
- sys.user\_groups
- sys.user\_mappings
- sys.user\_roles
- sys.users
- sys.vector\_autoregression\_models
- sys.view\_columns
- sys.views
- sys.vl\_columns\_compression\_info

# Alphabetical List of Categories

- Configuration
- Connectivity Pools
- Databases
- Loading
- Machine Learning
- Model Context Protocol
- Monitoring
- Network
- Pipelines
- Security
- Security Integrations
- Statistics
- Storage
- System
- System Information
- User Management
- Workload Management

# Catalog Table Details

## Configuration

### sys.config

This table contains all configuration overrides applied on the system.

| Column Name | Column Type | Column Description                                                                     |
| ----------- | ----------- | -------------------------------------------------------------------------------------- |
| scope\_type | CHAR        | Type of the scope.                                                                     |
| scope\_id   | UUID        | Universally Unique IDentifier (UUID) of the storage scope where this override applies. |
| key         | CHAR        | String that represents the configuration parameter.                                    |
| value       | CHAR        | Value for the configuration parameter key.                                             |

### sys.node\_config

This table contains the effective node configuration for all nodes in the system.

| Column Name | Column Type | Column Description                                                                            |
| ----------- | ----------- | --------------------------------------------------------------------------------------------- |
| node\_id    | UUID        | Universally Unique IDentifier (UUID) of the node where this configuration exists (sys.nodes). |
| key         | CHAR        | String that represents the configuration parameter.                                           |
| value       | CHAR        | Value for the configuration parameter key.                                                    |

## Connectivity Pools

### sys.connectivity\_pool\_participants

This table contains the connectivity pool participants and their information.

| Column Name         | Column Type | Column Description                                                                                 |
| ------------------- | ----------- | -------------------------------------------------------------------------------------------------- |
| id                  | UUID        | Universally Unique IDentifier (UUID) of the connectivity pool that contains the participant.       |
| node\_id            | UUID        | UUID of the participant node.                                                                      |
| created\_at         | TIMESTAMP   | Timestamp that indicates the creation of the connectivity pool participant.                        |
| updated\_at         | TIMESTAMP   | Timestamp that indicates the last update of the connectivity pool participant.                     |
| listen\_address     | CHAR        | Address where the participant node listens.                                                        |
| listen\_port        | INT         | Port number where the participant node listens.                                                    |
| advertised\_address | CHAR        | Address that the participant node advertises to the client.                                        |
| advertised\_port    | INT         | Optional port number that the participant node advertises to the client.                           |
| openapi\_port       | INT         | Optional port number where the API, written according to the OpenAPI Specification (OAS), listens. |

### sys.connectivity\_pools

This table contains the connectivity pools and their information (excluding participants).

| Column Name            | Column Type | Column Description                                                      |
| ---------------------- | ----------- | ----------------------------------------------------------------------- |
| id                     | UUID        | Universally Unique IDentifier (UUID) of the connectivity pool.          |
| name                   | CHAR        | Name of the connectivity pool.                                          |
| created\_at            | TIMESTAMP   | Timestamp that indicates the creation of the connectivity pool.         |
| updated\_at            | TIMESTAMP   | Timestamp that indicates the last update of the connectivity pool.      |
| source\_address        | CHAR        | Source address in CIDR notation for the connectivity pool.              |
| source\_port           | INT         | Optional source port of the connectivity pool.                          |
| priority               | INT         | Priority of the connectivity pool.                                      |
| sso\_integration\_name | CHAR        | Name of the default SSO security integration for the connectivity pool. |

## Databases

### sys.columns

This table contains all columns in each table in the system.

| Column Name         | Column Type | Column Description                                          |
| ------------------- | ----------- | ----------------------------------------------------------- |
| id                  | UUID        | Universally Unique IDentifier (UUID) of the column.         |
| name                | CHAR        | Name of the column.                                         |
| data\_type          | CHAR        | Data type of the column (INT, CHAR, BOOLEAN, etc.).         |
| position            | INT         | Position of the column in its table.                        |
| table\_id           | UUID        | UUID of the table that contains this column (sys.tables).   |
| nullable            | BOOLEAN     | Specifies whether the values in this column can be NULL.    |
| default\_expression | CHAR        | Default value of this column when the value is unspecified. |
| description         | CHAR        | Description of the column.                                  |
| type\_hint          | CHAR        | Type hint for the expected type of the column.              |
| ordinal             | LONG        | Ordinal of the column with respect to its table.            |
| gdc\_type           | CHAR        | Type of GDC applied to this column.                         |
| potential\_index    | BOOLEAN     | Specifies whether the column is a potential index.          |
| system              | BOOLEAN     | Specifies whether the column is a system column.            |

### sys.constraints

This table contains the constraints for the database.

| Column Name                | Column Type | Column Description                                                                                                    |
| -------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------- |
| id                         | UUID        | The Universally Unique IDentifier (UUID) of the constraint.                                                           |
| table\_id                  | UUID        | The UUID of the table (sys.tables).                                                                                   |
| name                       | CHAR        | The name of the constraint that has to be unique within an individual table.                                          |
| constraint\_type           | CHAR        | The type of the constraint (PRIMARY\_KEY, UNIQUE, FOREIGN\_KEY).                                                      |
| column\_names              | ARRAY(CHAR) | The names of the columns where the constraint applies.                                                                |
| referenced\_constraint\_id | UUID        | The UUID of the referenced constraint. This value is NULL for non-foreign key constraints.                            |
| referenced\_table\_id      | UUID        | The UUID of the referenced table. This value is NULL for non-foreign key constraints.                                 |
| referenced\_column\_names  | ARRAY(CHAR) | The names of the columns where the referenced constraint applies. This value is NULL for non-foreign key constraints. |

### sys.databases

This table contains all databases defined in the system.

| Column Name                   | Column Type | Column Description                                      |
| ----------------------------- | ----------- | ------------------------------------------------------- |
| id                            | UUID        | Universally Unique IDentifier (UUID) of the database.   |
| name                          | CHAR        | Name of the database.                                   |
| created\_at                   | TIMESTAMP   | Timestamp that specifies when the database was created. |
| user\_can\_view\_all\_queries | BOOLEAN     | Current user can view all queries made in this database |

### sys.functions

This table contains all of the user-defined functions in the system.

| Column Name                        | Column Type | Column Description                                                                                                            |
| ---------------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------- |
| id                                 | UUID        | Universally Unique IDentifier (UUID) of the user-defined function.                                                            |
| schema                             | CHAR        | Schema of the user-defined function.                                                                                          |
| name                               | CHAR        | Name of the user-defined function.                                                                                            |
| sql\_expression                    | CHAR        | For SQL user-defined functions, this is the expression that defines the function.                                             |
| database\_id                       | UUID        | UUID of the database of this user-defined function (sys.databases).                                                           |
| created\_at                        | TIMESTAMP   | Timestamp of when this user-defined function was created.                                                                     |
| updated\_at                        | TIMESTAMP   | Timestamp of when this user-defined function was last updated.                                                                |
| language                           | CHAR        | Language that the user-defined function is written in.                                                                        |
| function\_type                     | CHAR        | For non-SQL user-defined functions, the type of function being defined.                                                       |
| filename                           | CHAR        | For non-SQL user-defined functions, the name of the file containing the user-defined function code.                           |
| function\_name\_in\_external\_code | CHAR        | For non-SQL user-defined functions, the name of the Java or Python function or method that defines the user-defined function. |
| return\_type                       | CHAR        | For non-SQL user-defined functions, the return type of the user-defined function.                                             |

### sys.global\_map\_table\_info

This table contains the global dictionary compression (GDC) details associated with each compressed column.

| Column Name      | Column Type | Column Description                                              |
| ---------------- | ----------- | --------------------------------------------------------------- |
| table\_id        | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| column\_id       | UUID        | UUID of the column (sys.columns).                               |
| compressed\_size | INT         | Compressed column size (in bytes).                              |
| max\_count       | LONG        | Maximum amount of unique column values allowed in the column.   |
| current\_count   | LONG        | Current amount of unique column values in the column.           |

### sys.index\_advisor\_enabled

This table contains all tables and databases where the index advisor is currently enabled.

| Column Name  | Column Type | Column Description                                             |
| ------------ | ----------- | -------------------------------------------------------------- |
| id           | UUID        | Universally Unique IDentifier (UUID) of the table or database. |
| name         | CHAR        | Name of the table or database.                                 |
| object\_type | CHAR        | Determines whether this object is a database or table.         |

### sys.index\_advisors

This table contains raw index advisor information.

| Column Name  | Column Type | Column Description                                                                      |
| ------------ | ----------- | --------------------------------------------------------------------------------------- |
| table\_id    | UUID        | Universally Unique IDentifier (UUID) of the table for the potential index (sys.tables). |
| column\_id   | UUID        | UUID that represents the column (sys.columns).                                          |
| table\_name  | CHAR        | Name of the table.                                                                      |
| column\_name | CHAR        | Name of the column.                                                                     |
| index\_type  | CHAR        | Type of the potential index.                                                            |
| query\_id    | UUID        | UUID that represents the query.                                                         |
| query\_time  | TIMESTAMP   | A UNIX timestamp that represents when the query executed.                               |
| sql          | CHAR        | The SQL statement to use for creating this index.                                       |

### sys.index\_columns

This table contains the index settings applied to each column.

| Column Name     | Column Type | Column Description                                                                                          |
| --------------- | ----------- | ----------------------------------------------------------------------------------------------------------- |
| index\_id       | UUID        | Universally Unique IDentifier (UUID) that represents the index (sys.indexes).                               |
| column\_id      | UUID        | UUID that represents the column (sys.columns).                                                              |
| ordinal         | INT         | Ordinal of the column in the index structure.                                                               |
| tuple\_element  | CHAR        | Specifies the name of the component column that the index applies to if the index exists on a tuple column. |
| ascending       | BOOLEAN     | Indicates whether the values in this column are built in ascending order.                                   |
| column\_ordinal | LONG        | Ordinal position of this column in the source table.                                                        |

### sys.index\_recommendations

This table contains index recommendations.

| Column Name  | Column Type | Column Description                                |
| ------------ | ----------- | ------------------------------------------------- |
| table\_name  | CHAR        | Name of the table.                                |
| column\_name | CHAR        | Name of the column.                               |
| sql          | CHAR        | The SQL statement to use for creating this index. |
| usage\_count | LONG        | Number of times this index would be used.         |

### sys.index\_usage

This table contains index usage information.

| Column Name | Column Type | Column Description                                                            |
| ----------- | ----------- | ----------------------------------------------------------------------------- |
| table\_id   | UUID        | Universally Unique IDentifier (UUID) of the table where the index is located. |
| index\_id   | UUID        | UUID of the index.                                                            |
| segment\_id | UUID        | UUID of the segment with the index.                                           |
| query\_id   | UUID        | UUID of the query that could have used the index.                             |
| was\_used   | BOOLEAN     | Whether or not the index was used.                                            |

### sys.indexes

This table contains all indexes defined on tables.

| Column Name | Column Type | Column Description                                 |
| ----------- | ----------- | -------------------------------------------------- |
| id          | UUID        | Universally Unique IDentifier (UUID) of the index. |
| name        | CHAR        | Name of the index.                                 |
| index\_type | CHAR        | Type of the index.                                 |
| table\_id   | UUID        | UUID of the table for the index (sys.tables).      |
| index\_use  | CHAR        | Intended use for the index by the system.          |
| ngram\_size | INT         | Size of each N-gram (in bytes).                    |
| enabled     | BOOLEAN     | Whether the index is enabled on this table.        |

### sys.locations

This table contains all of the external table providers.

| Column Name  | Column Type | Column Description                                                          |
| ------------ | ----------- | --------------------------------------------------------------------------- |
| id           | UUID        | Universally Unique IDentifier (UUID) of the location.                       |
| name         | CHAR        | Name of the location.                                                       |
| remote\_info | CHAR        | Remote information that defines how to talk to the external table provider. |
| database\_id | UUID        | UUID of the database of this location (sys.databases).                      |
| created\_at  | TIMESTAMP   | Timestamp that represents when this location was created.                   |
| updated\_at  | TIMESTAMP   | Timestamp that represents when this location was last updated.              |

### sys.procedures

This table contains all of the stored procedures in the system.

| Column Name     | Column Type | Column Description                                                                                                                          |
| --------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
| id              | UUID        | Universally Unique IDentifier (UUID) of the stored procedure.                                                                               |
| schema          | CHAR        | Schema of the stored procedure.                                                                                                             |
| name            | CHAR        | Name of the stored procedure.                                                                                                               |
| database\_id    | UUID        | UUID of the database of this stored procedure (sys.databases).                                                                              |
| created\_at     | TIMESTAMP   | Timestamp of when this stored procedure was created.                                                                                        |
| updated\_at     | TIMESTAMP   | Timestamp of when this stored procedure was last updated.                                                                                   |
| language        | CHAR        | Language that the stored procedure is written in.                                                                                           |
| filename        | CHAR        | For Java® and Python® stored procedures, the name of the file that the database should load when it needs this stored procedure.            |
| function\_name  | CHAR        | For Java® and Python® stored procedures, the name of the function that executes the stored procedure.                                       |
| body            | CHAR        | For SQL stored procedures, the SQL statements to execute when the database runs this stored procedure.                                      |
| returns\_result | BOOLEAN     | For SQL stored procedures, the system sets this value to `true` if the stored procedure returns a result set. The default value is `false`. |

### sys.tables

This table contains all tables defined in the system.

| Column Name                    | Column Type | Column Description                                                                                          |
| ------------------------------ | ----------- | ----------------------------------------------------------------------------------------------------------- |
| id                             | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables).                                             |
| name                           | CHAR        | Name of the table.                                                                                          |
| schema                         | CHAR        | Name of the schema.                                                                                         |
| database\_id                   | UUID        | UUID of the database (sys.databases).                                                                       |
| storage\_space\_id             | UUID        | UUID of the storage space (sys.storage\_spaces).                                                            |
| maximum\_segment\_size\_gib    | INT         | Maximum size of a segment for the table in GiB.                                                             |
| description                    | CHAR        | Detailed description of the table.                                                                          |
| streamloader\_property\_string | CHAR        | Additional properties assigned to control the stream loading behavior for the table.                        |
| lts\_property\_string          | CHAR        | Additional properties assigned to control the Foundation role (formerly "lts role") behavior for the table. |
| created\_at                    | TIMESTAMP   | Timestamp that represents when the table was created.                                                       |
| altered\_at                    | TIMESTAMP   | Timestamp that represents when the table's structure was last modified via DDL.                             |
| rolehostd\_version             | CHAR        | The rolehostd version in which this table was created                                                       |
| software\_compatible\_version  | INT         | The rolehostd version this table is compatible with.                                                        |
| creator\_id                    | UUID        | The UUID of the user or group who created the table (sys.users).                                            |

### sys.tkt\_table\_clustering\_column\_indices

This table contains the columns defined as part of a clustering index.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| table\_id   | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| column\_id  | UUID        | UUID of the column (sys.columns).                               |

### sys.tkt\_table\_info

This table contains the columns that are defined as the time key on each user-defined table and the size of the time bucket in use.

| Column Name                   | Column Type | Column Description                                                                 |
| ----------------------------- | ----------- | ---------------------------------------------------------------------------------- |
| table\_id                     | UUID        | The Universally Unique IDentifier (UUID) of the table (sys.tables).                |
| time\_column\_id              | UUID        | The UUID of the column that represents the time column in the table (sys.columns). |
| time\_bucket\_width           | LONG        | The width of the time bucket for segmenting data in nanoseconds or days.           |
| time\_bucket\_width\_interval | CHAR        | The readable interval for the width of the time bucket for segmenting data.        |
| retention\_policy             | LONG        | The interval for the retention policy for rolling off data in nanoseconds or days. |
| retention\_policy\_interval   | CHAR        | The readable interval of the retention policy for rolling off data.                |

### sys.user\_mappings

This table contains user mappings for locations.

| Column Name      | Column Type | Column Description                                                 |
| ---------------- | ----------- | ------------------------------------------------------------------ |
| id               | UUID        | Universally Unique IDentifier (UUID) of the user mapping.          |
| name             | CHAR        | Name of the user mapping.                                          |
| local\_userid    | CHAR        | Local user identifier.                                             |
| remote\_userid   | CHAR        | Remote user identifier.                                            |
| location\_id     | UUID        | UUID of the location for this user mapping.                        |
| database\_id     | UUID        | UUID of the database for this user mapping (sys.databases).        |
| created\_at      | TIMESTAMP   | Timestamp that represents when this user mapping was created.      |
| updated\_at      | TIMESTAMP   | Timestamp that represents when this user mapping was last updated. |
| remote\_password | CHAR        | Password for the remote user identifier.                           |

### sys.view\_columns

This table contains all columns in each view in the system.

| Column Name                                | Column Type | Column Description                                      |
| ------------------------------------------ | ----------- | ------------------------------------------------------- |
| id                                         | UUID        | The Universally Unique IDentifier (UUID) of the column. |
| name                                       | CHAR        | The name of the column.                                 |
| data\_type                                 | CHAR        | The data type of the column.                            |
| view\_id                                   | UUID        | The UUID of the view this column comes from.            |
| nullable                                   | BOOLEAN     | Whether or not this column is nullable.                 |
| default\_expression                        | CHAR        | The default expression of this column, if it exists.    |
| ordinal                                    | LONG        | The ordinal of this column.                             |
| global\_dictionary\_compression\_table\_id | UUID        | UUID of the table with the GDC column (sys.tables).     |

### sys.views

This table contains all user-defined database views created on the system.

| Column Name                                | Column Type | Column Description                                                           |
| ------------------------------------------ | ----------- | ---------------------------------------------------------------------------- |
| id                                         | UUID        | Universally Unique IDentifier (UUID) of the view.                            |
| name                                       | CHAR        | Name of the view.                                                            |
| database\_id                               | UUID        | UUID of the database (sys.databases).                                        |
| schema                                     | CHAR        | Schema name where the view exists.                                           |
| query                                      | CHAR        | Query used to generate the view content.                                     |
| description                                | CHAR        | Detailed description of the view.                                            |
| global\_dictionary\_compression\_table\_id | UUID        | UUID of the table with the GDC column (sys.tables).                          |
| created\_at                                | TIMESTAMP   | Timestamp that represents the date and time for the creation of the view.    |
| updated\_at                                | TIMESTAMP   | Timestamp that represents the date and time for the last update of the view. |
| creator\_id                                | UUID        | The UUID of the user or group who created the view (sys.users/sys.groups).   |

## Loading

### sys.load\_errors

The `load_errors` table shows information for load errors in the system.

| Column Name      | Column Type | Column Description                                                                                                  |
| ---------------- | ----------- | ------------------------------------------------------------------------------------------------------------------- |
| node\_id         | UUID        | The unique identifier of the Loader Node.                                                                           |
| table\_id        | UUID        | If the event is specific to a table, the unique identifier of the table.                                            |
| error\_message   | VARCHAR     | The message that provides more details about the error.                                                             |
| error\_timestamp | TIMESTAMP   | The timestamp when this error occurred.                                                                             |
| load\_id         | UUID        | If the event is specific to a pipeline or query, the Universally Unique IDentifier (UUID) of the pipeline or query. |

### sys.load\_events

The `load_events` table shows information for the load events in the system.

| Column Name      | Column Type | Column Description                                                                                                                                          |
| ---------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
| node\_id         | UUID        | The unique identifier of the Loader Node.                                                                                                                   |
| table\_id        | UUID        | If the event is specific to a table, the unique identifier of the table.                                                                                    |
| event\_type      | VARCHAR     | The type of the event.                                                                                                                                      |
| event\_timestamp | TIMESTAMP   | The timestamp when this event occurred.                                                                                                                     |
| load\_id         | UUID        | If the event is specific to a pipeline or query, the unique identifier of the pipeline or query.                                                            |
| batch\_id        | UUID        | If the event is specific to segment generation, this column is the unique identifier for the batch of pages specified by the system for segment generation. |
| event\_message   | VARCHAR     | The message that provides more details about the event.                                                                                                     |

### sys.load\_metrics

The `load_metrics` table shows information for the load metrics in the system.

| Column Name | Column Type | Column Description                                                                             |
| ----------- | ----------- | ---------------------------------------------------------------------------------------------- |
| node\_id    | UUID        | The Universally Unique IDentifier (UUID) of the Loader Node (sys.nodes).                       |
| table\_id   | UUID        | If the metric is specific to a table, the UUID of the table (sys.tables).                      |
| load\_id    | UUID        | If the metric is specific to a data pipeline or query, the UUID of the data pipeline or query. |
| name        | VARCHAR     | The type of the metric.                                                                        |
| component   | VARCHAR     | The component of the metric.                                                                   |
| value       | BIGINT      | The value of the metric.                                                                       |
| updated\_at | TIMESTAMP   | Timestamp that represents when this metric was updated.                                        |

### sys.segment\_batch\_events

This table contains information about segment batches during segment generation.

| Column Name          | Column Type | Column Description                                                         |
| -------------------- | ----------- | -------------------------------------------------------------------------- |
| batch\_id            | UUID        | The Universally Unique IDentifier (UUID) for the batch.                    |
| table\_id            | UUID        | The UUID for the table.                                                    |
| num\_partitions      | BIGINT      | The number of partitions in this batch.                                    |
| bucket\_min          | BIGINT      | The size in bytes of the smallest bucket in this batch.                    |
| bucket\_max          | BIGINT      | The size in bytes of the largest bucket in this batch.                     |
| scope\_id            | UUID        | The UUID for the scope of this batch.                                      |
| batch\_start\_time   | TIMESTAMP   | The start time of the batch analysis.                                      |
| batch\_end\_time     | TIMESTAMP   | The end time of the batch analysis, including completion and partitioning. |
| batch\_flush\_reason | VARCHAR     | The reason for the trigger of this batch analysis.                         |
| size                 | BIGINT      | The total size of this batch, in bytes.                                    |

### sys.segment\_generation\_events

This table contains information about individual segments during segment generation.

| Column Name | Column Type | Column Description                                                       |
| ----------- | ----------- | ------------------------------------------------------------------------ |
| batch\_id   | UUID        | The Universally Unique IDentifier (UUID) for the batch.                  |
| table\_id   | UUID        | The UUID for the table.                                                  |
| ida\_offset | BIGINT      | The index number of the partition in this batch.                         |
| start\_time | TIMESTAMP   | The start time of segment analysis.                                      |
| end\_time   | TIMESTAMP   | The end time of segment analysis, including completion and partitioning. |
| size        | BIGINT      | The total size of this segment, in bytes.                                |
| num\_rows   | BIGINT      | The total number of rows in this segment.                                |

## Machine Learning

### sys.association\_rules\_models

This table contains the name of the snapshot table for an association rules model.

| Column Name                  | Column Type | Column Description                                                                                  |
| ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| num\_arguments               | INT         | Number of arguments in the machine learning model data.                                             |
| table\_name                  | CHAR        | Name of the snapshot table.                                                                         |

### sys.bagging\_models

This table contains all model parameters for Bagging Models in the system.

| Column Name                  | Column Type | Column Description                                                                                  |
| ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| aggregate\_expression        | CHAR        | The vote expression that retrieves information from the child models.                               |
| num\_features                | INT         | Number of arguments in the machine learning model data.                                             |
| num\_children                | INT         | Number of child models used by the bagging model.                                                   |
| correctly\_classified        | DOUBLE      | Percentage of training data that the bagging model correctly classifies.                            |
| area\_under\_roc             | DOUBLE      | Area under the ROC curve of the bagging model.                                                      |
| rmse                         | DOUBLE      | Root mean square error of the regression.                                                           |
| adjusted\_r2                 | DOUBLE      | Adjusted R^2 value of the regression.                                                               |

### sys.boosting\_models

This table contains all model parameters for Boosting Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| expression                   | CHAR          | The SQL expression that defines the boosting model.                                                 |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| learning\_rate               | DOUBLE        | Learning rate.                                                                                      |
| classes                      | ARRAY(CHAR)   | Class names.                                                                                        |
| loss\_function               | CHAR          | Loss function.                                                                                      |
| initial\_predictions         | ARRAY(DOUBLE) | Initial predictions.                                                                                |
| correctly\_classified        | DOUBLE        | Fraction of training data that the model correctly classifies.                                      |
| area\_under\_roc             | DOUBLE        | Area under the ROC curve of the model.                                                              |
| rmse                         | DOUBLE        | Root mean square error of the model.                                                                |
| adjusted\_r2                 | DOUBLE        | Adjusted R^2 of the model.                                                                          |

### sys.decision\_tree\_models

This table contains all model parameters for Decision Tree Models in the system.

| Column Name                  | Column Type | Column Description                                                                                                              |
| ---------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models).                             |
| case\_statement              | CHAR        | The case statement that defines the decision tree.                                                                              |
| case\_statement\_confidence  | CHAR        | The case statement that defines the decision tree and returns confidences.                                                      |
| num\_arguments               | INT         | Number of arguments in the machine learning model data.                                                                         |
| correctly\_classified        | DOUBLE      | Fraction of training data that the decision tree model correctly classifies.                                                    |
| area\_under\_roc             | DOUBLE      | Area under the ROC curve of the decision tree model.                                                                            |
| argument\_types              | ARRAY(CHAR) | Argument type names.                                                                                                            |
| output\_type                 | CHAR        | Output type name.                                                                                                               |
| disable\_jit                 | BOOLEAN     | Determines whether to disable JIT for the decision tree. Set this value to `true` to disable JIT. The default value is `false`. |

### sys.feedforward\_network\_models

This table contains all model parameters for Feedforward Neural Network Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the feedforward network model.                                 |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| average\_loss                | DOUBLE        | Average value of the loss function.                                                                 |

### sys.gaussian\_mixture\_models

This table contains all model parameters for Gaussian Mixture Models.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the Gaussian Mixture Model.                                    |
| num\_distributions           | INT           | Number of distributions in the Gaussian Mixture Model.                                              |
| average\_loss                | DOUBLE        | Average value of the loss function.                                                                 |

### sys.gradient\_boosted\_trees\_models

This table contains all model parameters for Gradient Boosted Trees Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| expression                   | CHAR          | The SQL expression that defines the gradient boosted tree.                                          |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| r2                           | DOUBLE        | Coefficient of determination.                                                                       |
| rmse                         | DOUBLE        | Root mean square error of the model.                                                                |
| adjusted\_r2                 | DOUBLE        | Adjusted R^2 of the model.                                                                          |
| correctly\_classified        | DOUBLE        | Fraction of training data that the gradient boosted trees model correctly classifies.               |
| initial\_predictions         | ARRAY(DOUBLE) | Initial predictions.                                                                                |
| learning\_rate               | DOUBLE        | Learning rate.                                                                                      |
| loss\_function               | CHAR          | Loss function.                                                                                      |
| classes                      | ARRAY(CHAR)   | Class names.                                                                                        |

### sys.k\_means\_models

This table contains all model parameters for K-Means Clustering Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| centroids                    | ARRAY(DOUBLE) | Values that represent the centroid values of each cluster.                                          |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| means                        | ARRAY(DOUBLE) | Means of each of the feature columns in the data.                                                   |
| standard\_deviations         | ARRAY(DOUBLE) | Standard deviations of each of the feature columns in the data.                                     |

### sys.k\_nearest\_neighbors\_models

This table contains the number of arguments and the target table for K-Nearest Neighbors Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| table\_name                  | CHAR          | Name of the target table for the K Nearest Neighbors (KNN) model.                                   |
| correctly\_classified        | DOUBLE        | Percentage of training data that is correctly classified by the KNN model.                          |
| means                        | ARRAY(DOUBLE) | Means of each of the feature columns in the data.                                                   |
| standard\_deviations         | ARRAY(DOUBLE) | Standard deviations of each of the feature columns in the data.                                     |

### sys.linear\_combination\_regression\_models

This table contains all model parameters for Linear Combination Regression Models in the system.

| Column Name                    | Column Type   | Column Description                                                                                  |
| ------------------------------ | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                   | ARRAY(DOUBLE) | List of model coefficients associated with the regression.                                          |
| y\_intercept                   | DOUBLE        | y-intercept of the regression.                                                                      |
| coefficient\_of\_determination | DOUBLE        | R^2 value of the regression, if calculated, otherwise NULL.                                         |
| num\_arguments                 | INT           | Number of arguments in the machine learning model data.                                             |
| rmse                           | DOUBLE        | Root mean square error of the regression.                                                           |
| adjusted\_r2                   | DOUBLE        | Adjusted R^2 value of the regression.                                                               |

### sys.linear\_discriminant\_analysis\_models

This table contains all model parameters for Linear Discriminant Analysis (LDA) Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the LDA model.                                                 |
| num\_features                | INT           | Number of features returned by the LDA model.                                                       |
| importance                   | ARRAY(DOUBLE) | Importance of each of the output features that represent the data.                                  |

### sys.logistic\_regression\_models

This table contains all model parameters for Logistic Regression Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the logistic regression model.                                 |
| correctly\_classified        | DOUBLE        | Percentage of training data that is correctly classified by the logistic regression.                |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| zero\_case                   | CHAR          | The case where the logistic regression uses a value of 0.                                           |
| one\_case                    | CHAR          | The case where the logistic regression uses a value of 1.                                           |
| classes                      | ARRAY(CHAR)   | Target classes for the logistic regression.                                                         |

### sys.machine\_learning\_model\_options

This table contains options defined for each machine learning model. The database stores these options as key-value pairs.

| Column Name                     | Column Type | Column Description                                                  |
| ------------------------------- | ----------- | ------------------------------------------------------------------- |
| machine\_learning\_model\_id    | UUID        | UUID of the machine learning model (sys.machine\_learning\_models). |
| machine\_learning\_model\_key   | CHAR        | Machine learning model configuration option key.                    |
| machine\_learning\_model\_value | CHAR        | Machine learning model configuration option value.                  |

### sys.machine\_learning\_models

This table contains the machine learning models that are defined in the database.

| Column Name                    | Column Type | Column Description                                                                           |
| ------------------------------ | ----------- | -------------------------------------------------------------------------------------------- |
| id                             | UUID        | Universally Unique IDentifier (UUID) of the machine learning model.                          |
| name                           | CHAR        | Name of the machine learning model.                                                          |
| schema                         | CHAR        | Schema of the machine learning model.                                                        |
| machine\_learning\_model\_type | CHAR        | Type of the machine learning model.                                                          |
| database\_id                   | UUID        | UUID of the database that contains the machine learning model definition (sys.databases).    |
| on\_select                     | CHAR        | The SELECT SQL statement used to create this model.                                          |
| creator\_id                    | UUID        | The UUID of the user or group who created the machine learning model (sys.users/sys.groups). |

### sys.multiple\_linear\_regression\_models

This table contains the y-intercept and coefficient of determination values for the multiple linear regression machine learning models.

| Column Name                    | Column Type   | Column Description                                                                                  |
| ------------------------------ | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| y\_intercept                   | DOUBLE        | y-intercept of the regression.                                                                      |
| coefficient\_of\_determination | DOUBLE        | R^2 value of the regression, if calculated, otherwise NULL.                                         |
| rmse                           | DOUBLE        | Root mean square error of the regression.                                                           |
| adjusted\_r2                   | DOUBLE        | Adjusted R^2 value of the regression.                                                               |
| slopes                         | ARRAY(DOUBLE) | Slopes for each variable in the regression.                                                         |

### sys.naive\_bayes\_models

This table contains all model parameters for Naive Bayes Classification Models in the system.

| Column Name                    | Column Type | Column Description                                                                                  |
| ------------------------------ | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| num\_arguments                 | INT         | Number of arguments in the machine learning model data.                                             |
| result\_probability\_table     | CHAR        | Name of the internal result probability table.                                                      |
| feature\_result\_matrix\_table | CHAR        | Name of the internal feature result matrix table.                                                   |
| correctly\_classified          | DOUBLE      | Percentage of training data that is correctly classified by the Naive Bayes model.                  |

### sys.nonlinear\_regression\_models

This table contains all model parameters for Nonlinear Regression Models in the system.

| Column Name                    | Column Type   | Column Description                                                                                  |
| ------------------------------ | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                   | ARRAY(DOUBLE) | List of coefficients associated with the nonlinear regression model.                                |
| coefficient\_of\_determination | DOUBLE        | R^2 value of the regression, if calculated, otherwise NULL.                                         |
| num\_arguments                 | INT           | Number of arguments in the machine learning model data.                                             |
| rmse                           | DOUBLE        | Root mean square error of the regression.                                                           |
| adjusted\_r2                   | DOUBLE        | Adjusted R^2 value of the regression.                                                               |

### sys.polynomial\_regression\_models

This table contains all model parameters for Polynomial Regression Models in the system.

| Column Name                    | Column Type   | Column Description                                                                                  |
| ------------------------------ | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                   | ARRAY(DOUBLE) | List of model coefficients associated with the polynomial regression model.                         |
| y\_intercept                   | DOUBLE        | y-intercept of the regression.                                                                      |
| coefficient\_of\_determination | DOUBLE        | R^2 value of the regression, if calculated, otherwise NULL.                                         |
| num\_arguments                 | INT           | Number of arguments in the machine learning model data.                                             |
| rmse                           | DOUBLE        | Root mean square error of the regression.                                                           |
| adjusted\_r2                   | DOUBLE        | Adjusted R^2 value of the regression.                                                               |

### sys.principal\_component\_analysis\_models

This table contains all model parameters for Principal Component Analysis (PCA) Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the PCA model.                                                 |
| num\_features                | INT           | Number of features returned by the PCA model.                                                       |
| importance                   | ARRAY(DOUBLE) | Importance of each of the output features that represents the data.                                 |
| means                        | ARRAY(DOUBLE) | Means of each of the feature columns in the data.                                                   |
| standard\_deviations         | ARRAY(DOUBLE) | Standard deviations of each of the feature columns in the data.                                     |

### sys.random\_forest\_models

This table contains all model parameters for Random Forest Models in the system.

| Column Name                  | Column Type | Column Description                                                                                    |
| ---------------------------- | ----------- | ----------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models).   |
| vote\_expression             | CHAR        | The vote expression that retrieves information from the child decision trees.                         |
| vote\_expression\_confidence | CHAR        | The vote expression that retrieves information from the child decision trees and returns confidences. |
| num\_arguments               | INT         | Number of arguments in the machine learning model data.                                               |
| num\_children                | INT         | Number of child trees in the forest.                                                                  |
| correctly\_classified        | DOUBLE      | Percentage of training data that the random forest model correctly classifies.                        |
| area\_under\_roc             | DOUBLE      | Area under the ROC curve of the random forest model.                                                  |

### sys.regression\_tree\_models

This table contains all model parameters for Regression Tree Models in the system.

| Column Name                  | Column Type | Column Description                                                                                  |
| ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| case\_statement              | CHAR        | The case statement that defines the regression tree.                                                |
| num\_arguments               | INT         | Number of arguments in the machine learning model data.                                             |
| r2                           | DOUBLE      | Coefficient of determination.                                                                       |
| rmse                         | DOUBLE      | Root mean square error.                                                                             |
| adjusted\_r2                 | DOUBLE      | R^2.                                                                                                |

### sys.simple\_linear\_regression\_models

This table contains the slope, y-intercept, and coefficient of determination values for single linear regression machine learning models.

| Column Name                    | Column Type | Column Description                                                                                  |
| ------------------------------ | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| slope                          | DOUBLE      | Slope of the regression.                                                                            |
| y\_intercept                   | DOUBLE      | The y-intercept of the regression.                                                                  |
| coefficient\_of\_determination | DOUBLE      | R^2 value of the regression, if calculated, otherwise NULL.                                         |
| rmse                           | DOUBLE      | Root mean square error of the regression.                                                           |
| adjusted\_r2                   | DOUBLE      | Adjusted R^2 value of the regression.                                                               |

### sys.stacking\_models

This table contains all model parameters for Stacking Models in the system.

| Column Name                  | Column Type | Column Description                                                                                  |
| ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| num\_arguments               | INT         | Number of arguments in the machine learning model data.                                             |

### sys.support\_vector\_machine\_models

This table contains all model parameters for Support Vector Machine (SVM) Models in the system.

| Column Name                  | Column Type   | Column Description                                                                                  |
| ---------------------------- | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                 | ARRAY(DOUBLE) | List of coefficients associated with the SVM model.                                                 |
| correctly\_classified        | DOUBLE        | Percentage of training data that is correctly classified by the SVM model.                          |
| num\_arguments               | INT           | Number of arguments in the machine learning model data.                                             |
| negative\_case               | CHAR          | Case when the SVM model classifies data as negative.                                                |
| positive\_case               | CHAR          | Case when the SVM model classifies data as positive.                                                |
| classes                      | ARRAY(CHAR)   | Target classes for the SVM model.                                                                   |

### sys.vector\_autoregression\_models

This table contains all model parameters for Vector Autoregression Models in the system.

| Column Name                    | Column Type   | Column Description                                                                                  |
| ------------------------------ | ------------- | --------------------------------------------------------------------------------------------------- |
| machine\_learning\_model\_id   | UUID          | Universally Unique IDentifier (UUID) of the machine learning model (sys.machine\_learning\_models). |
| coefficients                   | ARRAY(DOUBLE) | List of coefficients associated with the vector autoregression model.                               |
| coefficient\_of\_determination | DOUBLE        | R^2 value of the autoregression, if calculated, otherwise NULL.                                     |

## Model Context Protocol

### sys.mcp\_tools

This table contains all of the model context protocol (MCP) tools in the system.

| Column Name           | Column Type    | Column Description                                                               |
| --------------------- | -------------- | -------------------------------------------------------------------------------- |
| id                    | UUID           | Universally Unique IDentifier (UUID) of the MCP tool.                            |
| schema                | CHAR           | Schema of the MCP tool.                                                          |
| name                  | CHAR           | Name of the MCP tool.                                                            |
| argument\_names       | ARRAY(CHAR)    | The argument names of the MCP tool, specified as an array.                       |
| argument\_types       | ARRAY(CHAR)    | The argument types of the MCP tool, specified as an array.                       |
| argument\_nullability | ARRAY(BOOLEAN) | Whether the argument types for the MCP tool are nullable, specified as an array. |
| language              | CHAR           | Programming language of the MCP tool.                                            |
| description           | CHAR           | Description of the MCP tool.                                                     |
| toolset               | CHAR           | Toolset of the MCP tool.                                                         |
| definition            | CHAR           | Function definition of the MCP tool.                                             |
| creator\_id           | UUID           | The UUID of the user or group who created the MCP tool (sys.users/sys.groups).   |
| created\_at           | TIMESTAMP      | The timestamp when this MCP tool was created.                                    |

## Monitoring

### sys.active\_operator\_instances

This table contains information about operator instances that are active in the database.

| Column Name                                         | Column Type | Column Description                                                                                                                                                                                                                                                                                   |
| --------------------------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| database\_name                                      | CHAR        | The name of the database associated with the query to which the operator belongs.                                                                                                                                                                                                                    |
| user\_name                                          | CHAR        | The username associated with the query to which the operator belongs.                                                                                                                                                                                                                                |
| query\_id                                           | UUID        | A unique identifier of the query to which the operator belongs.                                                                                                                                                                                                                                      |
| operator\_id                                        | UUID        | A unique identifier of the finalized operator.                                                                                                                                                                                                                                                       |
| node\_id                                            | UUID        | The unique identifier of the node that stores the information about this operator.                                                                                                                                                                                                                   |
| silo\_id                                            | LONG        | The unique identifier of the silo that stores the information about this operator.                                                                                                                                                                                                                   |
| core\_id                                            | LONG        | The unique identifier of the virtual machine core that stores the information about this operator.                                                                                                                                                                                                   |
| op\_runtime\_id                                     | LONG        | The unique identifier for the operator instance that the system assigns at runtime.                                                                                                                                                                                                                  |
| op\_instance\_type                                  | CHAR        | The name of the type for this operator instance.                                                                                                                                                                                                                                                     |
| bloom\_filtered\_rows                               | LONG        | The rows filtered by Bloom filters.                                                                                                                                                                                                                                                                  |
| rows\_received                                      | LONG        | The number of rows fetched by the operator instance.                                                                                                                                                                                                                                                 |
| rows\_processed                                     | LONG        | The number of rows processed by this operator instance during execution.                                                                                                                                                                                                                             |
| rows\_emitted                                       | LONG        | The number of rows returned by the operator instance.                                                                                                                                                                                                                                                |
| blocks\_emitted                                     | LONG        | The number of data blocks returned by the operator instance.                                                                                                                                                                                                                                         |
| first\_block\_receive\_time                         | TIMESTAMP   | The timestamp that specifies the return of the first data block.                                                                                                                                                                                                                                     |
| first\_block\_emitted\_time                         | TIMESTAMP   | The timestamp that specifies the return of the first data block.                                                                                                                                                                                                                                     |
| num\_cycles                                         | LONG        | The number of cycles that run on this operator instance.                                                                                                                                                                                                                                             |
| num\_oom\_cycles                                    | LONG        | The number of run cycles that an operator received for processing out-of-memory issues.                                                                                                                                                                                                              |
| num\_failed\_oom\_cycles                            | LONG        | The number of out-of-memory cycles received that failed to do any work.                                                                                                                                                                                                                              |
| num\_no\_work\_oom\_cycles                          | LONG        | The number of out-of-memory cycles received that reported they had no work to do.                                                                                                                                                                                                                    |
| run\_count                                          | LONG        | The number of times that the scheduler has reviewed this operator and `isRunnable` is set to `true`.                                                                                                                                                                                                 |
| no\_work\_cycles                                    | LONG        | The number of times that the read and write cycle executed and performed no work.                                                                                                                                                                                                                    |
| backed\_up\_cycles                                  | LONG        | The number of times a cycle stopped because a backup of the parent exists.                                                                                                                                                                                                                           |
| leaf\_branch\_blocked\_cycles                       | LONG        | The number of times a cycle stopped on a leaf operator because of multi-child scheduling heuristics.                                                                                                                                                                                                 |
| num\_eof\_cycles                                    | LONG        | The number of end-of-file cycles received.                                                                                                                                                                                                                                                           |
| normal\_run\_time\_in\_ms                           | DOUBLE      | The time, in milliseconds, of the normal run for the operator instance.                                                                                                                                                                                                                              |
| dispatch\_queue\_time\_in\_ms                       | DOUBLE      | The time spent, in milliseconds, processing incoming message events for the operator instance.                                                                                                                                                                                                       |
| oom\_run\_time\_in\_ms                              | DOUBLE      | The time, in milliseconds, of the out-of-memory issue for the operator instance.                                                                                                                                                                                                                     |
| max\_hp\_mem\_usage                                 | LONG        | The maximum heap memory usage by the operator instance.                                                                                                                                                                                                                                              |
| num\_blocks\_written                                | LONG        | The number of data blocks written to temporary disk.                                                                                                                                                                                                                                                 |
| num\_blocks\_read                                   | LONG        | The number of data blocks read from temporary disk.                                                                                                                                                                                                                                                  |
| num\_fragments\_written                             | LONG        | The number of written memory fragments.                                                                                                                                                                                                                                                              |
| num\_fragments\_read                                | LONG        | The number of read memory fragments.                                                                                                                                                                                                                                                                 |
| cycles\_over\_1\_sec                                | LONG        | The count of cycles that ran over 1 second for this operator instance.                                                                                                                                                                                                                               |
| cycles\_over\_3\_sec                                | LONG        | The count of cycles that ran over 3 seconds for this operator instance.                                                                                                                                                                                                                              |
| long\_dispatch\_queue\_events                       | LONG        | The count of dispatch queue events processed by the operator with a runtime greater than 0.5 seconds.                                                                                                                                                                                                |
| total\_bin\_stream\_allocated\_bytes                | LONG        | The total amount of memory allocated in output blocks for variable-length column data.                                                                                                                                                                                                               |
| total\_bin\_stream\_used\_bytes                     | LONG        | The total amount of memory used in output blocks for variable-length column data.                                                                                                                                                                                                                    |
| total\_col\_stream\_allocated\_bytes                | LONG        | The total amount of memory allocated in output blocks for fixed-length column data.                                                                                                                                                                                                                  |
| total\_col\_stream\_used\_bytes                     | LONG        | The total amount of memory used in output blocks for fixed-length column data.                                                                                                                                                                                                                       |
| blocked\_received                                   | LONG        | The total number of input data blocks received by this operator instance.                                                                                                                                                                                                                            |
| blocked\_created                                    | LONG        | The total number of non-trivial output data blocks created by this operator instance.                                                                                                                                                                                                                |
| received\_block\_bin\_stream\_unused\_space\_bytes  | LONG        | The total amount of wasted space across all binary streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| received\_block\_col\_stream\_unused\_space\_bytes  | LONG        | The total amount of wasted space across all column streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| mandatory\_alloc\_attempts                          | LONG        | The count of cycles where the scheduler enabled mandatory allocation.                                                                                                                                                                                                                                |
| mandatory\_alloc\_success\_count                    | LONG        | The count of cycles where the scheduler enabled mandatory allocation and this operator broke an out-of-memory deadlock.                                                                                                                                                                              |
| max\_num\_pending\_blocks                           | LONG        | The maximum number of pending blocks across all partitions during the lifetime of this operator.                                                                                                                                                                                                     |
| max\_num\_consecutive\_backup\_cycles               | LONG        | The maximum number of consecutive scheduler cycles where this operator has a backup. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                               |
| longest\_time\_since\_unblocked\_cycle              | LONG        | The maximum time between successful attempts to run this operator from the scheduler. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                              |
| compiled\_level                                     | LONG        | The level within a hierarchy of distinct operators to execute. A single plan operator can be compiled into this hierarchy.                                                                                                                                                                           |
| additional\_json                                    | CHAR        | Additional statistics for an operator instance in JSON format.                                                                                                                                                                                                                                       |
| num\_bloom\_filters\_sent                           | LONG        | The number of Bloom filters the operator sent to its peers.                                                                                                                                                                                                                                          |
| num\_bloom\_filters\_received                       | LONG        | The number of Bloom filters the operator received from its peers.                                                                                                                                                                                                                                    |
| num\_key\_lists\_sent                               | LONG        | The number of potential index join key lists the operator sent to its peers.                                                                                                                                                                                                                         |
| num\_key\_lists\_received                           | LONG        | The number of potential index join key lists the operator received from its peers.                                                                                                                                                                                                                   |
| max\_hash\_table\_rows                              | LONG        | The maximum number of rows present in any hash table used by this operator instance.                                                                                                                                                                                                                 |
| plan\_operator\_estimated\_output\_cardinality      | LONG        | The number of rows the optimizer estimated for this plan operator to emit.                                                                                                                                                                                                                           |
| num\_delayed\_exceptions\_generated                 | LONG        | The number of rows this operator generated with delayed exception information.                                                                                                                                                                                                                       |
| num\_pending\_blocks\_spilled                       | LONG        | The number of queued pending data blocks this operator spilled to disk.                                                                                                                                                                                                                              |
| max\_normal\_cycle\_time\_ms                        | DOUBLE      | The time, in milliseconds, of the longest normal run cycle for the operator instance.                                                                                                                                                                                                                |
| max\_oom\_cycle\_time\_ms                           | DOUBLE      | The time, in milliseconds, of the longest out-of-memory run cycle for the operator instance.                                                                                                                                                                                                         |
| num\_rows\_received\_per\_plan\_child               | ARRAY(LONG) | The number of rows this operator received from each of its children in the plan.                                                                                                                                                                                                                     |
| initialization\_time                                | TIMESTAMP   | The timestamp that represents when the operator began work.                                                                                                                                                                                                                                          |
| num\_cycles\_blocked\_by\_temp\_disk                | LONG        | The count of cycles that the operator spent waiting for input and output from the temporary disk.                                                                                                                                                                                                    |
| num\_cycles\_blocked\_by\_external\_pending\_blocks | LONG        | The count of cycles that the operator spent waiting for input and output from external pending blocks.                                                                                                                                                                                               |
| blobstore\_callback\_time\_ms                       | DOUBLE      | The time, in milliseconds, the system spends processing callbacks for temporary disk input and output for the operator instance.                                                                                                                                                                     |
| num\_bounding\_box\_lists\_sent                     | LONG        | The number of geospatial bounding box list filters the operator sent to its peers.                                                                                                                                                                                                                   |
| num\_bounding\_box\_lists\_received                 | LONG        | The number of geospatial bounding box list filters the operator received from its peers.                                                                                                                                                                                                             |
| target\_rows\_per\_cycle                            | LONG        | The number of rows this operator expects to process in a single cycle without exceeding time limits.                                                                                                                                                                                                 |
| applied\_dynamic\_filter\_stats                     | CHAR        | Additional statistics about dynamic pushdown filters in JSON format.                                                                                                                                                                                                                                 |
| is\_runnable                                        | BOOLEAN     | Whether the operator has available data to process.                                                                                                                                                                                                                                                  |
| current\_num\_pending\_blocks                       | LONG        | The current number of pending blocks across all partitions of this operator.                                                                                                                                                                                                                         |

### sys.active\_query\_scheduler\_info

This table contains information about how the scheduler schedules each query to execute within the virtual machine (VM).

| Column Name                                | Column Type | Column Description                                                                                                                                                                                                                                        |
| ------------------------------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| query\_id                                  | UUID        | The Universally Unique IDentifier (UUID) of the query that the scheduler currently schedules to execute.                                                                                                                                                  |
| node\_id                                   | UUID        | The UUID of the node that executes this query.                                                                                                                                                                                                            |
| silo\_id                                   | LONG        | The identifier of the silo that executes this query on its associated node.                                                                                                                                                                               |
| core\_id                                   | LONG        | The identifier of the VM core that executes this query on its associated silo.                                                                                                                                                                            |
| virtual\_runtime                           | DOUBLE      | A unitless fairness metric the scheduler uses to determine the query to schedule next. Comparisons of this value are only meaningful across concurrently executing queries with identical `node_id`, `silo_id`, `core_id`, and `current_priority` values. |
| current\_priority                          | DOUBLE      | The current scheduling priority of this query on its VM core.                                                                                                                                                                                             |
| total\_cycles                              | LONG        | The number of times this VM core has attempted to schedule this query.                                                                                                                                                                                    |
| successful\_cycles                         | LONG        | The number of times this VM core has attempted to schedule this query and completed some amount of work.                                                                                                                                                  |
| no\_work\_cycles                           | LONG        | The number of times this VM core has attempted to schedule this query and no operators were prepared to do work.                                                                                                                                          |
| failed\_cycles                             | LONG        | The number of times this VM core has attempted to schedule this query, some operators attempted to do work, and all operators failed to complete any amount of work.                                                                                      |
| failed\_oom\_cycles                        | LONG        | The number of times this VM core has attempted to schedule this query, some operators attempted to do work, all operators failed to complete any amount of work, and at least one operator on the query has reported that it is out of memory.            |
| num\_greedy\_cycles                        | LONG        | The number of times this VM core has attempted to schedule this query, which is the exclusive highest priority query currently managed by this VM core.                                                                                                   |
| num\_try\_chilled\_ops\_cycles             | LONG        | The number of times this VM core attempted to schedule this query and polled operators that have been marked as `chilled`, meaning they are unlikely to be prepared to do work.                                                                           |
| num\_successful\_try\_chilled\_ops\_cycles | LONG        | The number of times this VM core attempted to schedule this query, polled operators that have been marked 'chilled', and successfully completed some amount of work.                                                                                      |
| total\_op\_inst\_cycle\_time               | DOUBLE      | The approximate total CPU time, in milliseconds, that the operators in this query have been scheduled to execute on this VM core.                                                                                                                         |
| total\_op\_inst\_dispatch\_queue\_time     | DOUBLE      | The approximate total CPU time, in milliseconds, that operators associated with this query have spent processing incoming message events.                                                                                                                 |
| total\_runtime                             | DOUBLE      | The approximate execution time, in milliseconds, that this VM core has managed this query.                                                                                                                                                                |
| total\_bytes\_spilled                      | LONG        | The approximate total temporary disk amount that the VM core uses during query execution.                                                                                                                                                                 |

### sys.all\_operator\_instances

This table contains information about operator instances that have been created by the virtual machine.

| Column Name                                         | Column Type | Column Description                                                                                                                                                                                                                                                                                   |
| --------------------------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| database\_name                                      | VARCHAR     | The name of the database associated with the query to which the operator belongs.                                                                                                                                                                                                                    |
| user\_name                                          | VARCHAR     | The username associated with the query to which the operator belongs.                                                                                                                                                                                                                                |
| query\_id                                           | UUID        | A Universally Unique IDentifier (UUID) of the query to which the operator belongs.                                                                                                                                                                                                                   |
| operator\_id                                        | UUID        | The UUID of the finalized operator.                                                                                                                                                                                                                                                                  |
| node\_id                                            | UUID        | The UUID of the node that stores information about this operator.                                                                                                                                                                                                                                    |
| silo\_id                                            | BIGINT      | The identifier of the silo that stores information about this operator.                                                                                                                                                                                                                              |
| core\_id                                            | BIGINT      | The identifier of the virtual machine core that stores information about this operator.                                                                                                                                                                                                              |
| op\_runtime\_id                                     | BIGINT      | The identifier for the operator instance that the system assigns at runtime.                                                                                                                                                                                                                         |
| op\_instance\_type                                  | VARCHAR     | The name of the type for this operator instance.                                                                                                                                                                                                                                                     |
| bloom\_filtered\_rows                               | BIGINT      | The rows filtered by Bloom filters.                                                                                                                                                                                                                                                                  |
| rows\_received                                      | BIGINT      | The number of rows fetched by the operator instance.                                                                                                                                                                                                                                                 |
| rows\_processed                                     | BIGINT      | The number of rows processed by this operator instance during execution.                                                                                                                                                                                                                             |
| rows\_emitted                                       | BIGINT      | The number of rows returned by the operator instance.                                                                                                                                                                                                                                                |
| blocks\_emitted                                     | BIGINT      | The number of data blocks returned by the operator instance.                                                                                                                                                                                                                                         |
| finalization\_time                                  | TIMESTAMP   | The timestamp that represents when the operator completed all work.                                                                                                                                                                                                                                  |
| first\_block\_receive\_time                         | TIMESTAMP   | The timestamp that specifies the receipt of the first data block.                                                                                                                                                                                                                                    |
| first\_block\_emitted\_time                         | TIMESTAMP   | The timestamp that specifies the return of the first data block.                                                                                                                                                                                                                                     |
| num\_cycles                                         | BIGINT      | The number of cycles that run on this operator instance.                                                                                                                                                                                                                                             |
| num\_oom\_cycles                                    | BIGINT      | The number of run cycles that an operator received for processing out-of-memory issues.                                                                                                                                                                                                              |
| num\_failed\_oom\_cycles                            | BIGINT      | The number of out-of-memory cycles received that failed to do any work.                                                                                                                                                                                                                              |
| num\_no\_work\_oom\_cycles                          | BIGINT      | The number of out-of-memory cycles received with no work to do.                                                                                                                                                                                                                                      |
| run\_count                                          | BIGINT      | The number of times that the scheduler has reviewed this operator and `isRunnable` is set to `true`.                                                                                                                                                                                                 |
| no\_work\_cycles                                    | BIGINT      | The number of times that the read and write cycle executed and performed no work.                                                                                                                                                                                                                    |
| backed\_up\_cycles                                  | BIGINT      | The number of times a cycle stopped because a backup of the parent exists.                                                                                                                                                                                                                           |
| leaf\_branch\_blocked\_cycles                       | BIGINT      | The number of times a cycle stopped on a leaf operator because of multi-child scheduling heuristics.                                                                                                                                                                                                 |
| num\_eof\_cycles                                    | BIGINT      | The number of end-of-file cycles received.                                                                                                                                                                                                                                                           |
| normal\_run\_time\_in\_ms                           | DOUBLE      | The time, in milliseconds, of the normal run for the operator instance.                                                                                                                                                                                                                              |
| dispatch\_queue\_time\_in\_ms                       | DOUBLE      | The time, in milliseconds, spent processing incoming message events for the operator instance.                                                                                                                                                                                                       |
| oom\_run\_time\_in\_ms                              | DOUBLE      | The time, in milliseconds, of the out-of-memory issue for the operator instance.                                                                                                                                                                                                                     |
| max\_hp\_mem\_usage                                 | BIGINT      | The maximum heap memory usage by the operator instance.                                                                                                                                                                                                                                              |
| num\_blocks\_written                                | BIGINT      | The number of data blocks written to temporary disk.                                                                                                                                                                                                                                                 |
| num\_blocks\_read                                   | BIGINT      | The number of data blocks read from temporary disk.                                                                                                                                                                                                                                                  |
| num\_fragments\_written                             | BIGINT      | The number of written memory fragments.                                                                                                                                                                                                                                                              |
| num\_fragments\_read                                | BIGINT      | The number of read memory fragments.                                                                                                                                                                                                                                                                 |
| cycles\_over\_1\_sec                                | BIGINT      | The count of cycles that ran over 1 second for this operator instance.                                                                                                                                                                                                                               |
| cycles\_over\_3\_sec                                | BIGINT      | The count of cycles that ran over 3 seconds for this operator instance.                                                                                                                                                                                                                              |
| long\_dispatch\_queue\_events                       | BIGINT      | The count of dispatch queue events processed by the operator with a runtime greater than 0.5 seconds.                                                                                                                                                                                                |
| total\_bin\_stream\_allocated\_bytes                | BIGINT      | The total amount of memory allocated in output blocks for variable-length column data.                                                                                                                                                                                                               |
| total\_bin\_stream\_used\_bytes                     | BIGINT      | The total amount of memory used in output blocks for variable-length column data.                                                                                                                                                                                                                    |
| total\_col\_stream\_allocated\_bytes                | BIGINT      | The total amount of memory allocated in output blocks for fixed-length column data.                                                                                                                                                                                                                  |
| total\_col\_stream\_used\_bytes                     | BIGINT      | The total amount of memory used in output blocks for fixed-length column data.                                                                                                                                                                                                                       |
| blocked\_received                                   | BIGINT      | The total number of input data blocks received by this operator instance.                                                                                                                                                                                                                            |
| blocked\_created                                    | BIGINT      | The total number of non-trivial output data blocks created by this operator instance.                                                                                                                                                                                                                |
| received\_block\_bin\_stream\_unused\_space\_bytes  | BIGINT      | The total amount of wasted space across all binary streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| received\_block\_col\_stream\_unused\_space\_bytes  | BIGINT      | The total amount of wasted space across all column streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| mandatory\_alloc\_attempts                          | BIGINT      | The count of cycles where the scheduler enabled mandatory allocation.                                                                                                                                                                                                                                |
| mandatory\_alloc\_success\_count                    | BIGINT      | The count of cycles where the scheduler enabled mandatory allocation and this operator broke an out-of-memory deadlock.                                                                                                                                                                              |
| max\_num\_pending\_blocks                           | BIGINT      | The maximum number of pending blocks across all partitions during the lifetime of this operator.                                                                                                                                                                                                     |
| max\_num\_consecutive\_backup\_cycles               | BIGINT      | The maximum number of consecutive scheduler cycles where this operator has a backup. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                               |
| longest\_time\_since\_unblocked\_cycle              | BIGINT      | The maximum time between successful attempts to run this operator from the scheduler. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                              |
| compiled\_level                                     | BIGINT      | The level within a hierarchy of distinct operators to execute. The system can compile a single plan operator into this hierarchy.                                                                                                                                                                    |
| additional\_json                                    | VARCHAR     | Additional statistics for an operator instance in JSON format.                                                                                                                                                                                                                                       |
| num\_bloom\_filters\_sent                           | BIGINT      | The number of Bloom filters the operator sent to its peers.                                                                                                                                                                                                                                          |
| num\_bloom\_filters\_received                       | BIGINT      | The number of Bloom filters the operator received from its peers.                                                                                                                                                                                                                                    |
| num\_key\_lists\_sent                               | BIGINT      | The number of potential index join key lists the operator sent to its peers.                                                                                                                                                                                                                         |
| num\_key\_lists\_received                           | BIGINT      | The number of potential index join key lists the operator received from its peers.                                                                                                                                                                                                                   |
| max\_hash\_table\_rows                              | BIGINT      | The maximum number of rows present in any hash table used by this operator instance.                                                                                                                                                                                                                 |
| plan\_operator\_estimated\_output\_cardinality      | BIGINT      | The number of rows the optimizer estimated for this plan operator to emit.                                                                                                                                                                                                                           |
| num\_delayed\_exceptions\_generated                 | BIGINT      | The number of rows this operator generated with delayed exception information.                                                                                                                                                                                                                       |
| num\_pending\_blocks\_spilled                       | BIGINT      | The number of queued pending data blocks this operator spilled to disk.                                                                                                                                                                                                                              |
| max\_normal\_cycle\_time\_ms                        | DOUBLE      | The time, in milliseconds, of the longest normal run cycle for the operator instance.                                                                                                                                                                                                                |
| max\_oom\_cycle\_time\_ms                           | DOUBLE      | The time, in milliseconds, of the longest out-of-memory run cycle for the operator instance.                                                                                                                                                                                                         |
| num\_rows\_received\_per\_plan\_child               | BIGINT\[]   | The number of rows this operator received from each of its children in the plan.                                                                                                                                                                                                                     |
| initialization\_time                                | TIMESTAMP   | The timestamp that represents when the operator began work.                                                                                                                                                                                                                                          |
| num\_cycles\_blocked\_by\_temp\_disk                | BIGINT      | The count of cycles that the operator spent waiting for input and output from the temporary disk.                                                                                                                                                                                                    |
| num\_cycles\_blocked\_by\_external\_pending\_blocks | BIGINT      | The count of cycles that the operator spent waiting for input and output from external pending blocks.                                                                                                                                                                                               |
| blobstore\_callback\_time\_ms                       | DOUBLE      | The time, in milliseconds, the system spends processing callbacks for temporary disk input and output for the operator instance.                                                                                                                                                                     |
| num\_bounding\_box\_lists\_sent                     | BIGINT      | The number of geospatial bounding box list filters the operator sent to its peers.                                                                                                                                                                                                                   |
| num\_bounding\_box\_lists\_received                 | BIGINT      | The number of geospatial bounding box list filters the operator received from its peers.                                                                                                                                                                                                             |
| target\_rows\_per\_cycle                            | BIGINT      | The number of rows this operator expects to process in a single cycle without exceeding time limits.                                                                                                                                                                                                 |
| applied\_dynamic\_filter\_stats                     | VARCHAR     | Additional statistics about dynamic pushdown filters in JSON format.                                                                                                                                                                                                                                 |
| is\_runnable                                        | BOOLEAN     | Whether the operator has available data to process.                                                                                                                                                                                                                                                  |
| current\_num\_pending\_blocks                       | BIGINT      | The current number of pending blocks across all partitions of this operator.                                                                                                                                                                                                                         |
| is\_active                                          | BOOLEAN     | Whether the operator is currently active or has finalized.                                                                                                                                                                                                                                           |

### sys.completed\_operator\_instances

This table contains information about operator instances that have finalized in the virtual machine.

| Column Name                                         | Column Type | Column Description                                                                                                                                                                                                                                                                                   |
| --------------------------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| database\_name                                      | VARCHAR     | The database associated with the query to which the operator belongs.                                                                                                                                                                                                                                |
| user\_name                                          | VARCHAR     | The user associated with the query to which the operator belongs.                                                                                                                                                                                                                                    |
| query\_id                                           | UUID        | A unique identifier of the query to which the operator belongs.                                                                                                                                                                                                                                      |
| operator\_id                                        | UUID        | A unique identifier of the finalized operator.                                                                                                                                                                                                                                                       |
| node\_id                                            | UUID        | The unique identifier of the node that stores the information about this operator.                                                                                                                                                                                                                   |
| silo\_id                                            | BIGINT      | The unique identifier of the silo that stores the information about this operator.                                                                                                                                                                                                                   |
| core\_id                                            | BIGINT      | The unique identifier of the virtual machine core that stores the information about this operator.                                                                                                                                                                                                   |
| op\_runtime\_id                                     | BIGINT      | The unique identifier for the operator instance that the system assigns at runtime.                                                                                                                                                                                                                  |
| op\_instance\_type                                  | VARCHAR     | The name of the type for this operator instance.                                                                                                                                                                                                                                                     |
| bloom\_filtered\_rows                               | BIGINT      | The rows filtered by Bloom filters.                                                                                                                                                                                                                                                                  |
| rows\_received                                      | BIGINT      | The number of rows fetched by the operator instance.                                                                                                                                                                                                                                                 |
| rows\_processed                                     | BIGINT      | The number of rows processed by this operator instance during execution.                                                                                                                                                                                                                             |
| rows\_emitted                                       | BIGINT      | The number of rows returned by the operator instance.                                                                                                                                                                                                                                                |
| blocks\_emitted                                     | BIGINT      | The number of data blocks returned by the operator instance.                                                                                                                                                                                                                                         |
| finalization\_time                                  | TIMESTAMP   | The timestamp that represents when the operator completed all work.                                                                                                                                                                                                                                  |
| first\_block\_receive\_time                         | TIMESTAMP   | The timestamp that specifies the receipt of the first data block.                                                                                                                                                                                                                                    |
| first\_block\_emitted\_time                         | TIMESTAMP   | The timestamp that specifies the return of the first data block.                                                                                                                                                                                                                                     |
| num\_cycles                                         | BIGINT      | The number of cycles that run on this operator instance.                                                                                                                                                                                                                                             |
| num\_oom\_cycles                                    | BIGINT      | The number of run cycles that an operator received for processing out-of-memory issues.                                                                                                                                                                                                              |
| num\_failed\_oom\_cycles                            | BIGINT      | The number of out-of-memory cycles received that failed to do any work.                                                                                                                                                                                                                              |
| num\_no\_work\_oom\_cycles                          | BIGINT      | The number of out-of-memory cycles received that reported they had no work to do.                                                                                                                                                                                                                    |
| run\_count                                          | BIGINT      | The number of times that the scheduler has reviewed this operator and `isRunnable` is set to `true`.                                                                                                                                                                                                 |
| no\_work\_cycles                                    | BIGINT      | The number of times that the read and write cycle executed and performed no work.                                                                                                                                                                                                                    |
| backed\_up\_cycles                                  | BIGINT      | The number of times a cycle stopped because a backup of the parent exists.                                                                                                                                                                                                                           |
| leaf\_branch\_blocked\_cycles                       | BIGINT      | The number of times a cycle stopped on a leaf operator because of multi-child scheduling heuristics.                                                                                                                                                                                                 |
| num\_eof\_cycles                                    | BIGINT      | The number of end-of-file cycles received.                                                                                                                                                                                                                                                           |
| normal\_run\_time\_in\_ms                           | DOUBLE      | The time, in milliseconds, of the normal run for the operator instance.                                                                                                                                                                                                                              |
| dispatch\_queue\_time\_in\_ms                       | DOUBLE      | The time spent, in milliseconds, processing incoming message events for the operator instance.                                                                                                                                                                                                       |
| oom\_run\_time\_in\_ms                              | DOUBLE      | The time, in milliseconds, of the out-of-memory issue for the operator instance.                                                                                                                                                                                                                     |
| max\_hp\_mem\_usage                                 | BIGINT      | The maximum heap memory usage by the operator instance.                                                                                                                                                                                                                                              |
| num\_blocks\_written                                | BIGINT      | The number of data blocks written to temporary disk.                                                                                                                                                                                                                                                 |
| num\_blocks\_read                                   | BIGINT      | The number of data blocks read from temporary disk.                                                                                                                                                                                                                                                  |
| num\_fragments\_written                             | BIGINT      | The number of written memory fragments.                                                                                                                                                                                                                                                              |
| num\_fragments\_read                                | BIGINT      | The number of read memory fragments.                                                                                                                                                                                                                                                                 |
| cycles\_over\_1\_sec                                | BIGINT      | The count of cycles that ran over 1 second for this operator instance.                                                                                                                                                                                                                               |
| cycles\_over\_3\_sec                                | BIGINT      | The count of cycles that ran over 3 seconds for this operator instance.                                                                                                                                                                                                                              |
| long\_dispatch\_queue\_events                       | BIGINT      | The count of dispatch queue events processed by the operator with a runtime greater than 0.5 seconds.                                                                                                                                                                                                |
| total\_bin\_stream\_allocated\_bytes                | BIGINT      | The total amount of memory allocated in output blocks for variable-length column data.                                                                                                                                                                                                               |
| total\_bin\_stream\_used\_bytes                     | BIGINT      | The total amount of memory used in output blocks for variable-length column data.                                                                                                                                                                                                                    |
| total\_col\_stream\_allocated\_bytes                | BIGINT      | The total amount of memory allocated in output blocks for fixed-length column data.                                                                                                                                                                                                                  |
| total\_col\_stream\_used\_bytes                     | BIGINT      | The total amount of memory used in output blocks for fixed-length column data.                                                                                                                                                                                                                       |
| blocked\_received                                   | BIGINT      | The total number of input data blocks received by this operator instance.                                                                                                                                                                                                                            |
| blocked\_created                                    | BIGINT      | The total number of non-trivial output data blocks created by this operator instance.                                                                                                                                                                                                                |
| received\_block\_bin\_stream\_unused\_space\_bytes  | BIGINT      | The total amount of wasted space across all binary streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| received\_block\_col\_stream\_unused\_space\_bytes  | BIGINT      | The total amount of wasted space across all column streams in received data blocks (includes over-allocations as well as projected columns and dead memory). This number is NULL unless configuration parameters allow recording this statistic for each block because the calculation is expensive. |
| mandatory\_alloc\_attempts                          | BIGINT      | The count of cycles where the scheduler enabled mandatory allocation.                                                                                                                                                                                                                                |
| mandatory\_alloc\_success\_count                    | BIGINT      | The count of cycles where the scheduler enabled mandatory allocation and this operator broke an out-of-memory deadlock.                                                                                                                                                                              |
| max\_num\_pending\_blocks                           | BIGINT      | The maximum number of pending blocks across all partitions during the lifetime of this operator.                                                                                                                                                                                                     |
| max\_num\_consecutive\_backup\_cycles               | BIGINT      | The maximum number of consecutive scheduler cycles where this operator has a backup. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                               |
| longest\_time\_since\_unblocked\_cycle              | BIGINT      | The maximum time between successful attempts to run this operator from the scheduler. The scheduler can use this information to help detect certain resource deadlocks.                                                                                                                              |
| compiled\_level                                     | BIGINT      | The level within a hierarchy of distinct operators to execute. A single plan operator can be compiled into this hierarchy.                                                                                                                                                                           |
| additional\_json                                    | VARCHAR     | Additional statistics for an operator instance in JSON format.                                                                                                                                                                                                                                       |
| num\_bloom\_filters\_sent                           | BIGINT      | The number of Bloom filters the operator sent to its peers.                                                                                                                                                                                                                                          |
| num\_bloom\_filters\_received                       | BIGINT      | The number of Bloom filters the operator received from its peers.                                                                                                                                                                                                                                    |
| num\_key\_lists\_sent                               | BIGINT      | The number of potential index join key lists the operator sent to its peers.                                                                                                                                                                                                                         |
| num\_key\_lists\_received                           | BIGINT      | The number of potential index join key lists the operator received from its peers.                                                                                                                                                                                                                   |
| max\_hash\_table\_rows                              | BIGINT      | The maximum number of rows present in any hash table used by this operator instance.                                                                                                                                                                                                                 |
| plan\_operator\_estimated\_output\_cardinality      | BIGINT      | The number of rows the optimizer estimated for this plan operator to emit.                                                                                                                                                                                                                           |
| num\_delayed\_exceptions\_generated                 | BIGINT      | The number of rows this operator generated with delayed exception information.                                                                                                                                                                                                                       |
| num\_pending\_blocks\_spilled                       | BIGINT      | The number of queued pending data blocks this operator spilled to disk.                                                                                                                                                                                                                              |
| max\_normal\_cycle\_time\_ms                        | DOUBLE      | The time, in milliseconds, of the longest normal run cycle for the operator instance.                                                                                                                                                                                                                |
| max\_oom\_cycle\_time\_ms                           | DOUBLE      | The time, in milliseconds, of the longest out-of-memory run cycle for the operator instance.                                                                                                                                                                                                         |
| num\_rows\_received\_per\_plan\_child               | BIGINT\[]   | The number of rows this operator received from each of its children in the plan.                                                                                                                                                                                                                     |
| initialization\_time                                | TIMESTAMP   | The timestamp that represents when the operator began work.                                                                                                                                                                                                                                          |
| num\_cycles\_blocked\_by\_temp\_disk                | BIGINT      | The count of cycles that the operator spent waiting for input and output from the temporary disk.                                                                                                                                                                                                    |
| num\_cycles\_blocked\_by\_external\_pending\_blocks | BIGINT      | The count of cycles that the operator spent waiting for input and output from external pending blocks.                                                                                                                                                                                               |
| blobstore\_callback\_time\_ms                       | DOUBLE      | The time, in milliseconds, the system spends processing callbacks for temporary disk input and output for the operator instance.                                                                                                                                                                     |
| num\_bounding\_box\_lists\_sent                     | BIGINT      | The number of geospatial bounding box list filters the operator sent to its peers.                                                                                                                                                                                                                   |
| num\_bounding\_box\_lists\_received                 | BIGINT      | The number of geospatial bounding box list filters the operator received from its peers.                                                                                                                                                                                                             |
| target\_rows\_per\_cycle                            | BIGINT      | The number of rows this operator expects to process in a single cycle without exceeding time limits.                                                                                                                                                                                                 |
| applied\_dynamic\_filter\_stats                     | VARCHAR     | Additional statistics about dynamic pushdown filters in JSON format.                                                                                                                                                                                                                                 |

### sys.completed\_queries

This table contains information about queries that finished execution in the database.

| Column Name                                         | Column Type | Column Description                                                                                                                                                                                                                                                                                  |
| --------------------------------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| query\_id                                           | UUID        | A unique identifier of the query that ran.                                                                                                                                                                                                                                                          |
| user                                                | VARCHAR     | The name of the user that executed the query.                                                                                                                                                                                                                                                       |
| database\_name                                      | VARCHAR     | The name of the database that runs this query.                                                                                                                                                                                                                                                      |
| database\_id                                        | UUID        | The unique identifier of the database this query ran in.                                                                                                                                                                                                                                            |
| sql                                                 | VARCHAR     | The executed SQL statement.                                                                                                                                                                                                                                                                         |
| sql\_text\_length                                   | BIGINT      | The length of the SQL statement.                                                                                                                                                                                                                                                                    |
| referenced\_tables                                  | VARCHAR\[]  | The tables and views referenced by the query.                                                                                                                                                                                                                                                       |
| total\_time                                         | BIGINT      | The total time in milliseconds the query took to run. This time includes generation\_time, optimization\_time, and execution\_time.                                                                                                                                                                 |
| generation\_time                                    | BIGINT      | The time in milliseconds it took to generate the query before any processing happened.                                                                                                                                                                                                              |
| optimization\_time                                  | BIGINT      | The time in milliseconds the optimizer processed the query and built an optimized plan for the query.                                                                                                                                                                                               |
| execution\_time                                     | BIGINT      | Time in milliseconds the query was executed by the database on the LTS nodes to return the query result.                                                                                                                                                                                            |
| timestamp\_start                                    | TIMESTAMP   | A timestamp that represents the point in time when the query entered the system.                                                                                                                                                                                                                    |
| parsing\_time                                       | BIGINT      | The time in milliseconds the query was parsing.                                                                                                                                                                                                                                                     |
| cache\_lookup\_time                                 | BIGINT      | The time in milliseconds the query spent in lookup up matching cached result sets.                                                                                                                                                                                                                  |
| validation\_time                                    | BIGINT      | The time in milliseconds the query was validating.                                                                                                                                                                                                                                                  |
| plangen\_time                                       | BIGINT      | The time in milliseconds the query plan was being generated.                                                                                                                                                                                                                                        |
| queue\_time                                         | BIGINT      | The time in milliseconds the query was queued in the system before any processing happened.                                                                                                                                                                                                         |
| timestamp\_optimization\_start                      | TIMESTAMP   | A timestamp that represents the point in time when optimization of the query started.                                                                                                                                                                                                               |
| timestamp\_execution\_start                         | TIMESTAMP   | A timestamp that represents the point in time when execution of the query started.                                                                                                                                                                                                                  |
| tree\_probe\_time                                   | BIGINT      | The time in milliseconds taken by the VM tree probe during query execution.                                                                                                                                                                                                                         |
| vm\_initialization\_time                            | BIGINT      | Time in milliseconds the query was initializing on all participating nodes during execution.                                                                                                                                                                                                        |
| timestamp\_first\_byte\_sent                        | TIMESTAMP   | A timestamp that represents the point in time when the first byte of the result set from the query was returned to the application.                                                                                                                                                                 |
| timestamp\_complete                                 | TIMESTAMP   | A timestamp that represents the point in time when the execution of the query completed from the client's perspective.                                                                                                                                                                              |
| timestamp\_execution\_complete                      | TIMESTAMP   | A timestamp that represents the point in time when the internal execution of the query completed.                                                                                                                                                                                                   |
| awaiting\_client\_eof\_fetch\_time                  | BIGINT      | Time in milliseconds that represents the difference between when the client fetched the eof for the query and when the eof was queued internally.                                                                                                                                                   |
| rows\_returned                                      | BIGINT      | The number of rows returned by the query.                                                                                                                                                                                                                                                           |
| bytes\_returned                                     | BIGINT      | The number of bytes returned by the query.                                                                                                                                                                                                                                                          |
| rows\_inserted                                      | BIGINT      | The number of rows that the query inserts. This value is NULL when the database does not insert any rows. The value is 0 when the database does not identify any rows to insert from a `CREATE TABLE AS SELECT` or `INSERT AS SELECT` SQL statement.                                                |
| rows\_deleted                                       | BIGINT      | The number of rows that the query deletes. This value is NULL when the database does not delete any rows. The value is 0 when the database does not identify any rows to delete from a `DELETE FROM TABLE` SQL statement.                                                                           |
| update\_subquery\_execution\_time                   | BIGINT      | The time in milliseconds taken by the virtual machine (VM) to execute a subquery that identifies the rows for insertion or deletion. This value is NULL when you execute a SQL statement that is not one of these statements: `CREATE TABLE AS SELECT`, `INSERT AS SELECT`, or `DELETE FROM TABLE`. |
| transferred\_bytes\_per\_second                     | BIGINT      | The transfer rate in bytes per second for the result set of the query.                                                                                                                                                                                                                              |
| code                                                | INT         | The SQL code returned at the end of the query.                                                                                                                                                                                                                                                      |
| state                                               | VARCHAR     | The SQL state returned at the end of the query.                                                                                                                                                                                                                                                     |
| reason                                              | VARCHAR     | A message associated with the SQL code and SQL state.                                                                                                                                                                                                                                               |
| initial\_priority                                   | DOUBLE      | Priority based on the service class, session, and query-level limits.                                                                                                                                                                                                                               |
| initial\_effective\_priority                        | DOUBLE      | initial\_priority adjusted for total cost and memory usage.                                                                                                                                                                                                                                         |
| final\_effective\_priority                          | DOUBLE      | Final dynamically adjusted priority.                                                                                                                                                                                                                                                                |
| cost\_estimate                                      | DOUBLE      | The cost estimate of the optimizer.                                                                                                                                                                                                                                                                 |
| concurrency\_service\_class\_name                   | VARCHAR     | Name of the service class this query executes in.                                                                                                                                                                                                                                                   |
| concurrency\_service\_class\_id                     | UUID        | The unique identifier of the service class used for the query.                                                                                                                                                                                                                                      |
| priority\_adjust\_factor                            | DOUBLE      | The percentage amount by which the database adjusts the priority.                                                                                                                                                                                                                                   |
| priority\_adjust\_time                              | INT         | How frequently the database adjusts the priority during query execution.                                                                                                                                                                                                                            |
| cached\_query                                       | BOOLEAN     | Flag that indicates whether the result was returned from the result set cache.                                                                                                                                                                                                                      |
| resultset\_cached                                   | BOOLEAN     | Flag that indicates whether the result of the query was stored in the result set cache.                                                                                                                                                                                                             |
| temp\_disk\_consumed                                | BIGINT      | The approximate total temporary disk usage, in bytes, during query execution.                                                                                                                                                                                                                       |
| protocol\_version                                   | VARCHAR     | The version of the client-server protocol for this connection.                                                                                                                                                                                                                                      |
| client\_ip                                          | VARCHAR     | The IP address of the client that executed the query.                                                                                                                                                                                                                                               |
| client\_name                                        | VARCHAR     | The name of the client that executed the query.                                                                                                                                                                                                                                                     |
| client\_session\_id                                 | VARCHAR     | The session id of the client that executed the query.                                                                                                                                                                                                                                               |
| num\_client\_threads                                | INT         | The maximum number of client threads determined by the server.                                                                                                                                                                                                                                      |
| node\_id                                            | UUID        | The unique identifier of the node that stores the information about this query.                                                                                                                                                                                                                     |
| participating\_nodes                                | VARCHAR\[]  | The nodes that participated in the execution of this query.                                                                                                                                                                                                                                         |
| ocient\_db\_version                                 | VARCHAR     | The Ocient database version used to run this query.                                                                                                                                                                                                                                                 |
| ocient\_db\_commit                                  | VARCHAR     | The Ocient database git commit used to run this query.                                                                                                                                                                                                                                              |
| ocient\_db\_dirtied\_commit                         | VARCHAR     | The dirtied Ocient database git commit used to run this query.                                                                                                                                                                                                                                      |
| max\_temp\_disk\_usage                              | INT         | The maximum temporary disk usage for this query, expressed as a percentage.                                                                                                                                                                                                                         |
| max\_elapsed\_time                                  | INT         | The maximum elapsed time for this query, in seconds.                                                                                                                                                                                                                                                |
| max\_rows\_returned                                 | BIGINT      | The maximum number of rows this query can return.                                                                                                                                                                                                                                                   |
| num\_root\_operator\_instances                      | INT         | The number of created root operator instances.                                                                                                                                                                                                                                                      |
| approx\_system\_peak\_vm\_node\_heap\_mem\_bytes    | BIGINT      | The max observed heap memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.                                                                                                                                                  |
| approx\_system\_peak\_vm\_cluster\_heap\_mem\_bytes | BIGINT      | The max observed heap memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.                                                                                                                                          |
| approx\_system\_peak\_vm\_node\_huge\_mem\_bytes    | BIGINT      | The max observed huge page memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.                                                                                                                                             |
| approx\_system\_peak\_vm\_cluster\_huge\_mem\_bytes | BIGINT      | The max observed huge page memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.                                                                                                                                     |
| approx\_system\_peak\_sql\_node\_heap\_mem\_bytes   | BIGINT      | The max observed heap memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.                                                                                                                                                              |
| approx\_system\_peak\_sql\_node\_huge\_mem\_bytes   | BIGINT      | The max observed huge page memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.                                                                                                                                                         |
| driver\_version                                     | VARCHAR     | The version of the client driver.                                                                                                                                                                                                                                                                   |
| join\_order\_optimization\_time                     | BIGINT      | The time, in milliseconds, the join order of the query was optimized.                                                                                                                                                                                                                               |
| join\_order\_optimization\_algorithm                | VARCHAR     | The algorithm used for optimizing the join order of the query.                                                                                                                                                                                                                                      |
| tags                                                | VARCHAR\[]  | The list of tags specified for the query.                                                                                                                                                                                                                                                           |
| default\_schema                                     | VARCHAR     | The default schema associated with the client that executed the query.                                                                                                                                                                                                                              |

### sys.metric\_levels

This table contains settings for metric levels.

| Column Name | Column Type | Column Description                                                                               |
| ----------- | ----------- | ------------------------------------------------------------------------------------------------ |
| match       | CHAR        | Metric name match.                                                                               |
| match\_type | CHAR        | The type of match for the name of the metric.                                                    |
| level       | CHAR        | Metric level.                                                                                    |
| node\_id    | UUID        | The unique node identifier for this setting. This setting might be NULL for system-wide metrics. |

### sys.node\_status

This table contains the status of nodes in the system and the core node monitoring metrics.

| Column Name         | Column Type | Column Description                                                                                                     |
| ------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------- |
| node\_id            | UUID        | The Universally Unique IDentifier (UUID) of the node.                                                                  |
| operational\_status | CHAR        | The operational status of the node. Values are ACTIVE, STARTING, STOPPING, ERROR, UNKNOWN, or UNREACHABLE.             |
| loadavg\_1          | DOUBLE      | Average load on the node over the last 1 minute. Represents the average number of processes in the system run queue.   |
| loadavg\_5          | DOUBLE      | Average load on the node over the last 5 minutes. Represents the average number of processes in the system run queue.  |
| loadavg\_15         | DOUBLE      | Average load on the node over the last 15 minutes. Represents the average number of processes in the system run queue. |
| max\_rss            | LONG        | Maximum resident set size (RSS) of the process on the node in bytes.                                                   |
| heap                | LONG        | Heap memory allocated on the node in bytes.                                                                            |
| software\_start     | TIMESTAMP   | Timestamp for the last start of the Ocient software on the node.                                                       |
| system\_start       | TIMESTAMP   | Timestamp for the last start of the node hardware.                                                                     |

### sys.op\_inst\_debug\_info

This table contains information about the debug information for the operator instance.

| Column Name    | Column Type | Column Description                                                                                 |
| -------------- | ----------- | -------------------------------------------------------------------------------------------------- |
| operator\_id   | UUID        | The Universally Unique IDentifier (UUID) of the operator                                           |
| node\_id       | UUID        | The unique identifier of the node that stores the information about this operator.                 |
| silo\_id       | LONG        | The unique identifier of the silo that stores the information about this operator.                 |
| vm\_core\_id   | LONG        | The unique identifier of the virtual machine core that stores the information about this operator. |
| runtime\_id    | INT         | The process-wide unique identifier of this operator instance.                                      |
| key            | CHAR        | The debug information (debugInfo) key.                                                             |
| value          | CHAR        | The debugInfo value.                                                                               |
| op\_inst\_type | CHAR        | Type of the operator Instance.                                                                     |
| query\_id      | UUID        | The UUID of the query that owns the operator.                                                      |

### sys.osn\_acquisitions

This table contains information about client identifiers for Ownership Storage Number (OSN) acquisitions.

| Column Name       | Column Type | Column Description                                    |
| ----------------- | ----------- | ----------------------------------------------------- |
| node\_id          | UUID        | The Universally Unique IDentifier (UUID) of the node. |
| client\_id        | UUID        | The query identifier of the OSN acquisition.          |
| osn               | LONG        | The locked OSN.                                       |
| acquisition\_time | TIMESTAMP   | Timestamp that represents when the OSN was acquired.  |

### sys.plans

This table contains information about the plan for each SQL statement. Not all SQL statements have a corresponding plan (e.g., some DDL statements, SQL statements that have failed parsing or optimization).

| Column Name      | Column Type | Column Description                                                               |
| ---------------- | ----------- | -------------------------------------------------------------------------------- |
| query\_id        | UUID        | The unique identifier of the SQL query that executed.                            |
| user             | VARCHAR     | The name of the user that executed the SQL query.                                |
| database\_name   | VARCHAR     | The name of the database that executes this SQL query.                           |
| timestamp\_start | TIMESTAMP   | A timestamp that represents the point in time when the query entered the system. |
| plan             | VARCHAR     | The plan for the SQL query.                                                      |

### sys.queries

This table contains information about queries that the database is currently executing.

| Column Name                                         | Column Type | Column Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| --------------------------------------------------- | ----------- |   |
| query\_id                                           | UUID        | A unique identifier of the query that is currently running.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| user                                                | CHAR        | The name of the user that executes the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| database\_name                                      | CHAR        | The name of the database that runs this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| database\_id                                        | UUID        | A unique identifier of the database this query is running in.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| status                                              | CHAR        | The statuses represent how the virtual machine (VM) tracks a specific query. The statuses are: AWAITING\_SLOT (The query waits for a service class slot for optimization or execution.), OPTIMIZING (The Ocient System optimizes the query. If the system cannot optimize the query, the query skips this status and changes to the QUEUED status.), QUEUED (The system initializes the query in the VM.), RUNNING (The system executes the query in the VM, either by compiling the result from the Foundation Nodes or by fetching the results from the cache.), and FINALIZING (The query is complete.). |
| sql                                                 | CHAR        | The SQL statement that is executing.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| sql\_text\_length                                   | LONG        | The length of the SQL statement.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| referenced\_tables                                  | ARRAY(CHAR) | The tables and views referenced by the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| total\_time                                         | LONG        | The total time in milliseconds the query has run. This time includes generation\_time, optimization\_time, and execution\_time.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| generation\_time                                    | LONG        | The time in milliseconds the query was generated or is still generating. This number might increase if generation is in progress.                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| optimization\_time                                  | LONG        | The time in milliseconds the optimizer processed or is still processing the query. This number might be 0 if optimization of the query has not started yet. This number might increase if optimization is in progress.                                                                                                                                                                                                                                                                                                                                                                                      |
| execution\_time                                     | LONG        | Time in milliseconds the query executes. This number might be 0 if execution of the query has not started yet. This number might increase if execution of the query is still in progress.                                                                                                                                                                                                                                                                                                                                                                                                                   |
| timestamp\_start                                    | TIMESTAMP   | A timestamp that represents the point in time when the query entered the system.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| parsing\_time                                       | LONG        | Time in milliseconds the query was parsing or is still parsing. This number might be 0 if parsing of the query has not started yet. This number might increase if the query is still parsing.                                                                                                                                                                                                                                                                                                                                                                                                               |
| cache\_lookup\_time                                 | LONG        | The time in milliseconds the query spent in lookup up matching cached result sets.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| validation\_time                                    | LONG        | Time in milliseconds the query was validating or is still being validated. This number might be 0 if validation of the query has not started yet. This number might increase if the query is still validating.                                                                                                                                                                                                                                                                                                                                                                                              |
| plangen\_time                                       | LONG        | Time in milliseconds the query plan was being generated or is still generating. This number might be 0 if generation of the query plan has not started yet. This number might increase if the query plan is still generating.                                                                                                                                                                                                                                                                                                                                                                               |
| queue\_time                                         | LONG        | Time in milliseconds the query was queued or is still queuing. This number might be 0 if queuing of the query has not started yet. This number might increase if the query is still in the queue.                                                                                                                                                                                                                                                                                                                                                                                                           |
| timestamp\_optimization\_start                      | TIMESTAMP   | A timestamp that represents the point in time when optimization of the query started. This value might be 0 if optimization has not started yet.                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| timestamp\_execution\_start                         | TIMESTAMP   | A timestamp that represents the point in time when execution of the query started. This value might be 0 if execution has not started yet.                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| tree\_probe\_time                                   | LONG        | Time in milliseconds the query was in the VM tree probe stage during execution. This number might be 0 if VM tree probe has not started yet. This number might increase if the probe is still happening.                                                                                                                                                                                                                                                                                                                                                                                                    |
| vm\_initialization\_time                            | LONG        | Time in milliseconds the query was initializing on all participating nodes during execution. This number might be 0 if the VM has not begin initializing the query for execution yet.                                                                                                                                                                                                                                                                                                                                                                                                                       |
| timestamp\_first\_byte\_sent                        | TIMESTAMP   | A timestamp that represents the point in time when the first byte of the result set from the query was returned to the application. This value might be 0 if execution of the query has not started yet or no bytes have been transferred yet.                                                                                                                                                                                                                                                                                                                                                              |
| rows\_returned                                      | LONG        | The number of rows returned by the query. This value might be 0 if no rows have been transferred so far.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| bytes\_returned                                     | LONG        | The number of bytes returned by the query. This value might be 0 if no rows have been transferred so far.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| rows\_inserted                                      | LONG        | The number of rows that the query inserts. This value is NULL when the database does not insert any rows. The value is 0 when the database does not identify any rows to insert from a `CREATE TABLE AS SELECT` or `INSERT AS SELECT` SQL statement.                                                                                                                                                                                                                                                                                                                                                        |
| rows\_deleted                                       | LONG        | The number of rows that the query deletes. This value is NULL when the database does not delete any rows. The value is 0 when the database does not identify any rows to delete from a `DELETE FROM TABLE` SQL statement.                                                                                                                                                                                                                                                                                                                                                                                   |
| update\_subquery\_execution\_time                   | LONG        | The time in milliseconds taken by the VM to execute a subquery that identifies the rows for insertion and deletion. This value is NULL when you execute a SQL statement that is not one of these statements: `CREATE TABLE AS SELECT`, `INSERT AS SELECT`, or `DELETE FROM TABLE`.                                                                                                                                                                                                                                                                                                                          |
| initial\_priority                                   | DOUBLE      | Priority based on the service class, session, and query level limits.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| initial\_effective\_priority                        | DOUBLE      | initial\_priority adjusted for total cost and memory usage.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| effective\_priority                                 | DOUBLE      | Current dynamically adjusted priority.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| estimated\_time                                     | INT         | The estimate of the optimizer for the time in milliseconds to process the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| estimated\_result\_rows                             | LONG        | The estimate of the optimizer for the number of rows in the result set.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| estimated\_result\_size                             | LONG        | The estimate of the optimizer for the size of the result set in bytes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| concurrency\_service\_class\_name                   | CHAR        | Name of the service class this query executes in.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| concurrency\_service\_class\_id                     | UUID        | The unique identifier of the service class used for the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| priority\_adjust\_factor                            | DOUBLE      | The percentage amount by which the database adjusts the priority.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| priority\_adjust\_time                              | INT         | How frequently the database adjusts the priority during query execution.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| cached\_query                                       | BOOLEAN     | Flag that indicates whether the result is returned from the result set cache.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| temp\_disk\_consumed                                | LONG        | The approximate total temporary disk usage, in bytes, during query execution.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| server\_ip                                          | IPV4        | The IP address of the SQL node that executed the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| protocol\_version                                   | CHAR        | The version of the client-server protocol for this connection.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| driver\_version                                     | CHAR        | The version of the client driver.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| client\_ip                                          | CHAR        | The IP address of the client that executed the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| client\_name                                        | CHAR        | The name of the client that executed the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| client\_session\_id                                 | CHAR        | The session id of the client that executed the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| num\_client\_threads                                | INT         | The maximum number of client threads determined by the server.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| node\_id                                            | UUID        | The unique identifier of the node that provided the information about this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| participating\_nodes                                | ARRAY(CHAR) | The nodes that are currently known to be participating in the execution of this query. If the query is not in the RUNNING state, this list might not include all nodes that participate.                                                                                                                                                                                                                                                                                                                                                                                                                    |
| max\_temp\_disk\_usage                              | INT         | The maximum temporary disk usage for this query, expressed as a percentage.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| max\_elapsed\_time                                  | INT         | The maximum elapsed time for this query, in seconds.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| max\_rows\_returned                                 | LONG        | The maximum number of rows this query can return.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| num\_root\_operator\_instances                      | INT         | The number of created root operator instances.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| approx\_system\_peak\_vm\_node\_heap\_mem\_bytes    | LONG        | The max observed heap memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| approx\_system\_peak\_vm\_cluster\_heap\_mem\_bytes | LONG        | The max observed heap memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| approx\_system\_peak\_vm\_node\_huge\_mem\_bytes    | LONG        | The max observed huge page memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| approx\_system\_peak\_vm\_cluster\_huge\_mem\_bytes | LONG        | The max observed huge page memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| approx\_system\_peak\_sql\_node\_heap\_mem\_bytes   | LONG        | The max observed heap memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| approx\_system\_peak\_sql\_node\_huge\_mem\_bytes   | LONG        | The max observed huge page memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| join\_order\_optimization\_time                     | LONG        | The time, in milliseconds, the join order of the query was optimized.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| join\_order\_optimization\_algorithm                | CHAR        | The algorithm used for optimizing the join order of the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| tags                                                | ARRAY(CHAR) | The list of tags specified for the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| default\_schema                                     | CHAR        | The default schema associated with the client that executed the query.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |

### sys.result\_cache

This table contains queries that have cached results in the system.

| Column Name        | Column Type | Column Description                                                                   |
| ------------------ | ----------- | ------------------------------------------------------------------------------------ |
| node\_id           | UUID        | The Universally Unique IDentifier (UUID) of the node that holds the cache results.   |
| query\_id          | UUID        | The UUID of the query.                                                               |
| database\_id       | UUID        | The database of the query.                                                           |
| service\_class\_id | UUID        | The UUID of the service class of the query.                                          |
| timestamp          | LONG        | The timestamp in seconds after the UNIX epoch when the result set entered the cache. |
| time               | CHAR        | The human-readable time when the result set entered the cache.                       |
| time\_remaining    | LONG        | The amount of time remaining in seconds before the cached result set expires.        |
| referenced\_tables | ARRAY(CHAR) | All referenced tables in this query.                                                 |

### sys.retention\_policies

The `retention_policies` table shows the tables that have a retention policy enabled in the system.

| Column Name         | Column Type | Column Description                                     |
| ------------------- | ----------- | ------------------------------------------------------ |
| table\_id           | UUID        | The Universally Unique IDentifier (UUID) of the table. |
| retention\_interval | VARCHAR     | The retention interval for the retention policy.       |
| execution\_interval | VARCHAR     | The execution interval for the retention policy.       |

### sys.sample\_segment\_io\_pipelines

This table contains information about a sample of segment I/O processing plans used for the database table I/O during query execution.

| Column Name                       | Column Type | Column Description                                                                       |
| --------------------------------- | ----------- | ---------------------------------------------------------------------------------------- |
| completed\_time                   | TIMESTAMP   | The time when this segment pipeline was completed.                                       |
| database\_name                    | VARCHAR     | The database associated with the query to which the I/O operator belongs.                |
| user\_name                        | VARCHAR     | The name of the user associated with the query to which the I/O operator belongs.        |
| query\_id                         | UUID        | The Universally Unique IDentifier (UUID) of the query to which the I/O operator belongs. |
| operator\_uuid                    | UUID        | The UUID of the I/O operator in the query plan.                                          |
| operator\_id                      | BIGINT      | An identifier of the I/O operator in the VM node that owns it.                           |
| node\_id                          | UUID        | The UUID of the node on which the I/O operator was executed.                             |
| silo\_id                          | BIGINT      | The identifier of the silo on which this I/O operator was executed.                      |
| segment\_storage\_id              | UUID        | The UUID for the segment associated with this I/O pipeline.                              |
| table\_id                         | UUID        | The UUID for the database table where this segment belongs.                              |
| segment\_bounds\_lower\_inclusive | BIGINT      | The lower bound (inclusive) on the row numbers processed in this pipeline.               |
| segment\_bounds\_upper\_exclusive | BIGINT      | The upper bound (exclusive) on the row numbers processed in this pipeline.               |
| pipeline                          | VARCHAR     | A text representation of this segment I/O pipeline.                                      |

### sys.scheduled\_tasks

This table contains the details of scheduled tasks in the system.

| Column Name             | Column Type | Column Description                                              |
| ----------------------- | ----------- | --------------------------------------------------------------- |
| id                      | UUID        | The scheduled task identifier.                                  |
| admin\_owner\_id        | UUID        | The identifier of the node that is managing the scheduled task. |
| task\_type              | CHAR        | The type of the task.                                           |
| execution\_interval\_ms | LONG        | The interval, in milliseconds, between task executions.         |

### sys.schemas

This table contains the details of schemas in the system.

| Column Name  | Column Type | Column Description                                                                 |
| ------------ | ----------- | ---------------------------------------------------------------------------------- |
| id           | UUID        | The Universally Unique IDentifier (UUID) of the schema.                            |
| name         | CHAR        | The name of the schema.                                                            |
| database\_id | UUID        | The UUID of the database for the schema.                                           |
| created\_at  | TIMESTAMP   | The timestamp that represents when the schema was created.                         |
| updated\_at  | TIMESTAMP   | The timestamp that represents when the schema was updated.                         |
| creator\_id  | UUID        | The UUID of the creator for the schema.                                            |
| is\_implicit | BOOLEAN     | Denotes the implicit creation of this schema after the creation of another object. |

### sys.service\_role\_status

This table contains the status of each service role on the system.

| Column Name         | Column Type | Column Description                                       |
| ------------------- | ----------- | -------------------------------------------------------- |
| node\_id            | UUID        | The Universally Unique IDentifier (UUID) of the node.    |
| service\_role\_id   | UUID        | The UUID of the service role (sys.service\_roles).       |
| service\_role\_name | CHAR        | The human-readable name of the service role on the node. |
| status              | CHAR        | The current status of the role on this node.             |

### sys.storage\_device\_metrics

This table contains monitoring metrics collected on each storage device that is controlled by Ocient.

| Column Name | Column Type | Column Description                                                                                                  |
| ----------- | ----------- | ------------------------------------------------------------------------------------------------------------------- |
| id          | CHAR        | Unique and persistent serial number of the drive. This serial number is not a Universally Unique IDentifier (UUID). |
| key         | CHAR        | Name of the measured statistic on the drive.                                                                        |
| value       | CHAR        | Value of the named statistic on the drive.                                                                          |
| transient   | BOOLEAN     | When the value is true, the value indicates that it is transient in nature and is reset when the node is restarted. |
| node\_id    | UUID        | The UUID of the node that contains the storage device.                                                              |

### sys.storage\_device\_status

This table contains real-time information about the storage devices for each online node.

| Column Name                           | Column Type | Column Description                                                                                                                       |
| ------------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| node\_id                              | UUID        | The Universally Unique IDentifier (UUID) of the node that contains the storage device.                                                   |
| device\_id                            | INT         | Identifier of the drive.                                                                                                                 |
| role\_name                            | CHAR        | The name of the role or roles active on the node that contains the storage device.                                                       |
| id                                    | CHAR        | Unique and persistent serial number of the drive. This serial number is not a UUID.                                                      |
| pci\_address                          | CHAR        | PCI address where the drive is mounted.                                                                                                  |
| device\_model                         | CHAR        | Model information about the drive.                                                                                                       |
| manufacturer                          | CHAR        | Manufacturer information about the drive.                                                                                                |
| firmware\_version                     | CHAR        | Firmware version that is active on the drive.                                                                                            |
| capacity                              | LONG        | Capacity, in bytes, of the drive.                                                                                                        |
| utilization                           | LONG        | Utilization, in bytes, of the drive.                                                                                                     |
| endurance\_percentage\_used           | DOUBLE      | Value from 0 to 1 that represents an estimate of the percentage of the drive used, as it applies to drive endurance.                     |
| device\_status                        | CHAR        | Human-readable version of the drive status. Values are `ACTIVE`, `FAILED`, or `NOT PRESENT`.                                             |
| assigned\_drive\_slots                | ARRAY(INT)  | List of drive slots assigned to this device. The list might be empty if no slots are assigned to a device.                               |
| encryption\_drive\_locking\_supported | BOOLEAN     | Indicates whether encryption drive locking (e.g., OPAL) is supported on the device.                                                      |
| encryption\_drive\_locking\_enabled   | BOOLEAN     | Indicates whether encryption drive locking (e.g., OPAL) is enabled on the device.                                                        |
| encryption\_drive\_locking\_status    | CHAR        | Indicates the status of drive locking (e.g., OPAL): `LOCKED` or `UNLOCKED`. If drive locking is not supported, this value is `UNLOCKED`. |
| silo\_id                              | LONG        | The identifier of the silo where this device is located.                                                                                 |

### sys.subtasks

This table contains the status and details of subtasks in the system.

| Column Name      | Column Type | Column Description                                         |
| ---------------- | ----------- | ---------------------------------------------------------- |
| id               | UUID        | The task identifier.                                       |
| name             | CHAR        | The name of the task.                                      |
| task\_type       | CHAR        | The type of the task.                                      |
| execution\_type  | CHAR        | The type of the task execution.                            |
| location\_type   | CHAR        | The type of the location where the task must run.          |
| location\_id     | CHAR        | The location where the task must run.                      |
| task\_options    | CHAR        | The task arguments.                                        |
| start\_time      | TIMESTAMP   | The start time of the task.                                |
| end\_time        | TIMESTAMP   | The end time of the task.                                  |
| last\_poll\_time | TIMESTAMP   | The last time that the task was polled for a status.       |
| duration         | LONG        | The duration, in milliseconds, of the task.                |
| status           | CHAR        | The current status of the task.                            |
| details          | CHAR        | The details or results of the status for the current task. |
| task\_owner\_id  | UUID        | The identifier of the node that is running the task.       |
| admin\_owner\_id | UUID        | The identifier of the node that is monitoring the task.    |
| parent\_task\_id | UUID        | The identifier of the parent task for the current task.    |
| root\_task\_id   | UUID        | The identifier of the root task for the current task.      |
| database\_id     | UUID        | The database identifier.                                   |
| parallelization  | CHAR        | The parallelization type of the task.                      |
| state            | BINARY      | The internal state of the task.                            |
| scope            | UUID        | The identifier of the scope for the current task.          |

### sys.tasks

The `tasks` table shows the root tasks that have been started in the system.

| Column Name      | Column Type | Column Description                                 |
| ---------------- | ----------- | -------------------------------------------------- |
| id               | UUID        | Task identifier                                    |
| name             | VARCHAR     | Task name                                          |
| task\_type       | VARCHAR     | Task type                                          |
| execution\_type  | VARCHAR     | Task execution type                                |
| location\_type   | VARCHAR     | Location type where the task must run              |
| location\_id     | VARCHAR     | Location where the task must run                   |
| task\_options    | VARCHAR     | Task arguments                                     |
| start\_time      | TIMESTAMP   | Task start time                                    |
| end\_time        | TIMESTAMP   | Task end time                                      |
| last\_poll\_time | TIMESTAMP   | Last time the task was polled for status           |
| duration         | BIGINT      | Task duration in milliseconds                      |
| status           | VARCHAR     | Current task status                                |
| details          | VARCHAR     | Current task status details or results             |
| task\_owner\_id  | UUID        | Identifier of the node that is running the task    |
| admin\_owner\_id | UUID        | Identifier of the node that is monitoring the task |
| parallelization  | VARCHAR     | Parallelization type of the task                   |
| scope            | UUID        | Identifier of the scope of the task                |

## Network

### sys.channel\_endpoint\_parameters

This table contains details for the endpoints defined on the nodes in the system.

| Column Name     | Column Type | Column Description                                            |
| --------------- | ----------- | ------------------------------------------------------------- |
| id              | UUID        | Universally Unique IDentifier (UUID) of the channel endpoint. |
| node\_id        | UUID        | UUID of the node where the endpoint is located (sys.nodes).   |
| name            | CHAR        | Name of the channel endpoint.                                 |
| endpoint\_type  | CHAR        | Type of the channel endpoint (FULL or EXTERNAL).              |
| port            | INT         | Port that the channel endpoint is using.                      |
| ip\_address     | CHAR        | IP address of the channel endpoint.                           |
| context\_type   | CHAR        | Context type of the channel endpoint                          |
| listener\_type  | CHAR        | Listener type of the channel endpoint                         |
| initiator\_type | CHAR        | Initiator type of the channel endpoint.                       |

### sys.network\_interface\_models

This table contains the network devices registered on the system.

| Column Name       | Column Type | Column Description                               |
| ----------------- | ----------- | ------------------------------------------------ |
| id                | UUID        | Universally Unique IDentifier (UUID) of the NIC. |
| manufacturer      | CHAR        | Manufacturer of the NIC.                         |
| model\_name       | CHAR        | Model name of the NIC.                           |
| pci\_id           | CHAR        | PCI identifier.                                  |
| pci\_subsys\_id   | CHAR        | PCI Subsystem identifier.                        |
| driver\_type      | CHAR        | Driver type of NIC.                              |
| bits\_per\_second | LONG        | Bits per second.                                 |

### sys.network\_interface\_usage\_types

This table contains the uses of each network device in the system.

| Column Name                   | Column Type | Column Description                                                                       |
| ----------------------------- | ----------- | ---------------------------------------------------------------------------------------- |
| network\_interface\_id        | UUID        | Universally Unique IDentifier (UUID) of the network interface (sys.network\_interfaces). |
| network\_interface\_model\_id | UUID        | UUID of the network interface model (sys.network\_interface\_models).                    |
| network\_type                 | CHAR        | Usage type of NIC (ADMIN, DATA, EXTERNAL, LOCAL\_HSI).                                   |

### sys.node\_network\_interfaces

This table contains the network interfaces on each node.

| Column Name                   | Column Type | Column Description                                                                                    |
| ----------------------------- | ----------- | ----------------------------------------------------------------------------------------------------- |
| network\_interface\_model\_id | UUID        | Universally Unique IDentifier (UUID) of the network interface model (sys.network\_interface\_models). |
| network\_interface\_id        | UUID        | UUID of the network interface.                                                                        |
| node\_id                      | UUID        | UUID of the node where this interface exists (sys.nodes).                                             |
| interface\_type               | CHAR        | Type of interface (PHYSICAL, BOND\_SLAVE, BOND\_MASTER).                                              |
| address                       | CHAR        | MAC address of the NIC.                                                                               |
| name                          | CHAR        | Name of the NIC.                                                                                      |
| netmask                       | CHAR        | Netmask of the NIC.                                                                                   |
| gateway                       | CHAR        | Gateway of the NIC.                                                                                   |
| pci\_address                  | CHAR        | PCI address of the NIC.                                                                               |
| master\_interface\_name       | CHAR        | Master interface name of the NIC.                                                                     |
| bond\_type                    | CHAR        | Network bond type of the NIC.                                                                         |

### sys.service\_role\_channel\_endpoints

This table contains the channel endpoint parameters that are enabled for each network type and service role.

| Column Name                       | Column Type | Column Description                                                                                  |
| --------------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| service\_role\_id                 | UUID        | The Universally Unique IDentifier (UUID) of the service role of this endpoint (sys.service\_roles). |
| channel\_endpoint\_parameters\_id | UUID        | UUID of the parameters for this endpoint (sys.channel\_endpoint\_parameters).                       |
| network\_type                     | CHAR        | Network type for this endpoint (ADMIN, DATA, EXTERNAL, LOCAL\_HSI).                                 |

## Pipelines

### sys.pipeline\_errors

While running a pipeline, you might experience errors. These errors are often due to a mismatch between the expectation of the pipeline and the source data. System or networking errors can also occur while the pipeline is running. The sys.pipeline\_errors system catalog table lists extraction, transformation, and pipeline errors.

| Column Name         | Column Type | Column Description                                                                                                                                                                                                 |
| ------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| pipeline\_id        | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines) that loads this partition.                                                                                                                    |
| extractor\_task\_id | UUID        | UUID of the task associated with this pipeline run (sys.subtasks).                                                                                                                                                 |
| error\_index        | BIGINT      | Error indexes start at 1 and increase monotonically as the Ocient System finds them.                                                                                                                               |
| error\_type         | VARCHAR     | The type of error. Values are EXTRACTION, TRANSFORMATION, and PIPELINE\_ERROR.                                                                                                                                     |
| error\_code         | VARCHAR     | This 5-character code identifies the type of error.                                                                                                                                                                |
| source\_name        | VARCHAR     | For file loads, this value is the absolute path of the file that includes the S3 bucket. For Kafka loads, the value is the topic name and partition number.                                                        |
| error\_message      | VARCHAR     | The error message.                                                                                                                                                                                                 |
| partition\_id       | VARCHAR     | The identifier of the partition. For file loads, the value is the stream source identifier where the file is located. For Apache® Kafka® loads, this value is the partition number.                                |
| record\_number      | BIGINT      | The one-based index of the processed record in the source file or Kafka partition defined in the `source_name` column. This index does not account for headers or skipped lines.                                   |
| record\_offset      | BIGINT      | The one-based offset in bytes of the record data in the source file for file loads or the Kafka offset for Kafka loads. This offset is -1 for files with non-row-based storage formats (such as Apache® Parquet™). |
| field\_index        | INT         | The zero-based index of the expression in the `SELECT` clause of the `CREATE PIPELINE` SQL statement.                                                                                                              |
| column\_name        | VARCHAR     | The name of the column in the target table.                                                                                                                                                                        |
| created\_at         | TIMESTAMP   | Timestamp that represents when this error was created.                                                                                                                                                             |

### sys.pipeline\_events

While your pipeline is running, the pipeline generates events in the sys.pipeline\_events system catalog table to mark significant checkpoints when something has occurred. For details about the lists of files, see the sys.pipeline\_files system catalog table. Pipeline events include messages from many different tasks. These events are the background processes that execute across different Loader Nodes during pipeline operation. For details about tasks, you can query the sys.tasks and sys.subtasks system catalog tables.

| Column Name      | Column Type | Column Description                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| ---------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| pipeline\_id     | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines).                                                                                                                                                                                                                                                                                                                                                                                               |
| task\_id         | UUID        | UUID of the task associated with this pipeline run (sys.subtasks).                                                                                                                                                                                                                                                                                                                                                                                                  |
| user\_id         | UUID        | The user who initiated the event (sys.users).                                                                                                                                                                                                                                                                                                                                                                                                                       |
| event\_type      | VARCHAR     | The type of the event. You can generate events with these types: CREATED, REPLACED, RENAMED, STARTED, STOPPING, and STOPPED. The Ocient System generates events with these types automatically: FILE\_LISTING\_STARTED, FILE\_LISTING\_GENERATED, FILE\_LISTING\_COMPLETED, COMPLETED, FAILED, EXTRACTION\_STARTED, EXTRACTION\_COMPLETED, EXTRACTION\_FAILED, EXTRACTION\_RESOURCE\_EXHAUSTED, SKIPPING\_PARTIALLY\_LOADED\_FILE, and KAFKA\_PARTITION\_REBALANCE. |
| event\_message   | VARCHAR     | Message that provides more details about the event.                                                                                                                                                                                                                                                                                                                                                                                                                 |
| event\_timestamp | TIMESTAMP   | Timestamp that represents when this event occurred.                                                                                                                                                                                                                                                                                                                                                                                                                 |

### sys.pipeline\_files

For file-based loads, the sys.pipeline\_files system catalog table contains one row for each file that shows the status of the file.

| Column Name         | Column Type | Column Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| ------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| pipeline\_id        | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines).                                                                                                                                                                                                                                                                                                                                                                                                             |
| extractor\_task\_id | UUID        | The unique identifier of the task requested to load this file (sys.subtasks).                                                                                                                                                                                                                                                                                                                                                                                                     |
| name                | VARCHAR     | Name of the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| create\_timestamp   | TIMESTAMP   | Timestamp that represents when this file is created.                                                                                                                                                                                                                                                                                                                                                                                                                              |
| modified\_timestamp | TIMESTAMP   | Timestamp that represents when this file is last modified.                                                                                                                                                                                                                                                                                                                                                                                                                        |
| size                | BIGINT      | Size of the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| status              | VARCHAR     | The status of the file that updates throughout the process of a pipeline load. Values are: PENDING (listed file but not assigned to an extractor task), QUEUED (assigned to an extractor task but not confirmed the existence of the file), LOADING (confirmed existence of the file and began loading), LOADED (loaded data with complete success), LOADED\_WITH\_ERRORS (loaded data with at least one error), FAILED (failed to load), and SKIPPED (skipped loading the file). |
| file\_index         | BIGINT      | Index of the file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                |

### sys.pipeline\_files\_pending

For file-based loads, the sys.pipeline\_files system catalog table contains one row for each file that shows the status of the file.

| Column Name           | Column Type | Column Description                                                    |
| --------------------- | ----------- | --------------------------------------------------------------------- |
| pipeline\_id          | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines). |
| name                  | VARCHAR     | The name of the file.                                                 |
| create\_timestamp     | TIMESTAMP   | The timestamp that represents when this file is created.              |
| modified\_timestamp   | TIMESTAMP   | The timestamp that represents when this file is last modified.        |
| size                  | BIGINT      | The size of the file.                                                 |
| file\_index           | BIGINT      | The index of the file.                                                |
| file\_transaction\_id | BIGINT      | The identifier of the file transaction that produced this file.       |

### sys.pipeline\_functions

This table contains all of the pipeline functions in the system.

| Column Name            | Column Type    | Column Description                                                                        |
| ---------------------- | -------------- | ----------------------------------------------------------------------------------------- |
| id                     | UUID           | The Universally Unique IDentifier (UUID) of the pipeline function.                        |
| name                   | CHAR           | The name of the pipeline function.                                                        |
| database\_id           | UUID           | The UUID of the database for this pipeline function (sys.databases).                      |
| language               | CHAR           | The language used to write the pipeline function.                                         |
| return\_type           | CHAR           | The return type of the pipeline function.                                                 |
| return\_type\_nullable | BOOLEAN        | The nullable property of the return type for the pipeline function.                       |
| definition             | CHAR           | The definition of the pipeline function.                                                  |
| creator\_id            | UUID           | The UUID of the user or group who created the pipeline function (sys.users/sys.groups).   |
| created\_at            | TIMESTAMP      | The timestamp when this pipeline function was created.                                    |
| altered\_at            | TIMESTAMP      | The timestamp when this pipeline function was last updated.                               |
| argument\_names        | ARRAY(CHAR)    | The argument names of the pipeline function, specified as an array.                       |
| argument\_types        | ARRAY(CHAR)    | The argument types of the pipeline function, specified as an array.                       |
| argument\_nullability  | ARRAY(BOOLEAN) | Whether the argument types for the pipeline function are nullable, specified as an array. |
| imported\_libraries    | ARRAY(CHAR)    | The import statements for the pipeline function, specified as an array.                   |

### sys.pipeline\_metrics

Find metrics that measure the performance and activity of a pipeline in the sys.pipeline\_metrics view. This table contains one row for each metric at a specified point in time. Metrics are either instantaneous or incremental. Instantaneous metrics reflect the current value of a counter at the time of the metric collection. Incremental metrics increase over time and reflect the cumulative value for a specified counter. The first snapshot of a metric appears when it is initialized. Afterward, the system updates the metric every 10 seconds. Each metric has a scope that defines its uniqueness. Do not aggregate metrics across different scopes. The scope columns are pipeline\_id, extractor\_task\_id, partition\_id, and sink\_index. If the value of any of these columns is NULL, the scope applies to all values in that dimension.

| Column Name         | Column Type | Column Description                                                                                                                                         |
| ------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| pipeline\_id        | UUID        | UUID of the pipeline (sys.pipelines) loading this partition.                                                                                               |
| extractor\_task\_id | UUID        | UUID of the task associated with this pipeline run (sys.subtasks).                                                                                         |
| partition\_id       | VARCHAR     | The partition identifier. For file-based loads, this identifier is the stream source identifier. For Kafka loads, this identifier is the partition number. |
| sink\_index         | BIGINT      | The one-based index of the table in the `CREATE PIPELINE` SQL statement or NULL for metrics that are not table-specific.                                   |
| name                | VARCHAR     | The name of the metric.                                                                                                                                    |
| value               | BIGINT      | The value of the metric.                                                                                                                                   |
| updated\_at         | TIMESTAMP   | Timestamp that represents when this metric was updated.                                                                                                    |

### sys.pipeline\_metrics\_info

Find the full list of available metrics in the sys.pipeline\_metrics\_info built-in view. This static table provides metric units, type, and descriptions.

| Column Name  | Column Type | Column Description                                       |
| ------------ | ----------- | -------------------------------------------------------- |
| name         | VARCHAR     | Name of the metric.                                      |
| units        | VARCHAR     | Units of the metric.                                     |
| metric\_type | VARCHAR     | Type of the metric. One of INCREMENTAL or INSTANTANEOUS. |
| description  | VARCHAR     | Description of the metric.                               |

### sys.pipeline\_partitions

For Apache® Kafka® partition-based loads, the sys.pipeline\_partitions system catalog table contains one row for each partition, which contains the current offsets and record counts.

| Column Name                      | Column Type | Column Description                                                                                                                                                    |
| -------------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| pipeline\_id                     | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines) loading this partition.                                                                          |
| extractor\_task\_id              | UUID        | UUID of the task associated with this pipeline run (sys.subtasks).                                                                                                    |
| group\_id                        | VARCHAR     | The group identifier (group.id) of the pipeline that loads this partition.                                                                                            |
| topic\_name                      | VARCHAR     | The name of the Kafka topic where this partition belongs.                                                                                                             |
| partition\_number                | BIGINT      | The partition number on the Kafka topic.                                                                                                                              |
| max\_offset                      | BIGINT      | The current maximum offset on this partition.                                                                                                                         |
| last\_committed\_durable\_offset | BIGINT      | The last committed offset on the partition that was indicated as durable by the Ocient System. This offset might lag slightly behind the actual durability of tables. |
| lag                              | INT         | The number of records yet to be processed in a partition, calculated as the difference between the maximum offset and the last committed durable offset.              |
| records\_processed               | INT         | The number of records processed (but not necessarily made durable) for this partition.                                                                                |
| records\_failed                  | INT         | The number of failed records for this partition.                                                                                                                      |
| updated\_at                      | TIMESTAMP   | The timestamp when the Ocient System last updated the details of this partition.                                                                                      |

### sys.pipeline\_tables

This table contains all of the table identifiers currently associated with pipeline objects in the system.

| Column Name  | Column Type | Column Description                                                       |
| ------------ | ----------- | ------------------------------------------------------------------------ |
| pipeline\_id | UUID        | Universally Unique IDentifier (UUID) of the pipeline (sys.pipelines).    |
| table\_id    | UUID        | UUID of the table (sys.tables).                                          |
| table\_index | INT         | The one-based index of the table in the `CREATE PIPELINE` SQL statement. |

### sys.pipeline\_tasks

The Ocient System implements the internals of a pipeline using distributed tasks. Each pipeline has a unique pipeline identifier pipeline\_id. Every time that a START PIPELINE SQL statement is executed, the Ocient System generates a run\_pipeline task that serves as the main coordinator task. This task automatically partitions the source data into smaller units and creates a run\_extractor task for each one. Then, the Ocient System sends each run\_extractor task and executes it on a Loader Node. In the sys.pipeline\_tasks system catalog table, you can see the run\_pipeline and run\_extractor tasks.

| Column Name      | Column Type | Column Description                                         |
| ---------------- | ----------- | ---------------------------------------------------------- |
| pipeline\_id     | UUID        | Universally Unique IDentifier (UUID) of the pipeline.      |
| task\_id         | UUID        | Task identifier                                            |
| execution\_type  | VARCHAR     | The type of the task.                                      |
| parent\_task\_id | UUID        | Identifier of the parent task of the task                  |
| location\_type   | VARCHAR     | The type of location where the task must run.              |
| location\_id     | VARCHAR     | The identifier for the location where the task must run.   |
| task\_owner\_id  | UUID        | Identifier of the node that is running the task            |
| admin\_owner\_id | UUID        | Identifier of the node that is monitoring the task         |
| status           | VARCHAR     | Current task status                                        |
| details          | VARCHAR     | The details or results of the status for the current task. |
| start\_time      | TIMESTAMP   | The start time of the task.                                |
| end\_time        | TIMESTAMP   | The end time of the task.                                  |
| duration         | BIGINT      | Task duration in milliseconds                              |

### sys.pipelines

This table contains all of the pipelines in the system.

| Column Name                        | Column Type | Column Description                                                                                                                 |
| ---------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| id                                 | UUID        | Universally Unique IDentifier (UUID) of the pipeline.                                                                              |
| name                               | CHAR        | Name of the pipeline.                                                                                                              |
| database\_id                       | UUID        | UUID of the database of the pipeline (sys.databases).                                                                              |
| loading\_mode                      | CHAR        | Specifies whether the pipeline runs in a one-time (BATCH), one-time transactional (TRANSACTIONAL), or continuous (CONTINUOUS) way. |
| source\_type                       | CHAR        | Source of the data (S3, KAFKA, FILESYSTEM).                                                                                        |
| data\_format                       | CHAR        | Structure of the data (CSV, DELIMITED, JSON, BINARY, PARQUET, XML, ASN1, AVRO).                                                    |
| created\_at                        | TIMESTAMP   | Timestamp that indicates when this pipeline was created.                                                                           |
| altered\_at                        | TIMESTAMP   | Timestamp that indicates when this pipeline was last updated.                                                                      |
| creator\_id                        | UUID        | The UUID of the user or group who created the pipeline (sys.users/sys.groups).                                                     |
| status                             | CHAR        | Status of the pipeline (RUNNING, STOPPED, COMPLETED, FAILED).                                                                      |
| status\_message                    | CHAR        | Status message of the pipeline.                                                                                                    |
| task\_id                           | UUID        | Universally Unique IDentifier (UUID) of the task (sys.tasks).                                                                      |
| rolehostd\_version                 | CHAR        | The rolehostd version in which this table was created                                                                              |
| pending\_files\_count              | LONG        | The number of files with the `PENDING` status (sys.pipeline\_files).                                                               |
| queued\_files\_count               | LONG        | The number of files with the `QUEUED` status (sys.pipeline\_files).                                                                |
| loading\_files\_count              | LONG        | The number of files with the `LOADING` status (sys.pipeline\_files).                                                               |
| loaded\_files\_count               | LONG        | The number of files with the `LOADED` status (sys.pipeline\_files).                                                                |
| loaded\_with\_errors\_files\_count | LONG        | The number of files with the `LOADED_WITH_ERRORS` status (sys.pipeline\_files).                                                    |
| failed\_files\_count               | LONG        | The number of files with the `FAILED` status (sys.pipeline\_files).                                                                |
| skipped\_files\_count              | LONG        | The number of files with the `SKIPPED` status (sys.pipeline\_files).                                                               |

## Security

### sys.security\_settings

This table contains security settings.

| Column Name                       | Column Type | Column Description                                                         |
| --------------------------------- | ----------- | -------------------------------------------------------------------------- |
| database\_id                      | UUID        | The database for this setting. This might be NULL for system-wide settings |
| group\_id                         | UUID        | The group for this setting when the setting is for a group                 |
| password\_minimum\_length         | INT         | Minimum password length.                                                   |
| password\_complexity\_level       | INT         | Password complexity requirement.                                           |
| password\_lifetime\_days          | INT         | Password lifetime in days.                                                 |
| password\_no\_repeat\_count       | INT         | Password repetition count.                                                 |
| password\_invalid\_attempt\_limit | INT         | Invalid password attempt limit.                                            |

## Security Integrations

### sys.oidc\_integrations

This table enumerates the configuration for OpenID Connect Single Sign-On integrations (i.e. OKTA®). You can modify this configuration using the ALTER DATABASE  ALTER SSO INTEGRATION oidc DDL statement where  is the name of your database.

:::Iframe{code="<database>"}

:::

:::Iframe{code="<database>"}

:::

| Column Name                       | Column Type | Column Description                                                                                                                                 |
| --------------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| security\_integration\_id         | UUID        | The id of this OpenID Connect (OIDC) Single Sign-On integration.                                                                                   |
| database\_id                      | UUID        | The id of the database using this Single Sign-On  authorization to this integration.                                                               |
| disabled                          | BOOLEAN     | When true, all new connections made using this Single Sign-On integration will fail.                                                               |
| default\_group                    | CHAR        | The group which all users of this Single Sign-On intergation are granted membership to.                                                            |
| issuer                            | CHAR        | The complete URL for the OAuth 2.0 / OpenID Connect Authorization Server. This is the expected "iss" claim in an access token.                     |
| client\_id                        | CHAR        | The provider-supplied ID of this Single Sign-On integration.                                                                                       |
| public\_client                    | BOOLEAN     | When true, PKCE is used in place of a client authentication method                                                                                 |
| enable\_id\_token\_authentication | BOOLEAN     | When true, a fat ID Token is sufficient to connect to the database.                                                                                |
| user\_id\_claims                  | ARRAY(CHAR) | The id token claim(s) used to identify users in audit trails.                                                                                      |
| additional\_scopes                | ARRAY(CHAR) | Request scopes for authorization requests.                                                                                                         |
| additional\_audiences             | ARRAY(CHAR) | Additional token audience to accept when validating tokens. This is useful for Authorization Servers without a token exchange capability.          |
| groups\_claim\_ids                | ARRAY(CHAR) | The token claims that can be used to map the user to a Database group. You must provide `groups_claim_ids` if `groups_claim_mappings` is provided. |
| groups\_claim\_mappings           | CHAR        | The mappings from Provider group => Database group.                                                                                                |
| roles\_claim\_ids                 | ARRAY(CHAR) | The token claims that can be used to map the user to a Database role. You must provide `roles_claim_ids` if `roles_claim_mappings` is provided.    |
| roles\_claim\_mappings            | CHAR        | The mappings from Provider role => Database role.                                                                                                  |
| blocked\_groups                   | ARRAY(CHAR) | Provider groups that are restricted from connecting to the database.                                                                               |
| blocked\_roles                    | ARRAY(CHAR) | Provider roles that are restricted from connecting to the database.                                                                                |
| allowed\_groups                   | ARRAY(CHAR) | Provider groups that are allowed to connect to the database.                                                                                       |
| allowed\_roles                    | ARRAY(CHAR) | Provider roles that are allowed to connect to the database.                                                                                        |
| enable\_debug\_flow               | BOOLEAN     |                                                                                                                                                    |
| redirect\_host                    | CHAR        | Specifies the redirect host used in authorization requests.                                                                                        |
| redirect\_ssl                     | BOOLEAN     | Whether to use SSL for redirect URIs.                                                                                                              |
| request\_scopes                   | ARRAY(CHAR) | All request scopes for authorization requests.                                                                                                     |
| scopes\_on\_refresh               | BOOLEAN     | Whether to include the scope list in the initial refresh-token request. The default value is `false`.                                              |
| allow\_offline\_access            | BOOLEAN     | Whether to include `access_type=offline` and `prompt=consent` in the authorization URL. The default value is `false`.                              |

### sys.oidc\_sessions

The sys.oidc\_sessions table contains information about active database connections established using an OpenID Connect (oidc) Single Sign-On integration.

| Column Name               | Column Type | Column Description                                                              |
| ------------------------- | ----------- | ------------------------------------------------------------------------------- |
| id                        | UUID        | The unique identifier for this session.                                         |
| user                      | CHAR        | The Fully Qualified User Name (FQUN) of this user.                              |
| database\_id              | UUID        | The id of the database associated with this session.                            |
| security\_integration\_id | UUID        | The id of the OpenID Connect (OIDC) Single Sign-On integration that authorized. |
| has\_access\_token        | BOOLEAN     | True if the identity provider supplied an Access Token.                         |
| has\_refresh\_token       | BOOLEAN     | True if the identity provider supplied a Refresh Token.                         |
| compact\_id\_token        | CHAR        | The JWS compact serialization form of the ID Token.                             |
| id\_token\_json           | CHAR        | The ID Token claims.                                                            |

### sys.security\_integrations

This table contains the OIDC security integrations installed on the system.

| Column Name            | Column Type | Column Description                                                                           |
| ---------------------- | ----------- | -------------------------------------------------------------------------------------------- |
| id                     | UUID        | UUID of the OIDC security integration.                                                       |
| database\_id           | UUID        | UUID of the database associated with this security integration (sys.databases).              |
| integration\_type      | CHAR        | The type of the security integration (SSO, SCIM, LDAP, etc.).                                |
| table\_descriptor      | CHAR        | An indirect pointer to the table where you can view the objects of this integration.         |
| sso\_integration\_name | CHAR        | SSO integration name, if the security integration is of type SSO                             |
| is\_database\_default  | BOOLEAN     | When true, the security integration is used as the default SSO integration for the database. |

### sys.sessions

This table contains information about active client connections.

| Column Name                     | Column Type | Column Description                                                                                                                                                                                                                                                                                                                            |
| ------------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                              | UUID        | The unique identifier for this session.                                                                                                                                                                                                                                                                                                       |
| user                            | CHAR        | The Fully Qualified User Name (FQUN) of this user.                                                                                                                                                                                                                                                                                            |
| sso\_protocol                   | CHAR        | The Single Sign-On (SSO) protocol used to authorize the connection request. Null if basic password authentication was used. Tables exists for each SSO protocol using the following naming scheme: "\_sessions". For example, all sessions created using the OpenID Connect (oidc) protocol will be listed in the "sys.oidc\_sessions" table. |
| database\_id                    | UUID        | The id of the database associated with this session.                                                                                                                                                                                                                                                                                          |
| default\_schema                 | CHAR        | The default schema used for queries submitted by this user.                                                                                                                                                                                                                                                                                   |
| created\_at\_timestamp          | LONG        | The number of seconds from epoch the session was established.                                                                                                                                                                                                                                                                                 |
| duration                        | LONG        | The number of seconds since the session was established.                                                                                                                                                                                                                                                                                      |
| expires\_at\_timestamp          | LONG        | The number of seconds from epoch the session expires.                                                                                                                                                                                                                                                                                         |
| refresh\_expires\_at\_timestamp | LONG        | The number of seconds from epoch the refresh token expires.                                                                                                                                                                                                                                                                                   |
| is\_renewable                   | BOOLEAN     | When the value is `true`, the database attempts to extend the session when it expires.                                                                                                                                                                                                                                                        |
| client\_ip                      | CHAR        | The IP address of the client.                                                                                                                                                                                                                                                                                                                 |
| client\_name                    | CHAR        | The human-readable name of the client.                                                                                                                                                                                                                                                                                                        |
| client\_session\_id             | CHAR        | An opaque identifier provided by client implementations. Used to correlate events across application boundaries.                                                                                                                                                                                                                              |
| protocol\_version               | CHAR        | The version of the client-server protocol for this connection.                                                                                                                                                                                                                                                                                |
| driver\_version                 | CHAR        | The version of the client driver.                                                                                                                                                                                                                                                                                                             |
| tls\_enabled                    | BOOLEAN     | True if TLS is enabled for this client connection.                                                                                                                                                                                                                                                                                            |
| node\_id                        | UUID        | The unique identifier of the node the client is connected to.                                                                                                                                                                                                                                                                                 |
| connectivity\_pool\_id          | UUID        | The unique identifier of the connectivity pool the client is connected on.                                                                                                                                                                                                                                                                    |
| group\_names                    | CHAR        | Names of all groups in the session.                                                                                                                                                                                                                                                                                                           |
| role\_names                     | CHAR        | Names of all roles in the session.                                                                                                                                                                                                                                                                                                            |
| active\_service\_class\_names   | CHAR        | Names of all active service classes in the session.                                                                                                                                                                                                                                                                                           |
| inactive\_service\_class\_names | CHAR        | Names of all inactive service classes in the session.                                                                                                                                                                                                                                                                                         |

:::Iframe{code="<protocol>"}

:::

## Statistics

### sys.average\_bb\_sizes

This table contains the average size of bounding boxes in the database for geospatial data types.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| table\_id   | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| column\_id  | UUID        | UUID of the column (sys.columns).                               |
| avg\_width  | DOUBLE      | Average width of bounding boxes in this column.                 |
| avg\_height | DOUBLE      | Average height of bounding boxes in this column.                |

### sys.average\_column\_sizes

This table contains the average size of each column in the database.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| table\_id   | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| column\_id  | UUID        | UUID of the column (sys.columns).                               |
| size        | DOUBLE      | Average size of the column.                                     |

### sys.column\_cardinalities

This table contains estimates of the number of unique values in each column in the database. These estimates might not reflect recent loading or deletion activity.

| Column Name         | Column Type | Column Description                                                                                                                                |
| ------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| table\_id           | UUID        | The Universally Unique IDentifier (UUID) of the table (sys.tables).                                                                               |
| column\_id          | UUID        | UUID of the column (sys.columns).                                                                                                                 |
| cardinality         | LONG        | The estimate of the number of unique values in this column.                                                                                       |
| stats\_type         | CHAR        | Represents the type of values, either 'COLUMN' or 'INNER\_ARRAY'.                                                                                 |
| num\_included\_rows | LONG        | The estimate of the total number of non-NULL rows (where this column value is not NULL) in the table that are included in this distinct estimate. |
| num\_excluded\_rows | LONG        | The estimate of the total number of rows in the table that are not included in this distinct estimate.                                            |

### sys.column\_distributions

This table contains some statistical characteristics of the calculated Kernel Density Distribution of data in the database columns.

| Column Name    | Column Type | Column Description                                                                   |
| -------------- | ----------- | ------------------------------------------------------------------------------------ |
| table\_id      | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables).                      |
| column\_id     | UUID        | UUID of the column (sys.columns).                                                    |
| bandwidth      | DOUBLE      | Smoothing parameter for the distribution.                                            |
| minimum\_value | DOUBLE      | Minimum value found in the distribution.                                             |
| maximum\_value | DOUBLE      | Maximum value found in the distribution.                                             |
| stats\_type    | CHAR        | Represents the type of values in the distribution, either 'TABLE' or 'INNER\_ARRAY'. |
| num\_samples   | LONG        | The number of sampled row values included in the Kernel Density Distribution.        |

### sys.columns\_compression\_info

This table contains column-level compression statistics for fixed-length columns. The system calculates statistics from the column data across all segments.

| Column Name               | Column Type | Column Description                                                                                             |
| ------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------- |
| node\_id                  | UUID        | Universally Unique IDentifier (UUID) of the node that owns the segments included in these statistics.          |
| table\_id                 | UUID        | UUID of the table of this column (sys.tables).                                                                 |
| ordinal                   | INT         | Ordinal of the column.                                                                                         |
| is\_deltadelta\_enabled   | BOOLEAN     | Specifies whether deltadelta compression is enabled.                                                           |
| is\_rle\_enabled          | BOOLEAN     | Specifies whether RLE compression scheme is enabled.                                                           |
| is\_ne\_enabled           | BOOLEAN     | Specifies whether the NULL elimination compression scheme is enabled.                                          |
| raw\_size                 | LONG        | Size of the data in bytes before compression.                                                                  |
| compressed\_size          | LONG        | Size of the data in bytes after compression.                                                                   |
| num\_deltadelta\_blocks   | LONG        | Number of data blocks compressed using the deltadelta compression.                                             |
| num\_rle\_blocks          | LONG        | Number of data blocks compressed using the RLE (Run-Length Encoding) compression scheme.                       |
| num\_nerle\_blocks        | LONG        | Number of data blocks compressed using a combination of the RLE and NE (NULL Elimination) compression schemes. |
| num\_uncompressed\_blocks | LONG        | Number of uncompressed data blocks.                                                                            |
| num\_total\_blocks        | LONG        | Total number of data blocks.                                                                                   |
| id                        | UUID        | UUID of the column                                                                                             |
| name                      | CHAR        | Name of the column                                                                                             |

### sys.segments\_compression\_info

This table contains segment-level compression statistics. The system calculates statistics from the data within the specified segment. All block statistics apply only to fixed-length columns within the segment. Non-block specific statistics (e.g., size information) include both fixed and variable-length columns.

| Column Name                  | Column Type | Column Description                                                                                        |
| ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------------- |
| table\_id                    | UUID        | Universally Unique IDentifier (UUID) of the table relevant to this segment (sys.tables).                  |
| segment\_id                  | UUID        | UUID for the segment.                                                                                     |
| num\_deltadelta\_blocks      | LONG        | Number of data blocks compressed using deltadelta compression                                             |
| num\_rle\_blocks             | LONG        | Number of data blocks compressed using RLE (Run-Length Encoding) compression scheme                       |
| num\_nerle\_blocks           | LONG        | Number of data blocks compressed using a combination of RLE and NE (Null Elimination) compression schemes |
| num\_uncompressed\_blocks    | LONG        | Number of uncompressed data blocks                                                                        |
| num\_total\_blocks           | LONG        | Total number of data blocks                                                                               |
| raw\_size                    | LONG        | Size of the data part before any compression and without any parity data                                  |
| compressed\_size             | LONG        | Size of the data part after compression and without any parity data + Size of the manifest part           |
| compressed\_data\_part\_size | LONG        | Size of the data part after compression and without any parity data                                       |
| num\_cluster\_keys           | LONG        | Number of unique cluster keys in the segment                                                              |
| num\_time\_buckets           | LONG        | Number of time buckets in the segment                                                                     |

### sys.stats\_files

This table contains information about the on-disk cache for each Foundation Node of the local table probability density functions (PDFs) and array PDFs.

| Column Name          | Column Type | Column Description                                                                                                                                               |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| node\_id             | UUID        | The Universally Unique IDentifier (UUID) of the node. References id in sys.nodes.                                                                                |
| table\_id            | UUID        | The UUID of the table. References id in sys.tables.                                                                                                              |
| file\_id             | UUID        | The UUID of the file.                                                                                                                                            |
| file\_type           | CHAR        | The type of this file. Values are ARRAY\_PDF, TABLE\_PDF, or TABLE\_CDE.                                                                                         |
| file\_size           | LONG        | Size in bytes of the file.                                                                                                                                       |
| column\_ordinal      | LONG        | Ordinal of the column where the stats file applies. The ordinal references sys.columns for the specified table. The value is NULL when file\_type is TABLE\_PDF. |
| updated\_at          | TIMESTAMP   | Timestamp of the last update to this file.                                                                                                                       |
| is\_stale            | BOOLEAN     | Whether any rows are present on disk that were not present when this stats file was last updated                                                                 |
| rows\_computed\_from | LONG        | Number of rows present on the node when this stats file was last updated                                                                                         |
| marked\_stale\_at    | TIMESTAMP   | Timestamp of this file being marked stale.                                                                                                                       |

### sys.table\_cardinalities

This table contains estimates of the number of rows in the individual tables in the database. These estimates might not reflect recent loading or deletion activity.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| table\_id   | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| cardinality | LONG        | Estimate of the number of rows in this table.                   |

### sys.vl\_columns\_compression\_info

This table contains column-level compression statistics for variable-length columns. The system calculates statistics from the column data across all segments.

| Column Name              | Column Type | Column Description                                                                                    |
| ------------------------ | ----------- | ----------------------------------------------------------------------------------------------------- |
| node\_id                 | UUID        | Universally Unique IDentifier (UUID) of the node that owns the segments included in these statistics. |
| table\_id                | UUID        | UUID of the table (sys.tables).                                                                       |
| ordinal                  | INT         | Ordinal of the column.                                                                                |
| is\_compression\_enabled | BOOLEAN     | Whether compression is enabled.                                                                       |
| raw\_size                | LONG        | Size of the data in bytes before compression.                                                         |
| compressed\_size         | LONG        | Size of the data in bytes after compression.                                                          |
| num\_lz4\_rows           | LONG        | Number of lz4 compressed rows.                                                                        |
| num\_uncompressed\_rows  | LONG        | Number of uncompressed rows.                                                                          |
| num\_null\_rows          | LONG        | Number of NULL rows.                                                                                  |
| num\_total\_rows         | LONG        | Total number of rows.                                                                                 |
| id                       | UUID        | UUID of the column                                                                                    |
| name                     | CHAR        | Name of the column                                                                                    |

## Storage

### sys.addendum\_directories

This table contains all addendum directories with details about their associated directories and metadata.

| Column Name                           | Column Type | Column Description                                                                                                                                     |
| ------------------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| id                                    | UUID        | The identifier of the addendum directory within the storage cluster state.                                                                             |
| associated\_directory\_group\_id      | CHAR        | The group identifier of the associated directory.                                                                                                      |
| associated\_directory\_ida\_offset    | INT         | The IDA offset (the logical segment in a segment directory group) of the associated directory.                                                         |
| parent\_segment\_group\_id            | CHAR        | The segment group identifier of the associated parent segment (sys.segment\_groups).                                                                   |
| parent\_ida\_offset                   | INT         | The IDA offset of the associated parent segment.                                                                                                       |
| segment\_part\_inventory\_name        | UUID        | The name of the segment part inventory for the addendum part. This name references the id column of the segment\_part\_inventory system catalog table. |
| segment\_part\_inventory\_storage\_id | CHAR        | The storage identifier of the segment part inventory.                                                                                                  |
| num\_deleted\_rows                    | LONG        | If the segment part inventory houses a delete part, this number is the number of rows subtracted from the parent segment.                              |
| is\_replica\_for\_ida\_offset         | INT         | The IDA offset of the parent segment that this segment part inventory replicates.                                                                      |

### sys.current\_osn

This table contains the current Ownership Sequence Number (OSN) for each cluster on the system.

| Column Name | Column Type | Column Description                                       |
| ----------- | ----------- | -------------------------------------------------------- |
| start\_osn  | CHAR        | The start OSN for the cluster.                           |
| end\_osn    | CHAR        | The end OSN for the cluster.                             |
| cluster\_id | UUID        | The Universally Unique IDentifier (UUID) of the cluster. |

### sys.data\_usage

This table contains information about the amount of queryable data for each table and file type.

| Column Name             | Column Type | Column Description                                                               |
| ----------------------- | ----------- | -------------------------------------------------------------------------------- |
| segment\_type           | VARCHAR     | The type of the segment.                                                         |
| database\_name          | VARCHAR     | The name of the database for the table.                                          |
| schema                  | VARCHAR     | The schema of the table.                                                         |
| name                    | VARCHAR     | The name of the table.                                                           |
| num\_segments           | BIGINT      | The number of segments of a specific segment type.                               |
| total\_rows             | BIGINT      | The total number of rows for segments of a specific segment type.                |
| avg\_rows\_per\_segment | DOUBLE      | The average amount of rows per segment for a segment of a specific segment type. |
| total\_size\_gb         | DOUBLE      | The total size in gigabytes for all segments of a specific segment type.         |
| avg\_size\_mb           | DOUBLE      | The average size in megabytes for segments of a specific segment type.           |

### sys.degraded\_segment\_groups

This table contains information about degraded segment groups in addition to the clusters and tables where they are located.

| Column Name               | Column Type | Column Description                                       |
| ------------------------- | ----------- | -------------------------------------------------------- |
| cluster\_id               | UUID        | The unique identifier of the cluster.                    |
| cluster\_name             | VARCHAR     | The name of the cluster.                                 |
| segment\_group\_status    | VARCHAR     | The segment group status.                                |
| database\_name            | VARCHAR     | The name of the database for the table.                  |
| schema                    | VARCHAR     | The schema of the table.                                 |
| name                      | VARCHAR     | The name of the table.                                   |
| degraded\_segment\_groups | BIGINT      | The total number of damaged segment groups in a cluster. |

### sys.merge\_eligibilities

This table computes and displays a count of segment groups and segment directory groups eligible for merging for each table in the Ocient System.

| Column Name                      | Column Type | Column Description                                              |
| -------------------------------- | ----------- | --------------------------------------------------------------- |
| id                               | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| database\_name                   | VARCHAR     | Name of the database for the table.                             |
| schema                           | VARCHAR     | Name of the schema.                                             |
| name                             | VARCHAR     | Name of the table.                                              |
| segment\_groups\_merge\_eligible | BIGINT      | The count of segment groups eligible for merging in the table.  |

### sys.merge\_policies

This table computes and displays the effective merge policy (enabled or disabled) for each table in the system. The system bases the policy on the default configuration and any overrides that are present for each table.

| Column Name                     | Column Type | Column Description                                                                                                                                                    |
| ------------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                              | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables).                                                                                                       |
| database\_name                  | VARCHAR     | Name of the database for the table.                                                                                                                                   |
| schema                          | VARCHAR     | Name of the schema.                                                                                                                                                   |
| name                            | VARCHAR     | Name of the table.                                                                                                                                                    |
| table\_lts\_property\_string    | VARCHAR     | Additional properties assigned to control the Foundation role (formerly "LTS role") behavior for the table.                                                           |
| effective\_table\_merge\_policy | VARCHAR     | The effective merge policy applied to this table based on the value of the global `feature_directory_merge` feature flag and an optional table merge policy override. |

### sys.orphaned\_segments

This table contains information about orphaned segments in the cluster.

| Column Name   | Column Type | Column Description                                                      |
| ------------- | ----------- | ----------------------------------------------------------------------- |
| storage\_id   | UUID        | The Universally Unique IDentifier (UUID) for the orphaned segment.      |
| owner         | LONG        | The identifier of the owner for this orphaned segment.                  |
| segment\_type | CHAR        | The type of the segment (TKT, PAGE, etc.).                              |
| node\_id      | UUID        | The UUID for this setting, which might be NULL for system-wide metrics. |

### sys.segment\_directories

This table contains all segment directories with details about parents, associated buckets, and metadata.

| Column Name                | Column Type | Column Description                                                                                                                                                                                                                                               |
| -------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| segment\_group\_id         | CHAR        | The identifier of the segment group (sys.segment\_groups).                                                                                                                                                                                                       |
| ida\_offset                | INT         | The unique index of the segment.                                                                                                                                                                                                                                 |
| storage\_id                | UUID        | The storage identifier of the segment directory.                                                                                                                                                                                                                 |
| owner                      | LONG        | The owner identifier of this stored segment.                                                                                                                                                                                                                     |
| table\_id                  | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables).                                                                                                                                                                                                  |
| begin\_time                | LONG        | Start time of the bucket of this segment directory in the time bucket column of its table.                                                                                                                                                                       |
| end\_time                  | LONG        | End time of the bucket of this segment directory in the time bucket column of its table.                                                                                                                                                                         |
| depth                      | INT         | The depth of the segment group. A non-zero value indicates a segment directory group.                                                                                                                                                                            |
| parent\_segment\_group\_id | CHAR        | The parent identifier of the segment directory group (sys.segment\_groups).                                                                                                                                                                                      |
| parent\_ida\_offset        | INT         | The unique index of the parent segment, if it exists.                                                                                                                                                                                                            |
| parent\_storage\_id        | UUID        | The storage identifier of the parent segment directory, if it exists.                                                                                                                                                                                            |
| parent\_owner              | LONG        | The owner of the parent storage identifier. A zero value indicates an unowned storage identifier. Whereas a non-zero value indicates a segment owned after rebuild.                                                                                              |
| row\_count                 | LONG        | If the directory depth equals 1, then this count is the number of rows in the base leaf segment (not factoring in any DELETE SQL statements). If the depth is greater than 1, then this count is the total number of rows spanned by the intermediate directory. |
| created\_time              | TIMESTAMP   | Specifies the time, in nanoseconds, when this segment group was created.                                                                                                                                                                                         |
| rolehostd\_version         | CHAR        | The version of the rolehostd binary at the time of the segment group generation.                                                                                                                                                                                 |

### sys.segment\_group\_transfers

This table contains all segment group transfers between clusters.

| Column Name         | Column Type | Column Description                                                                                                       |
| ------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------ |
| id                  | UUID        | Universally Unique IDentifier (UUID) of the segment group transfer.                                                      |
| src\_cluster\_id    | UUID        | UUID of the source cluster (sys.clusters).                                                                               |
| dst\_cluster\_id    | UUID        | UUID of the destination cluster (sys.clusters).                                                                          |
| status              | CHAR        | The status of the transfer.                                                                                              |
| segment\_group\_ids | ARRAY(CHAR) | List of the identifiers of segment groups in this transfer (sys.segment\_groups).                                        |
| src\_committed\_osn | CHAR        | The Ownership Storage Number (OSN) in which the segment groups are considered fully transferred from the source cluster. |
| dst\_committed\_osn | CHAR        | The OSN in which the segment groups are considered fully transferred from the destination cluster.                       |

### sys.segment\_groups

This table contains all segment groups stored on the cluster with details about the ownership, associated table, data structure, and other metadata.

| Column Name         | Column Type | Column Description                                                                                                                                                                                                                                                                                                                                                                                                |
| ------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                  | CHAR        | The identifier of the segment group.                                                                                                                                                                                                                                                                                                                                                                              |
| cluster\_id         | UUID        | Universally Unique IDentifier (UUID) of the internal cluster of this segment group.                                                                                                                                                                                                                                                                                                                               |
| segment\_type       | CHAR        | Type of the segment (TKT, PAGE, etc.).                                                                                                                                                                                                                                                                                                                                                                            |
| status              | CHAR        | The availability and health status of the segment group.                                                                                                                                                                                                                                                                                                                                                          |
| primary\_owner      | UUID        | For a replicated segment group, the UUID of the node that serves the segment (sys.nodes).                                                                                                                                                                                                                                                                                                                         |
| loader\_id          | UUID        | The streamloader node that wrote the segment group (sys.nodes).                                                                                                                                                                                                                                                                                                                                                   |
| table\_id           | UUID        | UUID of the table (sys.tables).                                                                                                                                                                                                                                                                                                                                                                                   |
| scope\_id           | UUID        | UUID of the storage scope (sys.storage\_scopes).                                                                                                                                                                                                                                                                                                                                                                  |
| block\_size         | LONG        | Disk block size used to store segments in this group in bytes.                                                                                                                                                                                                                                                                                                                                                    |
| begin\_time         | LONG        | Inclusive minimum bucket value, specified as an integer, for all rows in this segment group. If the bucket column is a date or time value, this column has the same unit of measure as defined by the TimeKey column and you can convert or compare it to other dates or times with the appropriate conversion functions. When you specify a TIMESTAMP TimeKey, the value represents nanoseconds after the epoch. |
| end\_time           | LONG        | Inclusive maximum bucket value, specified as an integer, for all rows in this segment group. If the bucket column is a date or time value, this column has the same unit of measure as defined by the TimeKey column and you can convert or compare it to other dates or times with the appropriate conversion functions. When you specify a TIMESTAMP TimeKey, the value represents nanoseconds after the epoch. |
| begin\_timestamp    | TIMESTAMP   | Inclusive minimum bucket value, specified as a TIMESTAMP, for all rows in this segment group. If the bucket column is a unitless integer, this column is NULL.                                                                                                                                                                                                                                                    |
| end\_timestamp      | TIMESTAMP   | Inclusive maximum bucket value, specified as an integer, for all rows in this segment group. If the bucket column is a unitless integer, this column is NULL.                                                                                                                                                                                                                                                     |
| coding\_algorithm   | CHAR        | Coding algorithm used to erasure code this group (NO\_CODING, PQ\_PARITY, REED\_SOLOMON).                                                                                                                                                                                                                                                                                                                         |
| coding\_block\_size | INT         | The unit size that is erasure coded in bytes.                                                                                                                                                                                                                                                                                                                                                                     |
| coding\_threshold   | INT         | The number of coding blocks required to rebuild all blocks in a coding line.                                                                                                                                                                                                                                                                                                                                      |
| coding\_width       | INT         | The number of coding blocks in a coding line.                                                                                                                                                                                                                                                                                                                                                                     |
| replication         | INT         | The number of replicas of each segment in the group.                                                                                                                                                                                                                                                                                                                                                              |
| parity\_cycle       | INT         | Parity cycle that the system calculates by multiplying by the coding\_width to return the number of segments in the segment group.                                                                                                                                                                                                                                                                                |
| created\_time       | TIMESTAMP   | Specifies the time, in nanoseconds, when this segment group was created.                                                                                                                                                                                                                                                                                                                                          |
| rolehostd\_version  | CHAR        | The version of the rolehostd binary at the time of the segment group generation.                                                                                                                                                                                                                                                                                                                                  |
| commit\_hash        | CHAR        | The commit hash of the rolehostd binary at the time of the segment group generation.                                                                                                                                                                                                                                                                                                                              |
| timestamp           | CHAR        | The build timestamp or commit timestamp of the rolehostd binary at the time of the segment group generation.                                                                                                                                                                                                                                                                                                      |
| build\_user         | CHAR        | The build user of the rolehostd binary at the time of the segment group generation.                                                                                                                                                                                                                                                                                                                               |
| depth               | INT         | The depth of the segment directory group. A non-zero value indicates a segment directory group.                                                                                                                                                                                                                                                                                                                   |
| removal\_type       | CHAR        | The method by which a segment group was removed.                                                                                                                                                                                                                                                                                                                                                                  |
| visibility          | CHAR        | The visibility of the segment group.                                                                                                                                                                                                                                                                                                                                                                              |

### sys.segment\_part\_inventory

This table contains information about the inventory of markers for segments. For example, a marker denotes whether the database can delete a specific segment part. One segment can have multiple inventories, whereas each inventory contains only one marker.

| Column Name                | Column Type | Column Description                                                                                                                                                                  |
| -------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                         | UUID        | The universally unique identifier (UUID) of the inventory that stores the markers for segments.                                                                                     |
| ida\_offset                | INT         | The IDA offset (the logical part of the segment) denotes the position within the segment.                                                                                           |
| parent\_segment\_group\_id | CHAR        | The identifier of the segment group where the parent segment is located.                                                                                                            |
| parent\_ida\_offset        | INT         | The IDA offset where the parent segment is located within the segment group.                                                                                                        |
| num\_deleted\_rows         | LONG        | The number of deleted rows.                                                                                                                                                         |
| operation\_id              | UUID        | The UUID of the query where the Ocient System creates the inventory (the `DELETE` SQL statement). The system shares this UUID across all inventories created in the same operation. |
| subsuming\_type            | CHAR        | The type of the marker within the inventory.                                                                                                                                        |
| node\_id                   | UUID        | The UUID of the node that contains the latest segment with the part.                                                                                                                |

### sys.segment\_part\_redundancy\_info

This table contains the redundancy strategy for each table and the segment part type.

| Column Name      | Column Type | Column Description                                              |
| ---------------- | ----------- | --------------------------------------------------------------- |
| table\_id        | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| part\_name       | CHAR        | Name of the segment part.                                       |
| redundancy\_type | CHAR        | The redundancy strategy for this part (COPY, PARITY).           |

### sys.segment\_parts

This table contains the segment parts associated with each segment group. These segment parts belong to queryable segments. The table does not display parts that belong to quarantined segments or segments not yet activated.

| Column Name          | Column Type | Column Description                                                                           |
| -------------------- | ----------- | -------------------------------------------------------------------------------------------- |
| segment\_group\_id   | CHAR        | The identifier of the segment group (sys.segment\_groups).                                   |
| ida\_offset          | INT         | Unique index of the segment. The original copy of this segment part belongs to this segment. |
| name                 | CHAR        | Name of the segment part.                                                                    |
| part\_type           | CHAR        | Partial identifier of a segment part (DATA, INDEX, MANIFEST, STATS).                         |
| size                 | LONG        | Size of the segment part in bytes.                                                           |
| segment\_ida\_offset | INT         | Unique index of a segment within a segment group.                                            |
| segment\_lba\_offset | LONG        | Offset of this segment part within the Logical Block Address (LBA) on disk.                  |

### sys.segments

This table contains the individual segments stored in each storage cluster including basic information about the segment and the segment group where the segment belongs. The table contains queryable segments only. Quarantined segments or segments not yet activated do not appear in this table (they are present in the sys.stored\_segments table).

| Column Name                                  | Column Type | Column Description                                                                                                                                                                                                                                                                                                                                                                                          |
| -------------------------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| segment\_group\_id                           | CHAR        | The identifier of the segment group (sys.segment\_groups).                                                                                                                                                                                                                                                                                                                                                  |
| segment\_type                                | CHAR        | Type of the segment (TKT or PAGE).                                                                                                                                                                                                                                                                                                                                                                          |
| ida\_offset                                  | INT         | Unique index of the segment in the segment group.                                                                                                                                                                                                                                                                                                                                                           |
| row\_count                                   | LONG        | Count of accessible rows in the segment. If the count is unknown, the value is NULL.                                                                                                                                                                                                                                                                                                                        |
| storage\_id                                  | UUID        | Universally Unique IDentifier (UUID) for the stored segment (sys.stored\_segments.storage\_id).                                                                                                                                                                                                                                                                                                             |
| table\_id                                    | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables).                                                                                                                                                                                                                                                                                                                                             |
| segment\_size                                | LONG        | Size of the segment in bytes.                                                                                                                                                                                                                                                                                                                                                                               |
| root\_segment\_directory\_group\_id          | CHAR        | The identifier of the root-level segment directory group to which this segment belongs. For root-level directories and non-subsumed segments, this value is the same as the `segment_group_id` column.                                                                                                                                                                                                      |
| root\_segment\_directory\_group\_ida\_offset | INT         | The unique index of the directory in the root-level directory group to which this segment belongs.                                                                                                                                                                                                                                                                                                          |
| begin\_time                                  | LONG        | Inclusive minimum bucket value, specified as an integer, for all rows in this segment. If the bucket column is a date or time value, this column has the same unit of measure as defined by the TimeKey column and you can convert or compare it to other dates or times with the appropriate conversion functions. When you specify a TIMESTAMP TimeKey, the value represents nanoseconds after the epoch. |
| end\_time                                    | LONG        | Inclusive maximum bucket value, specified as an integer, for all rows in this segment. If the bucket column is a date or time value, this column has the same unit of measure as defined by the TimeKey column and you can convert or compare it to other dates or times with the appropriate conversion functions. When you specify a TIMESTAMP TimeKey, the value represents nanoseconds after the epoch. |
| begin\_timestamp                             | TIMESTAMP   | Inclusive minimum bucket value, specified as a TIMESTAMP, for all rows in this segment. If the bucket column is a unitless integer, this column is NULL.                                                                                                                                                                                                                                                    |
| end\_timestamp                               | TIMESTAMP   | Inclusive maximum bucket value, specified as an integer, for all rows in this segment. If the bucket column is a unitless integer, this column is NULL.                                                                                                                                                                                                                                                     |
| owner                                        | LONG        | Owner identifier of this stored segment.                                                                                                                                                                                                                                                                                                                                                                    |
| num\_deleted\_rows                           | LONG        | Number of rows deleted from this segment.                                                                                                                                                                                                                                                                                                                                                                   |
| page\_size\_with\_replication                | LONG        | Specifies the replication of stored pages.                                                                                                                                                                                                                                                                                                                                                                  |

### sys.stop\_osn\_reap\_requests

This table contains the list of requests to stop reaping the Ownership Sequence Number (OSN). When the system adds a request to this table, the storage cluster stops reaping OSNs until all requests are removed.

| Column Name | Column Type | Column Description                                          |
| ----------- | ----------- | ----------------------------------------------------------- |
| request\_id | UUID        | The Universally Unique IDentifier (UUID) of the request.    |
| created\_at | TIMESTAMP   | The timestamp that represents when the request was created. |
| description | CHAR        | The description of the request.                             |
| cluster\_id | UUID        | The UUID of the cluster.                                    |

### sys.storage\_capacity

This table contains information about storage capacity for each node.

| Column Name     | Column Type | Column Description                                            |
| --------------- | ----------- | ------------------------------------------------------------- |
| node\_id        | UUID        | Universally Unique IDentifier (UUID) of the node (sys.nodes). |
| capacity\_bytes | LONG        | Approximate storage capacity of the node in bytes.            |
| cluster\_id     | UUID        | UUID of the cluster (sys.clusters).                           |

### sys.storage\_device\_files

This table contains the list of all files for each storage device.

| Column Name             | Column Type | Column Description                                                                                                                                                                            |
| ----------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| node\_id                | UUID        | The unique identifier of the node.                                                                                                                                                            |
| device\_id              | INT         | The numeric identifier of the drive.                                                                                                                                                          |
| storage\_id             | UUID        | The unique identifier of the file.                                                                                                                                                            |
| owner                   | LONG        | Owner of the storage identifier. The zero value indicates an unowned storage identifier. A non-zero value indicates a segment owned after the rebuild.                                        |
| segment\_type           | CHAR        | The type of the segment (TKT, PAGE, etc.).                                                                                                                                                    |
| parent\_id              | UUID        | The unique identifier of the parent file (for addendum parts).                                                                                                                                |
| normalized\_drive\_slot | INT         | Theoretical drive slot, if applicable, that was computed from the segment group identifier. The Ocient System expects to allocate the file to this slot.                                      |
| abnormal\_placement     | BOOLEAN     | Specifies whether the Ocient System places the segment abnormally. If this value is `true`, the segment is not located on the drive slot that was computed from the segment group identifier. |
| segment\_group\_id      | CHAR        | The identifier of the segment group (sys.segment\_groups).                                                                                                                                    |

### sys.storage\_scopes

This table contains the storage scopes defined in the system with the number of rows, page groups, and segment groups in each storage scope.

| Column Name               | Column Type | Column Description                                                 |
| ------------------------- | ----------- | ------------------------------------------------------------------ |
| id                        | UUID        | Universally Unique IDentifier (UUID) of the storage scope.         |
| row\_count                | LONG        | The number of rows that have been currently loaded onto the scope. |
| num\_page\_groups         | LONG        | The number of page groups currently present in the scope.          |
| num\_tkt\_segment\_groups | LONG        | Number of TKT segment groups currently present in the scope.       |
| scope\_prefix\_len        | INT         | The prefix length of the scope.                                    |
| transaction\_timeout      | LONG        | The transaction timeout of the scope.                              |
| creation\_timestamp       | TIMESTAMP   | The timestamp when the scope was created.                          |
| last\_activity\_timestamp | TIMESTAMP   | The timestamp when the scope was last updated.                     |
| cluster\_id               | UUID        | UUID of the cluster (sys.clusters).                                |

### sys.storage\_spaces

This table contains information for all defined storage spaces.

| Column Name                | Column Type | Column Description                                                                                             |
| -------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------- |
| id                         | UUID        | Universally Unique IDentifier (UUID) of the storage space.                                                     |
| name                       | CHAR        | Name of the storage space.                                                                                     |
| is\_system\_storage\_space | BOOLEAN     | Is this storage space the system storage space                                                                 |
| block\_size                | INT         | Unit size that is erasure coded in bytes.                                                                      |
| total\_width               | INT         | The coding width. (The N in an M of N parity configuration.)                                                   |
| parity\_width              | INT         | Within a coding line, the number of blocks dedicated to storing parity information.                            |
| parity\_type               | CHAR        | The methodology used to compute parity blocks (P+Q, XOR, REED SOLOMON, REPLICATION, NONE).                     |
| parity\_cycles             | INT         | Parity cycles calculated by multiplying by total\_width to return the number of segments in the segment group. |
| page\_replication          | INT         | The total number of page replicas, which includes the original page.                                           |

### sys.storage\_used

This table contains information about storage utilization for each node.

| Column Name | Column Type | Column Description                                                 |
| ----------- | ----------- | ------------------------------------------------------------------ |
| node\_id    | UUID        | Universally Unique IDentifier (UUID) of the node (sys.nodes).      |
| table\_id   | UUID        | UUID of the table (sys.tables).                                    |
| used\_bytes | LONG        | Approximate storage utilization of the table on the node in bytes. |
| cluster\_id | UUID        | UUID of the cluster (sys.clusters).                                |

### sys.stored\_leaf\_segment\_part\_inventory

This table contains the physical location for the inventory of markers for all segments.

| Column Name                | Column Type | Column Description                                                                                  |
| -------------------------- | ----------- | --------------------------------------------------------------------------------------------------- |
| segment\_group\_id         | CHAR        | The identifier of the segment group (sys.segment\_groups).                                          |
| cluster\_id                | UUID        | Universally Unique IDentifier (UUID) of the cluster (sys.clusters).                                 |
| ida\_offset                | INT         | Index of the segment in the segment group.                                                          |
| storage\_id                | UUID        | UUID of the stored segment.                                                                         |
| owner                      | LONG        | Owner identifier of the stored segment.                                                             |
| root\_directory\_group\_id | CHAR        | Root segment directory identifier, if it has been subsumed.                                         |
| node\_id                   | UUID        | UUID of the node (sys.nodes).                                                                       |
| start\_osn                 | CHAR        | The starting Ownership Sequence Number (OSN) for the latest OSN range of the inventory of markers.  |
| end\_osn                   | CHAR        | The ending OSN for the latest OSN range of the inventory of markers.                                |
| kind                       | CHAR        | The kind of segment (DISK, VIRTUAL).                                                                |
| visibility                 | CHAR        | The visibility of the inventory of markers.                                                         |
| toc\_name                  | UUID        | UUID of the inventory of markers. A NULL UUID denotes the main inventory of markers of the segment. |
| row\_count                 | LONG        | The number of rows in the base leaf segment (not factoring in any DELETE SQL statements).           |

### sys.stored\_segments

This table contains details for each segment that is saved to disk.

| Column Name         | Column Type | Column Description                                                                                                                                                                                                                                                                                                                     |
| ------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| segment\_group\_id  | CHAR        | The identifier of the segment group (sys.segment\_groups).                                                                                                                                                                                                                                                                             |
| cluster\_id         | UUID        | Universally Unique IDentifier (UUID) of the cluster (sys.clusters).                                                                                                                                                                                                                                                                    |
| ida\_offset         | INT         | Index of the segment in the segment group.                                                                                                                                                                                                                                                                                             |
| storage\_id         | UUID        | UUID of this stored segment.                                                                                                                                                                                                                                                                                                           |
| owner               | LONG        | Owner identifier of this stored segment.                                                                                                                                                                                                                                                                                               |
| node\_id            | UUID        | UUID of the node (sys.nodes).                                                                                                                                                                                                                                                                                                          |
| status              | CHAR        | The current status of the segment (MISSING, INTACT, etc.).                                                                                                                                                                                                                                                                             |
| kind                | CHAR        | The kind of segment (DISK, VIRTUAL).                                                                                                                                                                                                                                                                                                   |
| start\_osn          | CHAR        | The start OSN for the latest OSN range of the segment.                                                                                                                                                                                                                                                                                 |
| end\_osn            | CHAR        | The end OSN for the latest OSN range of the segment.                                                                                                                                                                                                                                                                                   |
| visibility          | CHAR        | The visibility of the stored segment. Valid values are VISIBLE (segment is queryable), QUARANTINED (segment is not queryable), HIDDEN (segment is hidden), and INVALID (segment is invalid). During segment generation, the Ocient System can make segments hidden or invalid for a short period before the segments become queryable. |
| abnormal\_placement | BOOLEAN     | Whether the segment is placed abnormally.                                                                                                                                                                                                                                                                                              |
| row\_count          | LONG        | Count of rows in the segment.                                                                                                                                                                                                                                                                                                          |
| segment\_size       | LONG        | Size of the segment in bytes.                                                                                                                                                                                                                                                                                                          |

### sys.unhealthy\_segments

This table contains information about nodes with damaged, missing, or invalid segments.

| Column Name              | Column Type | Column Description                                                             |
| ------------------------ | ----------- | ------------------------------------------------------------------------------ |
| node\_id                 | UUID        | The unique identifier of the node.                                             |
| node\_name               | VARCHAR     | The name of the node.                                                          |
| status                   | VARCHAR     | The status of the stored segment. Values include INTACT, MISSING, and DAMAGED. |
| num\_unhealthy\_segments | BIGINT      | The total number of unhealthy segments in the node.                            |

## System

### sys.clusters

This table contains all clusters defined in the system.

| Column Name         | Column Type | Column Description                                                         |
| ------------------- | ----------- | -------------------------------------------------------------------------- |
| id                  | UUID        | Universally Unique IDentifier (UUID) of the cluster (sys.clusters.id).     |
| name                | CHAR        | Name of the cluster.                                                       |
| cluster\_type       | CHAR        | Type of the cluster.                                                       |
| storage\_space\_ids | ARRAY(UUID) | UUIDs of the storage spaces used in this cluster (sys.storage\_spaces.id). |

### sys.compute\_configurations

This table contains the compute configurations for nodes and clusters in the system.

| Column Name | Column Type | Column Description                                                                               |
| ----------- | ----------- | ------------------------------------------------------------------------------------------------ |
| cluster\_id | UUID        | Universally Unique IDentifier (UUID) of the cluster that this node belongs to (sys.clusters.id). |
| node\_id    | UUID        | UUID of the node (sys.nodes.id).                                                                 |
| level       | LONG        | Execution level for this node or cluster.                                                        |
| csn         | LONG        | Compute sequence number.                                                                         |

### sys.locks

This table contains information of the currently queued and granted lock requests.

| Column Name              | Column Type | Column Description                                                                                                                                      |
| ------------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| request\_id              | UUID        | The unique identifier of the lock.                                                                                                                      |
| owner\_identifier        | CHAR        | The unique identifier of the owner of the lock. Should be of format `<node uuid with lowercase chars>.<locking system>.<locking reason>.<process uuid>` |
| lock\_scope\_id          | CHAR        | An identifier on the scope of the lock, should be of format `<system>.<type>.<target unique identifier>`                                                |
| lock\_type               | CHAR        | Whether the lock is to READ or WRITE on the elements in its scope.                                                                                      |
| status                   | CHAR        | The status of the lock, QUEUED means that it is waiting to be accepted, GRANTED means it is currently active.                                           |
| create\_time             | LONG        | The creation time, in milliseconds, of the lock relative to the underlying RAFT Consensus Log. This value is not a UNIX timestamp.                      |
| last\_refresh\_time      | LONG        | The time, in milliseconds, when the lock was last refreshed relative to the underlying RAFT Consensus Log. This value is not a UNIX timestamp           |
| priority\_id             | UUID        | The identifier for lock prioritization.                                                                                                                 |
| create\_timestamp        | TIMESTAMP   | The timestamp that represents when the lock was created on the Raft leader.                                                                             |
| last\_refresh\_timestamp | TIMESTAMP   | The timestamp that represents when the lock was most recently refreshed on the Raft leader.                                                             |

### sys.lts\_cluster\_info

This table contains the storage clusters defined in the system.

| Column Name         | Column Type | Column Description                                                             |
| ------------------- | ----------- | ------------------------------------------------------------------------------ |
| cluster\_id         | UUID        | Universally Unique IDentifier (UUID) of the storage cluster (sys.clusters.id). |
| storage\_space\_ids | ARRAY(UUID) | UUIDs of the storage spaces used in this cluster (sys.storage\_spaces.id).     |

### sys.node\_clusters

This table contains nodes that are members of each cluster.

| Column Name | Column Type | Column Description                                                             |
| ----------- | ----------- | ------------------------------------------------------------------------------ |
| cluster\_id | UUID        | Universally Unique IDentifier (UUID) of the cluster that this node belongs to. |
| node\_id    | UUID        | UUID of the node.                                                              |
| ordinal     | INT         | Ordinal of this node.                                                          |

### sys.nodes

This table contains all nodes defined in the system.

| Column Name          | Column Type | Column Description                                  |
| -------------------- | ----------- | --------------------------------------------------- |
| id                   | UUID        | Universally Unique IDentifier (UUID) of the node.   |
| unique\_node\_number | INT         | Ordinal number assigned to the node.                |
| name                 | CHAR        | Name of the node.                                   |
| status               | CHAR        | Status of the node (ACCEPTED, UNACCEPTED, INVALID). |
| hostname             | CHAR        | Hostname of the node.                               |
| software\_version    | CHAR        | Version of the software running on this node.       |
| kernel\_version      | CHAR        | Version of the kernel running on this node.         |
| system\_version      | CHAR        | Version of Linux® running on this node.             |
| system\_memory       | LONG        | Amount of available system memory in bytes.         |
| sockets              | INT         | Number of CPU sockets.                              |
| cores\_per\_socket   | INT         | Number of cores per CPU socket.                     |
| hugepages\_1gb       | INT         | Number of configured 1GB huge pages.                |
| hugepages\_2mb       | INT         | Number of configured 2MB huge pages.                |
| hyperthreaded        | BOOLEAN     | Whether the node is hyperthreaded.                  |

### sys.service\_roles

This table contains the service roles defined on each node.

| Column Name         | Column Type | Column Description                                        |
| ------------------- | ----------- | --------------------------------------------------------- |
| id                  | UUID        | Universally Unique IDentifier (UUID) of the service role. |
| service\_role\_type | CHAR        | Type of the service role.                                 |
| node\_id            | UUID        | UUID of the node. (sys.nodes.id)                          |
| level               | CHAR        | Execution level of the node.                              |

## System Information

### sys.function\_signatures

This table contains all function signatures defined in the system.

| Column Name    | Column Type | Column Description                                              |
| -------------- | ----------- | --------------------------------------------------------------- |
| id             | UUID        | Universally Unique IDentifier (UUID) of the function signature. |
| name           | CHAR        | Name of the function.                                           |
| return\_type   | CHAR        | Return type of the function.                                    |
| arg\_types     | ARRAY(CHAR) | The types of all arguments in the function.                     |
| function\_type | CHAR        | Type of the function.                                           |

### sys.reserved\_words

This table contains all reserved words defined in Ocient.

| Column Name    | Column Type | Column Description                                   |
| -------------- | ----------- | ---------------------------------------------------- |
| reserved\_word | CHAR        | A word that is a reserved keyword for use by Ocient. |

### sys.sql\_messages

This table contains information about the SQL errors and warnings that the Ocient System can produce.

| Column Name | Column Type | Column Description                                      |
| ----------- | ----------- | ------------------------------------------------------- |
| name        | CHAR        | SQL error or warning name.                              |
| code        | INT         | SQL error or warning code.                              |
| state       | CHAR        | SQL error or warning state.                             |
| reason      | CHAR        | Description of the SQL error or warning.                |
| is\_error   | BOOLEAN     | Whether or not this SQL message is an error or warning. |

### sys.system\_information

This table contains information about the Ocient System.

| Column Name                            | Column Type | Column Description                                                                                                                                                                                        |
| -------------------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                                     | UUID        | Universally Unique Identifier (UUID) for the overall system.                                                                                                                                              |
| name                                   | CHAR        | The name of the system. This system assigns this name randomly using a UUID by default. You can change the name using the `ALTER SYSTEM RENAME` SQL statement.                                            |
| current\_compatible\_software\_version | INT         | The minimum software version for the system compatibility.                                                                                                                                                |
| allowed\_compatible\_software\_version | INT         | The software version that prevents the use of features in the newest version of the system to keep backward compatibility with the specified version in the `current_compatible_software_version` column. |
| feature\_directory\_merge              | CHAR        | The value of the `directory merge` feature flag for segment directory groups.                                                                                                                             |

### sys.system\_table\_columns

This table contains all columns for tables available in the system catalog.

| Column Name  | Column Type | Column Description                                                     |
| ------------ | ----------- | ---------------------------------------------------------------------- |
| id           | UUID        | The Universally Unique IDentifier (UUID) of this column (sys.columns). |
| name         | CHAR        | The name of this column.                                               |
| data\_type   | CHAR        | The data type of the column.                                           |
| nullable     | BOOLEAN     | Whether or not this column is nullable.                                |
| ordinal      | LONG        | The ordinal of this column.                                            |
| schema\_name | CHAR        | The name of the schema to which this column belongs.                   |
| table\_name  | CHAR        | The name of the table to which this column belongs.                    |
| description  | CHAR        | Description of the column.                                             |

### sys.system\_tables

This table contains all tables available in the system catalog.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| id          | UUID        | Universally Unique IDentifier (UUID) of the table (sys.tables). |
| schema      | CHAR        | Schema of the table.                                            |
| name        | CHAR        | Name of the table.                                              |
| table\_type | CHAR        | Type of the table.                                              |
| category    | CHAR        | Category of the table.                                          |
| description | CHAR        | Description of the table.                                       |

## User Management

### sys.group\_roles

This table contains roles that belong to each group.

| Column Name | Column Type | Column Description                                              |
| ----------- | ----------- | --------------------------------------------------------------- |
| group\_id   | UUID        | Universally Unique IDentifier (UUID) of the group (sys.groups). |
| role\_id    | UUID        | UUID of the role (sys.roles).                                   |

### sys.groups

This table contains information, including the service class, related to each group.

| Column Name        | Column Type | Column Description                                              |
| ------------------ | ----------- | --------------------------------------------------------------- |
| id                 | UUID        | Universally Unique IDentifier (UUID) of the group.              |
| name               | CHAR        | Name of the group.                                              |
| database\_id       | UUID        | UUID of the database (sys.databases).                           |
| service\_class\_id | UUID        | UUID of the service class of this group (sys.service\_classes). |

### sys.privileges

This table contains information related to the privileges granted in Ocient.

| Column Name       | Column Type | Column Description                                                                                                    |
| ----------------- | ----------- | --------------------------------------------------------------------------------------------------------------------- |
| timestamp         | TIMESTAMP   | Timestamp of the grant given.                                                                                         |
| grantor           | CHAR        | The user who granted this privilege.                                                                                  |
| grantee           | CHAR        | The user who received this privilege.                                                                                 |
| privilege         | CHAR        | The privilege for the grant.                                                                                          |
| privilege\_target | CHAR        | The type of object to which the privilege applies. This value is NULL if the privilege applies to the granted object. |
| object\_type      | CHAR        | The type of object on which this privilege was granted.                                                               |
| object\_id        | UUID        | Universally Unique IDentifier (UUID) of the object.                                                                   |
| grantable         | BOOLEAN     | Whether the user can grant this privilege to another user.                                                            |

### sys.rights

This table contains information related to the rights granted in Ocient.

| Column Name  | Column Type | Column Description                                              |
| ------------ | ----------- | --------------------------------------------------------------- |
| entity\_type | CHAR        | Owner of the right (user, group, role).                         |
| entity\_id   | UUID        | Universally Unique IDentifier (UUID) of the owner.              |
| target\_type | CHAR        | Type of the target.                                             |
| target\_id   | UUID        | UUID of the target.                                             |
| value        | CHAR        | The right being given (CREATE, READ, UPDATE, DELETE, SECURITY). |

### sys.roles

This table contains roles in the system.

| Column Name  | Column Type | Column Description                                 |
| ------------ | ----------- | -------------------------------------------------- |
| id           | UUID        | Universally Unique IDentifier (UUID) of the role.  |
| database\_id | UUID        | UUID of the database of this role (sys.databases). |
| name         | CHAR        | Name of this role.                                 |
| description  | CHAR        | Detailed description of this role.                 |

### sys.user\_groups

This table contains the users that belong to groups in Ocient.

| Column Name | Column Type | Column Description                                            |
| ----------- | ----------- | ------------------------------------------------------------- |
| user\_id    | UUID        | Universally Unique IDentifier (UUID) of the user (sys.users). |
| group\_id   | UUID        | UUID of the group where the user belongs (sys.groups).        |

### sys.user\_roles

This table contains roles associated with each user.

| Column Name | Column Type | Column Description                                            |
| ----------- | ----------- | ------------------------------------------------------------- |
| user\_id    | UUID        | Universally Unique IDentifier (UUID) of the user (sys.users). |
| role\_id    | UUID        | UUID of the role (sys.roles).                                 |

### sys.users

This table contains information about users in Ocient.

| Column Name               | Column Type | Column Description                                                                                                        |
| ------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------- |
| id                        | UUID        | Universally Unique IDentifier (UUID) of the user.                                                                         |
| user\_name                | CHAR        | Username.                                                                                                                 |
| database\_id              | UUID        | UUID of the database.                                                                                                     |
| first\_name               | CHAR        | First name of the user.                                                                                                   |
| last\_name                | CHAR        | Last name of the user.                                                                                                    |
| email                     | CHAR        | Email address of the user.                                                                                                |
| password\_updated\_at     | TIMESTAMP   | Timestamp that represents the date and time for the last time the password for this user was updated                      |
| state                     | CHAR        | State.                                                                                                                    |
| invalid\_login\_attempts  | INT         | Number of invalid login attempts after the last successful login.                                                         |
| password\_days\_remaining | INT         | Number of days remaining until the password expires. If you do not configure the password expiration, this value is NULL. |

## Workload Management

### sys.service\_classes

This table shows information about the service classes used for workload management in Ocient. For more details on workload management, see the corresponding section of the user documentation.

| Column Name                      | Column Type | Column Description                                                                                                                                                                                                                                                                                                              |
| -------------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                               | UUID        | The ID of the service class.                                                                                                                                                                                                                                                                                                    |
| database\_id                     | UUID        | The ID of the database that has the service class.                                                                                                                                                                                                                                                                              |
| name                             | CHAR        | The name of the service class.                                                                                                                                                                                                                                                                                                  |
| max\_temp\_disk\_usage           | LONG        | The maximum temporary disk usage for a query running with this service class.                                                                                                                                                                                                                                                   |
| max\_elapsed\_time               | LONG        | The maximum time, in seconds, that a query running with this service class can run.                                                                                                                                                                                                                                             |
| max\_concurrent\_queries         | LONG        | The maximum number of queries that can run concurrently with this service class.                                                                                                                                                                                                                                                |
| max\_rows\_returned              | LONG        | The maximum number of rows a query running with this service class can return.                                                                                                                                                                                                                                                  |
| scheduling\_priority             | DOUBLE      | The initial priority for a query running with this service class.                                                                                                                                                                                                                                                               |
| cache\_max\_bytes                | LONG        | The maximum number of bytes in a result set, if it is eligible for cache storage, for a query running with this service class.                                                                                                                                                                                                  |
| cache\_max\_time                 | LONG        | The maximum amount of time, in seconds, that the system caches rows for a query running with this service class.                                                                                                                                                                                                                |
| max\_elapsed\_time\_for\_caching | LONG        | The maximum amount of time, in seconds, that a query running with this service class can run and have its result set cached. This value must be higher than the `max_elapsed_time` value.                                                                                                                                       |
| max\_columns\_in\_result\_set    | LONG        | The maximum number of columns allowed in the result set of a query running with this service class.                                                                                                                                                                                                                             |
| priority\_adjustment\_factor     | DOUBLE      | The amount that the system adjusts the query priority in each time interval, as specified by the `priority_adjustment_time` value, for a query running with this service class.                                                                                                                                                 |
| priority\_adjustment\_time       | LONG        | The frequency, in seconds, of each priority adjustment for a query running with this service class.                                                                                                                                                                                                                             |
| min\_priority                    | DOUBLE      | The minimum value of the adjusted priority for a query running with this service class.                                                                                                                                                                                                                                         |
| max\_priority                    | DOUBLE      | The maximum value of the adjusted priority for a query running with this service class.                                                                                                                                                                                                                                         |
| statement\_text                  | CHAR        | Specifies the comparison string to use for matching statement text to queries. This string takes the format specified by the statement\_text\_matcher\_type field.                                                                                                                                                              |
| statement\_text\_matcher\_type   | CHAR        | Specifies the type of string comparison to use for matching statement text to queries. This value must be LIKE or REGEX and is required if you specify a 'statement\_text' field.                                                                                                                                               |
| half\_parallelism                | BOOLEAN     | Determines whether the VM uses half of the available cores for each operator in this query rather than the maximum possible parallelism. Setting this value can reduce overhead and latency for queries, but it significantly decreases data throughput. So, updating this value should be rare outside of Ocient Support work. |
| load\_balance\_shuffle           | BOOLEAN     | Determines whether the optimizer includes a load-balancing network operator above I/O for each query. This field can add latency to queries, but it will likely increase data throughput. If unset, the choice is left to the optimizer. So, updating this value should be rare outside of Ocient Support work.                 |
| parallelism                      | INT         | Determines the number of parallel cores to use for each operator in the VM. This value must be nonzero. If unset, the choice is left to the VM. So, updating this value should be rare outside of Ocient Support work.                                                                                                          |
| minimize\_query\_debug\_records  | BOOLEAN     | This value determines whether the optimizer and VM should attempt to limit debug metrics and logging for queries associated with this service class. Limiting query observability may improve performance for workloads running many queries per second.                                                                        |
| memory\_optimal\_strategy        | BOOLEAN     | This value determines whether the optimizer and VM should attempt to lower the memory requirements of a query regardless of potential execution time penalties. So, updating this value should be rare outside of Ocient Support work.                                                                                          |
| is\_system\_managed              | BOOLEAN     | This value indicates whether or not the service class is a system managed service class.                                                                                                                                                                                                                                        |

### sys.service\_classes\_for\_user

The `service_classes_for_user` table shows groups that each user belongs to and the service class for each group.

| Column Name          | Column Type | Column Description             |
| -------------------- | ----------- | ------------------------------ |
| user\_name           | VARCHAR     | Username.                      |
| group\_name          | VARCHAR     | Name of the group.             |
| service\_class\_name | VARCHAR     | The name of the service class. |

# Related Links

[Information Schema](https://docs.ocient.com/information-schema)
