System Catalogs
Data Task Stability
Overview
The oxla_data_task_stability
table provides information about the stability of data tasks for tables within Oxla.
- Data tasks are background processes responsible for normalizing and maintaining data layouts
- The stability status indicates whether the table’s files have been processed and are up-to-date
- Regardless of the stability status the table is ready to be queried
Example
When running the command below:
you will get the following output:
Table Schema
Column Name | Data Type | Constraints | Description |
---|---|---|---|
table_id | BIGINT | NOT NULL | Unique identifier for the table |
namespace_id | BIGINT | NOT NULL | Identifier for the namespace that the table belongs to |
database_id | BIGINT | NOT NULL | Identifier for the database where the table is located |
is_stable | BOOL | NOT NULL | Indicates the state of the data task. false means the files are either being processed or queued for processing. true means the files have been processed, are stable and this state persists until the user updates the data in the table |
You can join the
table_id
, namespace_id
and database_id
columns with other virtual tables to obtain human-readable names for the table, namespace and database