R2 SQL - Pricing · R2 SQL docs

Documentation Index<br>Fetch the complete documentation index at: https://developers.cloudflare.com/r2-sql/llms.txt<br>Use this file to discover all available pages before exploring further.

Skip to content

Pricing

R2 SQL charges based on a single dimension:

Data scanned : The volume of compressed data read from R2 to execute your query.

R2 SQL pricing is additive to standard R2 storage and operations and R2 Data Catalog charges. When the query engine reads files, those requests count as R2 Class B (read) operations. R2 does not charge for egress, so there is no additional data transfer cost.

All included usage is on a monthly basis.

R2 SQL pricing

Free planPaid planIncluded1 GB / month10 GB / monthData scannedN/A$0.0025 / GB ($2.50 / TB)<br>What counts as data scanned

Data scanned is the compressed bytes read from R2 object storage to answer your query. This matches what you see in your R2 bucket — if a Parquet file is 100 MB on disk, scanning that file bills for 100 MB.

Minimum per query : 10 MB. If a query scans less than 10 MB, you are billed for 10 MB.

Failed queries : Queries that fail due to a system error or syntax error caught before execution are not charged. Queries that fail mid-execution due to a runtime error are also not charged.

Metadata-only operations : Operations such as EXPLAIN, SHOW, and DESCRIBE do not scan data and are free. Standard R2 and R2 Data Catalog request charges still apply.

Billing examples

Example 1: Ad-hoc analytics on 500 GB of Parquet data

A user stores 500 GB of Parquet data in R2 Data Catalog and runs queries that scan a total of 50 GB of compressed data during the month.

DimensionUsageIncludedBillableCostR2 storage500 GB-month10 GB-month490 GB-month$7.35R2 SQL (data scanned)50 GB10 GB40 GB$0.10Total $7.45<br>Example 2: Heavy query workload on 10 TB dataset

A data team stores 10 TB of compressed Parquet/Iceberg data and scans 50 TB of data per month across their queries. The team also makes 2 million catalog operations with compaction processing 500 GB.

DimensionUsageIncludedBillableCostR2 storage10,000 GB-month10 GB-month9,990 GB-month$149.85R2 SQL (data scanned)50,000 GB10 GB49,990 GB$124.98R2 Data Catalog operations2,000,0001,000,0001,000,000$9.00R2 Data Catalog compaction (data)500 GB10 GB490 GB$2.45Total $286.28<br>Frequently asked questions

Is there a minimum billing increment per query?

Yes. Each query is billed for a minimum of 10 MB of data scanned. This covers the overhead of initializing the query engine.

Does data scanned include R2 egress fees?

No. R2 does not charge for egress. The query engine runs within the Cloudflare network adjacent to R2 storage, so there are no data transfer costs.

Cloudflare billing policy

To learn more about how usage is billed, refer to Cloudflare Billing Policy.