What is R2 SQL?

R2 SQL is an innovative serverless analytics query engine created by Cloudflare, currently available in open beta, which enables users to run SQL queries on Apache Iceberg tables housed within the R2 Data Catalog without worrying about the complexities of managing compute clusters. This engine is engineered to efficiently process large datasets by employing advanced techniques like metadata pruning, partition-level statistics, and filtering at the file and row-group levels, leveraging Cloudflare's globally distributed computing resources to boost parallel execution. The system seamlessly integrates with R2 object storage and features an Iceberg catalog layer, facilitating data ingestion via Cloudflare Pipelines into Iceberg tables that users can query with minimal overhead. Users have the flexibility to submit queries through the Wrangler CLI or an HTTP API, with access managed by an API token that governs permissions across R2 SQL, the Data Catalog, and storage. Importantly, throughout the open beta phase, users incur no fees for utilizing R2 SQL; they only pay for storage and standard operations within R2. This streamlined process significantly enhances the accessibility and efficiency of data analytics for users, making it a compelling option for those seeking powerful analytical capabilities. Furthermore, the combination of ease of use and cost-effectiveness positions R2 SQL as a valuable tool for businesses looking to extract insights from their data without excessive investment in infrastructure.

Pricing

Price Starts At:
Free
Free Version:
Free Version available.

Integrations

Offers API?:
Yes, R2 SQL provides an API

Screenshots and Video

R2 SQL Screenshot 1

Company Facts

Company Name:
Cloudflare
Date Founded:
2009
Company Location:
United States
Company Website:
developers.cloudflare.com/r2-sql/

Product Details

Deployment
SaaS
Training Options
Documentation Hub
On-Site Training
Video Library
Support
Standard Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

R2 SQL Categories and Features