d1_analytics_adaptive_groups

Analytics resource

This is a time-bounded analytics resource. Queries against it differ from typical CRUD resources in a few ways:

• since and until are required. Both are RFC3339 timestamps and define the analytics window (e.g. since = '2026-05-28T00:00:00Z', until = '2026-05-29T00:00:00Z'). Queries without them will fail.
• Row cap via limit. The limit parameter (default 100) bounds the response. Widen the time window or raise limit to return more rows.
• Token scope. Cloudflare's analytics endpoints require an API token with Account -> Analytics -> Read permission, which is broader than typical zone-scoped tokens. A token without it will return empty results.

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

Overview

Name	d1_analytics_adaptive_groups
Type	Resource
Id	cloudflare.d1.d1_analytics_adaptive_groups

Fields

The following fields are returned by SELECT queries:

list

Response

Name	Datatype	Description
database_id	string	D1 database UUID.
database_role	string	Primary / replica role of the instance serving the request.
datetime	string (date-time)
query_batch_response_bytes	integer	Total response bytes across batches.
read_queries	integer	Read query count.
requests	integer	Total D1 request count for the tuple.
rows_read	integer	Rows read by queries.
rows_written	integer	Rows written by queries.
served_by_region	string	Region of the D1 instance that served the request.
write_queries	integer	Write query count.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	account_tag, since, until	limit	Cloudflare D1 database analytics for an account, grouped by database, serving instance, and region. Per-tuple totals for request count, read/write query counts, rows read/written, and response bytes.

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_tag	string	Cloudflare account ID (the 32-char hex tag).
since	string (date-time)	Lower bound (inclusive). RFC3339.
until	string (date-time)	Upper bound (exclusive). RFC3339.
limit	integer	Maximum dimension-tuple rows per call.

SELECT examples

list

Cloudflare D1 database analytics for an account, grouped by database, serving instance, and region. Per-tuple totals for request count, read/write query counts, rows read/written, and response bytes.

SELECT
database_id,
database_role,
datetime,
query_batch_response_bytes,
read_queries,
requests,
rows_read,
rows_written,
served_by_region,
write_queries
FROM cloudflare.d1.d1_analytics_adaptive_groups
WHERE account_tag = '{{ account_tag }}' -- required
AND since = '{{ since }}' -- required
AND until = '{{ until }}' -- required
AND limit = '{{ limit }}'
;