Tables

List tables in namespace

Deprecated

GET/accounts/{account_id}/r2-catalog/{bucket_name}/namespaces/{namespace}/tables

ModelsExpand Collapse

TableListResponse object { identifiers, details, next_page_token, table_uuids }

Contains the list of tables with optional pagination.

identifiers: array of object { name, namespace }

Lists tables in the namespace.

name: string

Specifies the table name.

namespace: array of string

Specifies the hierarchical namespace parts as an array of strings. For example, [“bronze”, “analytics”] represents the namespace “bronze.analytics”.

details: optional array of object { identifier, table_uuid, created_at, 3 more }

Contains detailed metadata for each table when return_details is true. Each object includes identifier, UUID, timestamps, and locations.

identifier: object { name, namespace }

Specifies a unique table identifier within a catalog.

name: string

Specifies the table name.

namespace: array of string

Specifies the hierarchical namespace parts as an array of strings. For example, [“bronze”, “analytics”] represents the namespace “bronze.analytics”.

table_uuid: string

Contains the UUID that persists across renames.

formatuuid

created_at: optional string

Indicates the creation timestamp in ISO 8601 format.

formatdate-time

location: optional string

Specifies the base S3 URI for table storage location.

metadata_location: optional string

Contains the S3 URI to table metadata file. Null for staged tables.

updated_at: optional string

Shows the last update timestamp in ISO 8601 format. Null if never updated.

formatdate-time

next_page_token: optional string

Use this opaque token to fetch the next page of results. A null or absent value indicates the last page.

table_uuids: optional array of string

Contains UUIDs for each table when return_uuids is true. The order corresponds to the identifiers array.

TablesMaintenance Configs

Get table maintenance configuration

Deprecated

GET/accounts/{account_id}/r2-catalog/{bucket_name}/namespaces/{namespace}/tables/{table_name}/maintenance-configs

Update table maintenance configuration

Deprecated

POST/accounts/{account_id}/r2-catalog/{bucket_name}/namespaces/{namespace}/tables/{table_name}/maintenance-configs

ModelsExpand Collapse

MaintenanceConfigGetResponse object { maintenance_config }

Contains table maintenance configuration.

maintenance_config: object { compaction, interval, snapshot_expiration }

Configures maintenance for the table.

compaction: optional object { state, target_size_mb, next_eligible_at }

Configures compaction settings for table optimization.

state: "enabled" or "disabled"

Specifies the state of maintenance operations.

One of the following:

"enabled"

"disabled"

target_size_mb: "64" or "128" or "256" or "512"

Sets the target file size for compaction in megabytes. Defaults to “128”.

One of the following:

"64"

"128"

"256"

"512"

next_eligible_at: optional string

Earliest time when the scheduler can claim this operation. Null when disabled.

formatdate-time

interval: optional string

Scheduling interval between normal table maintenance runs.

snapshot_expiration: optional object { max_snapshot_age, min_snapshots_to_keep, state, next_eligible_at }

max_snapshot_age: string

Specifies the maximum age for snapshots.

min_snapshots_to_keep: number

Specifies the minimum number of snapshots to retain. Defaults to 100.

formatint64

minimum1

state: "enabled" or "disabled"

Specifies the state of maintenance operations.

One of the following:

"enabled"

"disabled"

next_eligible_at: optional string

Earliest time when the scheduler can claim this operation. Null when disabled.

formatdate-time

MaintenanceConfigUpdateResponse object { compaction, interval, snapshot_expiration }

Configures maintenance for the table.

compaction: optional object { state, target_size_mb, next_eligible_at }

Configures compaction settings for table optimization.

state: "enabled" or "disabled"

Specifies the state of maintenance operations.

One of the following:

"enabled"

"disabled"

target_size_mb: "64" or "128" or "256" or "512"

Sets the target file size for compaction in megabytes. Defaults to “128”.

One of the following:

"64"

"128"

"256"

"512"

next_eligible_at: optional string

Earliest time when the scheduler can claim this operation. Null when disabled.

formatdate-time

interval: optional string

Scheduling interval between normal table maintenance runs.

snapshot_expiration: optional object { max_snapshot_age, min_snapshots_to_keep, state, next_eligible_at }

max_snapshot_age: string

Specifies the maximum age for snapshots.

min_snapshots_to_keep: number

Specifies the minimum number of snapshots to retain. Defaults to 100.

formatint64

minimum1

state: "enabled" or "disabled"

Specifies the state of maintenance operations.

One of the following:

"enabled"

"disabled"

next_eligible_at: optional string

Earliest time when the scheduler can claim this operation. Null when disabled.

formatdate-time