Resources
Database Files Virtual Table
Overview
The oxla_home_files
virtual table lists all files associated with a specific table in the oxla home directory. This approach offers a more reliable way to retrieve data than simply scanning files directly.
Fields
Field | Content | Type |
---|---|---|
path | Absolute path from the oxla working directory | TEXT |
byte_size | Size of the file in bytes | BIGINT |
start_index | First index in the file, if applicable | NULLABLE TEXT |
end_index | Last index in the file, if applicable | NULLABLE TEXT |
row_count | Number of rows in the file | BIGINT |
batch_count | Number of batches the file is divided into | BIGINT |
table_id | ID of the related table | BIGINT |
namespace_id | ID of the related namespace | BIGINT |
database_id | ID of the related database | BIGINT |
Example Query
This example shows how to query the oxla_home_files
table in an Oxla instance.
Scenario 1: Empty Result
- Run the
oxla_home_files
query below.
- When the
oxla_home_files
table is empty, the query returns an empty result set.
Scenario 2: After Data Insertion
- Create and insert data to the table.
- Run the
oxla_home_files
query below.
- After inserting data into the table, the query lists the file metadata stored in Oxla.