tables

Creates, updates, deletes, gets or lists a tables resource.

Overview

Name	tables
Type	Resource
Id	cloudflare.r2_data_catalog.tables

Fields

The following fields are returned by SELECT queries:

list

List of tables retrieved successfully.

Name	Datatype	Description
details	array	Contains detailed metadata for each table when return_details is true. Each object includes identifier, UUID, timestamps, and locations.
identifiers	array	Lists tables in the namespace.
next_page_token	string	Use this opaque token to fetch the next page of results. A null or absent value indicates the last page. (example: MSYxNzU5NzU2MTI4NTU2Njk2JjAxOTliOWEzLTkxMmUtN2ZhMS05YzllLTg5MTAxMGQzYTg0MQ)
table_uuids	array	Contains UUIDs for each table when return_uuids is true. The order corresponds to the identifiers array.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	account_id, bucket_name, namespace	page_token, page_size, return_uuids, return_details	Returns a list of tables in the specified namespace within an R2 catalog. Supports pagination for efficient traversal of large table collections.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
account_id	string	The Cloudflare account ID.
bucket_name	string	The R2 bucket name.
namespace	string	The namespace identifier. For nested namespaces, use %1F as separator (e.g., "bronze%1Fanalytics").
page_size	integer	Maximum number of tables to return per page. Defaults to 100, maximum 1000.
page_token	string	Opaque pagination token from a previous response. Use this to fetch the next page of results.
return_details	boolean	Whether to include additional metadata (timestamps, locations). When true, response includes created_at, updated_at, metadata_locations, and locations arrays.
return_uuids	boolean	Whether to include table UUIDs in the response. Set to true to receive the table_uuids array.

SELECT examples

list

Returns a list of tables in the specified namespace within an R2 catalog. Supports pagination for efficient traversal of large table collections.

SELECT
details,
identifiers,
next_page_token,
table_uuids
FROM cloudflare.r2_data_catalog.tables
WHERE account_id = '{{ account_id }}' -- required
AND bucket_name = '{{ bucket_name }}' -- required
AND namespace = '{{ namespace }}' -- required
AND page_token = '{{ page_token }}'
AND page_size = '{{ page_size }}'
AND return_uuids = '{{ return_uuids }}'
AND return_details = '{{ return_details }}'
;