> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/gridgain/gridgain-9/reference/monitoring/system-views.md).
# System Views
Reference of the built-in SQL system views in the GridGain 9 SYSTEM schema, with the columns and data types of each view.
GridGain provides a number of built-in SQL views that provide information on the cluster's state and provide real-time insight into the status of its components. These views are available in the SYSTEM schema.
## Getting Data
You access system views in GridGain by using SQL and selecting data from the system view like you would from any other table. For example, you can get a list of all available system views in the following way:
```sql
SELECT * FROM system.system_views;
```
You can also use joins to combine data from multiple views. The example below returns all columns of a view that was found in the `SYSTEM_VIEWS` view:
```sql
SELECT svc.*
FROM system.system_view_columns svc
JOIN system.system_views sv ON svc.view_id = sv.id
WHERE sv.name = 'SYSTEM_VIEWS';
```
## Available Views
### COMPUTE\_TASKS
| Column | Data Type | Description |
| --------------------------- | ------------------------------ | ------------------------------------------- |
| COORDINATOR\_NODE\_ID | STRING | The task's coordinator node ID. |
| COMPUTE\_TASK\_ID | STRING | The compute task ID. |
| COMPUTE\_TASK\_STATUS | STRING | The task status. |
| COMPUTE\_TASK\_CREATE\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | The task creation timestamp. |
| COMPUTE\_TASK\_START\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | The task start timestamp. |
| COMPUTE\_TASK\_FINISH\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | The task finish timestamp. |
| ID | STRING | **Deprecated**. The compute task ID. |
| STATUS | STRING | **Deprecated**.The task status. |
| CREATE\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | **Deprecated**.The task creation timestamp. |
| START\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | **Deprecated**.The task start timestamp. |
| FINISH\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | **Deprecated**.The task finish timestamp. |
### GLOBAL\_ZONE\_PARTITION\_STATES
| Column | Data Type | Description |
| ---------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ZONE\_NAME | STRING | Name of the zone. |
| ZONE\_ID | INT32 | Internal identifier of the zone. |
| PARTITION\_ID | INT32 | Identifier of the partition. |
| PARTITION\_STATE | STRING | Current state of the partition. Possible values:
• AVAILABLE – All replicas are healthy.
• DEGRADED – There are healthy replicas, and they form a majority.
• READ\_ONLY – There are healthy replicas, but they don’t form a majority.
• UNAVAILABLE – There are no healthy replicas.
|
### INDEXES
| Column | Data Type | Description |
| ----------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| INDEX\_ID | INT32 | Unique index identifier. |
| INDEX\_NAME | STRING | The name of the index. |
| TABLE\_ID | INT32 | Unique table identifier. |
| TABLE\_NAME | STRING | The name of the table. |
| SCHEMA\_ID | INT32 | Unique schema identifier. |
| SCHEMA\_NAME | STRING | The name of the schema. |
| INDEX\_TYPE | STRING | The type of the index. Possible values: `HASH`, `SORTED`. |
| IS\_UNIQUE\_INDEX | BOOLEAN | If the index is unique. |
| INDEX\_COLUMNS | STRING | The list of indexed columns. |
| INDEX\_STATE | STRING | Current status of the index. Possible values:
• REGISTERED - Index has been registered and is awaiting the start of building,
• BUILDING - Index is being built,
• AVAILABLE - Index is built and is ready to use,
• STOPPING - DROP INDEX command has been executed, index is waiting for running transactions to finish.
|
| TYPE | STRING | **Deprecated**. The type of the index. Possible values: `HASH`, `SORTED`. |
| IS\_UNIQUE | BOOLEAN | **Deprecated**. If the index is unique. |
| COLUMNS | STRING | **Deprecated**. The list of indexed columns. |
| STATUS | STRING | Deprecated. Current status of the index. Possible values:
• REGISTERED - Index has been registered and is awaiting the start of building,
• BUILDING - Index is being built,
• AVAILABLE - Index is built and is ready to use,
• STOPPING - DROP INDEX command has been executed, index is waiting for running transactions to finish.
|
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this index. |
### INDEX\_COLUMNS
| Column | Data Type | Description |
| ----------------- | --------- | ------------------------------------------------------------------- |
| SCHEMA\_ID | INT32 | Unique schema identifier. |
| SCHEMA\_NAME | STRING | The name of the schema. |
| TABLE\_ID | INT32 | Unique table identifier. |
| TABLE\_NAME | STRING | The name of the table. |
| INDEX\_ID | INT32 | Unique index identifier. |
| INDEX\_NAME | STRING | The name of the index. |
| COLUMN\_NAME | STRING | Column name. |
| COLUMN\_ORDINAL | INT32 | The ordinal number of the column in the index definition. |
| COLUMN\_COLLATION | STRING | Collation rules for the column. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this index column. |
### LICENSES
| Column | Data Type | Description |
| --------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------- |
| LICENSE\_ID | STRING | The license ID. |
| LICENSE\_EDITION | STRING | License edition. |
| LICENSE\_COMMON\_INFO | STRING | A list of key-value pairs providing information about the license requester/owner. |
| LICENSE\_LIMITS | STRING | A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc. |
| LICENSE\_FEATURES | STRING | A list of GridGain features the license grants to the user. |
| ID | STRING | **Deprecated**. The license ID. |
| EDITION | STRING | **Deprecated**. License edition. |
| INFOS | STRING | **Deprecated**. A list of key-value pairs providing information about the license requester/owner. |
| LIMITS | STRING | **Deprecated**. A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc. |
| FEATURES | STRING | **Deprecated**. A list of GridGain features the license grants to the user. |
### LOCAL\_ZONE\_PARTITION\_STATES
| Column | Data Type | Description |
| ---------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| NODE\_NAME | STRING | Name of the node reporting the partition state. |
| ZONE\_NAME | STRING | Name of the zone. |
| ZONE\_ID | INT32 | Internal identifier of the zone. |
| ESTIMATED\_ROWS | INT64 | Approximate number of rows stored in this partition on the local node. |
| PARTITION\_ID | INT32 | Identifier of the partition. |
| PARTITION\_STATE | STRING | Current state of the local partition. Possible values:
• UNAVAILABLE – This state might be used when partition is not yet started, or it's already stopping, for example.
• HEALTHY – Alive partition with a healthy state machine.
• INITIALIZING – Partition is starting right now.
• INSTALLING\_SNAPSHOT – Partition is installing a Raft snapshot from the leader.
• CATCHING\_UP – Partition is catching up, meaning that it's not replicated part of the log yet.
• BROKEN – Partition is in broken state, usually it means that its state machine thrown an exception.
|
### LOCKS
A node system view that lists the currently active locks.
| Column | Data Type | Description |
| ---------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| OWNING\_NODE\_ID | STRING | The ID of the node that owns the lock. |
| TRANSACTION\_ID | STRING | The ID of the transaction that created the lock. |
| OBJECT\_ID | STRING | The ID of the locked object. |
| LOCK\_MODE | STRING | The lock mode. Possible values are:
• IS - intention shared lock
• S- shared lock
• IX - intention exclusive lock
• SIX - shared intention exclusive lock
• X - exclusive lock
|
| TX\_ID | STRING | **Deprecated**. The ID of the transaction that created the lock. |
| MODE | STRING | Deprecated. The lock mode. Possible values are:
• IS - intention shared lock
• S- shared lock
• IX - intention exclusive lock
• SIX - shared intention exclusive lock
• X - exclusive lock
|
### POLICIES
| Column | Data Type | Description |
| ---------------- | --------- | -------------------------------------------------------------- |
| SCHEMA\_NAME | STRING | The name of the schema. |
| SCHEMA\_ID | INT32 | Unique schema identifier. |
| TABLE\_NAME | STRING | The name of the table. |
| TABLE\_ID | INT32 | Unique table identifier. |
| POLICY\_NAME | STRING | The name of the policy. |
| POLICY\_ID | INT32 | Unique policy identifier. |
| ROLES | STRING | The comma-separated list of roles the policy applies to. |
| CONDITION | STRING | A boolean SQL expression over the columns of the target table. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this policy. |
### SCHEMAS
| Column | Data Type | Description |
| ---------------- | --------- | ------------------------------------------------------------- |
| SCHEMA\_ID | INT32 | Unique schema identifier. |
| SCHEMA\_NAME | STRING | The name of the schema. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this schema. |
### SEQUENCES
| Column | Data Type | Description |
| ------------------------ | --------- | ------------------------------------------------------------------------------------------- |
| SEQUENCE\_ID | INT32 | The ID of the sequence. |
| SEQUENCE\_NAME | STRING | The name of the sequence. |
| SEQUENCE\_DATA\_TYPE | STRING | The sequence data type. |
| SEQUENCE\_INCREMENT | INT64 | How much the sequence is incremented by each time. |
| SEQUENCE\_MINIMUM\_VALUE | INT64 | Minimum sequence value. |
| SEQUENCE\_MAXIMUM\_VALUE | INT64 | Maximum sequence value. |
| SEQUENCE\_START\_VALUE | INT64 | The starting value of the sequence. |
| SEQUENCE\_CACHE\_VALUE | INT64 | The amount of sequence numbers that are pre-allocated and stored in memory. |
| ID | INT32 | **Deprecated**. The ID of the sequence. |
| NAME | STRING | **Deprecated**. The name of the sequence. |
| SCHEMA\_ID | INT32 | The id of the schema used by the sequence. |
| SCHEMA\_NAME | STRING | The name of the schema used by the sequence. |
| DATA\_TYPE | STRING | **Deprecated**. The sequence data type. |
| INCREMENT | INT64 | **Deprecated**. How much the sequence is incremented by each time. |
| MINIMUM\_VALUE | INT64 | **Deprecated**. Minimum sequence value. |
| MAXIMUM\_VALUE | INT64 | **Deprecated**. Maximum sequence value. |
| START\_VALUE | INT64 | **Deprecated**. The starting value of the sequence. |
| CACHE\_VALUE | INT64 | **Deprecated**. The amount of sequence numbers that are pre-allocated and stored in memory. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this sequence. |
### SQL\_QUERIES
| Column | Data Type | Description |
| ------------------------- | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| INITIATOR\_NODE | STRING | The name of the node that initiated the query. |
| QUERY\_ID | STRING | The query ID. |
| USERNAME | STRING | The name of the user who started the query. |
| QUERY\_PHASE | STRING | The query phase:
• INITIALIZATION - query registration and parsing
• OPTIMIZATION - query validation and plan optimization
• EXECUTION - query plan execution
|
| QUERY\_TYPE | STRING | The query type: DDL, DML, QUERY, or SCRIPT. |
| QUERY\_DEFAULT\_SCHEMA | STRING | The name of the default schema that was used to execute the query. |
| SQL | STRING | The SQL query's expression. Password literals in `CREATE USER` and `ALTER USER` statements are replaced with `'******'`, including statements inside a multi-statement script. |
| QUERY\_START\_TIME | TIMESTAMP | The date/time the query started. |
| TRANSACTION\_ID | STRING | The ID of the transaction in which the query was executed. |
| PARENT\_QUERY\_ID | STRING | ID of the script that initiated the query (NULL if the query was not initiated by a script). |
| QUERY\_STATEMENT\_ORDINAL | INT32 | The ordinal number of the query. |
| ID | STRING | **Deprecated**. The query ID. |
| PHASE | STRING | Deprecated. The query phase:
• INITIALIZATION - query registration and parsing
• OPTIMIZATION - query validation and plan optimization
• EXECUTION - query plan execution
|
| TYPE | STRING | **Deprecated**. The query type: DDL, DML, QUERY, or SCRIPT. |
| SCHEMA | STRING | **Deprecated**. The name of the default schema that was used to execute the query. |
| START\_TIME | TIMESTAMP | **Deprecated**. The date/time the query started. |
| PARENT\_ID | STRING | **Deprecated**. ID of the script that initiated the query (NULL if the query was not initiated by a script). |
| STATEMENT\_NUM | INT32 | **Deprecated**. The ordinal number of the query. |
| QUERY\_RETRY\_COUNT | INT32 | The number of times the query was retried. 0 if the query was not retried. |
| QUERY\_RETRY\_REASON | STRING | The error message that triggered the most recent retry. NULL if the query was not retried. |
### SQL\_CACHED\_QUERY\_PLANS
| Column | Data Type | Description |
| ---------------------- | ------------------------------ | -------------------------------------------------------------- |
| NODE\_ID | STRING | ID of the node where the plan is cached. |
| PLAN\_ID | STRING | Internal identifier of the prepared plan. |
| CATALOG\_VERSION | INT32 | Catalog version used when the query was prepared. |
| QUERY\_DEFAULT\_SCHEMA | STRING | Default schema applied during query preparation. |
| SQL | STRING | Normalized SQL text of the query. |
| QUERY\_TYPE | STRING | Query type. |
| QUERY\_PLAN | STRING | Serialized or explain representation of the chosen query plan. |
| QUERY\_PREPARE\_TIME | TIMESTAMP WITH LOCAL TIME ZONE | Time the plan was prepared on the node. |
### SYSTEM\_VIEWS
Describes available system views.
| Column | Data Type | Description |
| ---------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| VIEW\_ID | INT32 | System view ID. |
| SCHEMA\_NAME | STRING | Name of the schema used. Default is `SYSTEM`. |
| VIEW\_NAME | STRING | System view name. |
| VIEW\_TYPE | STRING | System view type. Possible values:
• NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view.
• CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.
|
| ID | INT32 | **Deprecated**. System view ID. |
| SCHEMA | STRING | **Deprecated**. Name of the schema used. Default is `SYSTEM`. |
| NAME | STRING | **Deprecated**. System view name. |
| TYPE | STRING | Deprecated. System view type. Possible values:
• NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view.
• CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.
|
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this system view. |
### SYSTEM\_VIEW\_COLUMNS
Describes available system view columns.
| Column | Data Type | Description |
| -------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------ |
| VIEW\_ID | INT32 | System view ID. |
| VIEW\_NAME | STRING | System view name. |
| COLUMN\_NAME | STRING | Column name. |
| COLUMN\_TYPE | STRING | Column type. Can be any of the [supported types](/docs/gridgain/gridgain-9/reference/sql/data-types.md). |
| IS\_NULLABLE\_COLUMN | BOOLEAN | Defines if the column can be empty. |
| COLUMN\_PRECISION | INT32 | Maximum number of digits. |
| COLUMN\_SCALE | INT32 | Maximum number of decimal places. |
| COLUMN\_LENGTH | INT32 | Maximum length of the value. Symbols for string values or bytes for binary values. |
| NAME | STRING | **Deprecated**. Column name. |
| TYPE | STRING | **Deprecated**. Column type. Can be any of the [supported types](/docs/gridgain/gridgain-9/reference/sql/data-types.md). |
| NULLABLE | BOOLEAN | **Deprecated**. Defines if the column can be empty. |
| PRECISION | INT32 | **Deprecated**. Maximum number of digits. |
| SCALE | INT32 | **Deprecated**. Maximum number of decimal places. |
| LENGTH | INT32 | **Deprecated**. Maximum length of the value. Symbols for string values or bytes for binary values. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this system view column. |
### TABLES
| Column | Data Type | Description |
| --------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| SCHEMA\_NAME | STRING | The schema used by the table. |
| TABLE\_NAME | STRING | Table name. |
| TABLE\_ID | INT32 | Unique table identifier. |
| TABLE\_PK\_INDEX\_ID | INT32 | The identifier of the primary key index. |
| ZONE\_NAME | STRING | The distribution zone the table belongs to. |
| STORAGE\_PROFILE | STRING | The storage profile the table uses. |
| TABLE\_COLOCATION\_COLUMNS | STRING | The name of the column that is used to colocate data. |
| SCHEMA\_ID | STRING | The identifier of the schema used by the table. |
| ZONE\_ID | STRING | The identifier of the zone the table belongs to. |
| IS\_CACHE | BOOLEAN | Defines if it is a [cache](/docs/gridgain/gridgain-9/gridgain9-development/caches-and-memory/caches.md). |
| SECONDARY\_ZONE\_ID | INT32 | The identifier of the distribution zone used for secondary storage. Returns `NULL` if the table does not have secondary storage configured. |
| SECONDARY\_ZONE\_NAME | STRING | The name of the distribution zone used for secondary storage. Returns `NULL` if the table does not have secondary storage configured. |
| SECONDARY\_STORAGE\_PROFILE | STRING | The name of the storage profile used for secondary storage. Returns `NULL` if the table does not have secondary storage configured. |
| SECONDARY\_STORAGE\_STATE | STRING | The current synchronization state of secondary storage. Possible values:
• NOT\_AVAILABLE - The table does not have secondary storage configured.
• SYNCING - Secondary storage is being synchronized with primary storage.
• AVAILABLE - Secondary storage is synchronized and available for queries.
|
| SCHEMA | STRING | **Deprecated**. The schema used by the table. |
| NAME | STRING | **Deprecated**. Table name. |
| ID | INT32 | **Deprecated**. Unique table identifier. |
| PK\_INDEX\_ID | INT32 | **Deprecated**. The identifier of the primary key index. |
| COLOCATION\_KEY\_INDEX | STRING | **Deprecated**. The name of the column that is used to colocate data. |
| ZONE | STRING | **Deprecated**. The distribution zone the table belongs to. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this table. |
| EXPIRE\_COLUMN\_ID | INT32 | The identifier of the column used for row [expiration](/docs/gridgain/gridgain-9/gridgain9-development/caches-and-memory/expiry-policies.md). Returns `NULL` if the table has no expiration column. |
| EXPIRE\_COLUMN\_NAME | STRING | The name of the column used for row [expiration](/docs/gridgain/gridgain-9/gridgain9-development/caches-and-memory/expiry-policies.md). Returns `NULL` if the table has no expiration column. |
| ARCHIVE\_COLUMN\_ID | INT32 | The identifier of the column used for [archiving](/docs/gridgain/gridgain-9/gridgain9-development/accessing-data/data-archiving.md). Returns `NULL` if the table has no archive column. |
| ARCHIVE\_COLUMN\_NAME | STRING | The name of the column used for archiving. Returns `NULL` if the table has no archive column. |
| PROPERTIES | STRING | The table options set with the `WITH (...)` clause, in the form `MIN STALE ROWS , STALE ROWS FRACTION `. Tables created without these options show the defaults: `MIN STALE ROWS 500, STALE ROWS FRACTION 0.2`. |
| TABLE\_SCHEMA\_VERSION | INT32 | The latest schema version of the table. The version increases every time the table's schema changes, for example when a column is added or dropped. |
### TABLE\_COLUMNS
| Column | Data Type | Description |
| --------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| SCHEMA\_NAME | STRING | The schema used by the table. |
| TABLE\_NAME | STRING | Table name. |
| TABLE\_ID | INT32 | Unique table identifier. |
| COLUMN\_NAME | STRING | Column name. |
| COLUMN\_TYPE | STRING | Column data type. |
| IS\_NULLABLE\_COLUMN | BOOLEAN | If the column can be `NULL`. |
| COLUMN\_PRECISION | INT32 | Value precision. 0 if not applicable to data type. |
| COLUMN\_SCALE | INT32 | Value scale. 0 if not applicable to data type. |
| COLUMN\_LENGTH | INT32 | Value length, in bytes. |
| COLUMN\_ORDINAL | INT32 | The ordinal number of the column. |
| SCHEMA\_ID | INT32 | The id of the schema used by the sequence. |
| PK\_COLUMN\_ORDINAL | INT32 | Zero-based position of the column in the primary key. `NULL` if the column is not part of the primary key. |
| COLOCATION\_COLUMN\_ORDINAL | INT32 | Zero-based position of the column in the colocation key. `NULL` if the column is not part of the primary key. |
| SCHEMA | STRING | **Deprecated**. The schema used by the table. |
| TYPE | STRING | **Deprecated**. Column data type. |
| NULLABLE | BOOLEAN | **Deprecated**. If the column can be `NULL`. |
| PREC | INT32 | **Deprecated**. Value precision. 0 if not applicable to data type. |
| SCALE | INT32 | **Deprecated**. Value scale. 0 if not applicable to data type. |
| LENGTH | INT32 | **Deprecated**. Value length, in bytes. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this table column. |
| DEFAULT\_VALUE | STRING | The SQL representation of the column's default value, or `NULL` if default is `NULL` or is not set. Literals are shown in SQL form (for example, `'hello'`, `42`, `DATE '2020-01-01'`, `x'AABBCCDDEEFF'`). Function-based defaults are shown as their call form (for example, `RAND_UUID`, `NEXTVAL('SEQ_NAME')`, `CURRENT_TIMESTAMP + INTERVAL '7' DAYS`). |
### TRANSACTIONS
{% hint style="info" %}
This view shows only the currently active transactions.
{% endhint %}
| Column | Data Type | Description |
| ------------------------ | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| COORDINATOR\_NODE\_ID | STRING | The name of the transaction's coordinator node. |
| TRANSACTION\_STATE | STRING | The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished. |
| TRANSACTION\_ID | STRING | The transaction ID. |
| TRANSACTION\_START\_TIME | TIMESTAMP | The transaction's start time. |
| TRANSACTION\_TYPE | STRING | The transaction type: READ\_ONLY or READ\_WRITE. |
| TRANSACTION\_PRIORITY | STRING | The transaction priority, which is used to resolve conflicts between transactions. This value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default). |
| TRANSACTION\_LABEL | STRING | The label of the transaction, if any. Labels are assigned to transaction creation, and persist for the lifetime. Labels are only available for read-write transactions. |
| STATE | STRING | **Deprecated**. The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished. |
| ID | STRING | **Deprecated**. The transaction ID. |
| START\_TIME | TIMESTAMP | **Deprecated**. The transaction's start time. |
| TYPE | STRING | **Deprecated**. The transaction type: READ\_ONLY or READ\_WRITE. |
| PRIORITY | STRING | **Deprecated**. The transaction priority, which is used to resolve conflicts between transactions. This value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default). |
### ZONES
| Column | Data Type | Description |
| -------------------------------------- | --------- | -------------------------------------------------------------------------------------------------------- |
| ZONE\_NAME | STRING | The name of the distribution zone. |
| ZONE\_PARTITIONS | INT32 | The number of partitions in the distribution zone. |
| ZONE\_REPLICAS | STRING | The number of copies of each partition in the distribution zone. |
| DATA\_NODES\_AUTO\_ADJUST\_SCALE\_UP | INT32 | The delay in seconds between the new node joining and the start of data zone adjustment. |
| DATA\_NODES\_AUTO\_ADJUST\_SCALE\_DOWN | INT32 | The delay in seconds between the node leaving the cluster and the start of data zone adjustment. |
| DATA\_NODES\_FILTER | STRING | The filter that specifies what nodes will be used by the distribution zone. |
| IS\_DEFAULT\_ZONE | BOOLEAN | If the data zone is used by default. |
| ZONE\_CONSISTENCY\_MODE | STRING | The zone's consistency mode. Possible values: `STRONG_CONSISTENCY`, `HIGH_AVAILABILITY`. |
| ZONE\_ID | INT32 | Unique zone identifier. |
| NAME | STRING | **Deprecated**. The name of the distribution zone. |
| PARTITIONS | INT32 | **Deprecated**. The number of partitions in the distribution zone. |
| REPLICAS | STRING | **Deprecated**. The number of copies of each partition in the distribution zone. |
| CONSISTENCY\_MODE | STRING | **Deprecated**. The zone's consistency mode. Possible values: `STRONG_CONSISTENCY`, `HIGH_AVAILABILITY`. |
| CATALOG\_VERSION | INT32 | The version of the current catalog that contains this distribution zone. |
### ZONE\_STORAGE\_PROFILES
| Column | Data Type | Description |
| -------------------- | --------- | -------------------------------------------------------------- |
| ZONE\_NAME | STRING | The name of the distribution zone. |
| STORAGE\_PROFILE | STRING | The name of the storage profile used by the distribution zone. |
| IS\_DEFAULT\_PROFILE | BOOLEAN | If the storage profile is used by default. |
| ZONE\_ID | INT32 | Unique zone identifier. |