Audience
Data engineers and backend developers needing a solution to run scalable analytics over large datasets stored in R2 using SQL
About R2 SQL
R2 SQL is Cloudflare’s serverless, distributed analytics query engine (currently in open beta) that enables you to run SQL queries over Apache Iceberg tables stored in R2 Data Catalog without needing to manage your own compute clusters. It is built to efficiently query large volumes of data by leveraging metadata pruning, partition-level statistics, file and row-group filtering, and Cloudflare’s globally distributed compute infrastructure to parallelize execution. The system works by integrating with R2 object storage and an Iceberg catalog layer, so you can ingest data via Cloudflare Pipelines into Iceberg tables, and then query that data with minimal overhead. Queries can be issued via the Wrangler CLI or HTTP API (with an API token granting permissions across R2 SQL, Data Catalog, and storage). During the open beta period, using R2 SQL itself is not billed, only storage and standard R2 operations incur charges.
Other Popular Alternatives & Related Software
Dafthunk
Dafthunk is a visual workflow automation platform that lets users build, manage, and deploy serverless automation workflows using a drag-and-drop editor without needing to set up infrastructure or use containers. Workflows are constructed by visually connecting nodes that perform tasks across AI, browser automation, data processing, media generation, integrations, and developer tools, and then executed on Cloudflare’s global edge network with built-in scaling and durable execution. It supports workflow triggers including HTTP webhooks, queues, cron schedules, and manual starts, enabling event-driven, time-based, and custom-initiated automation. It includes persistent workflow state storage and execution history using Cloudflare D1 and R2 storage services. Users can incorporate AI models from providers like OpenAI, Anthropic, Google, and Cloudflare AI for text generation, summarization, vision, NLP, transcription, image creation, and more.
Learn more
Logflare
Never get surprised by a logging bill again, collect for years, query in seconds. Costs escalates quickly with typical log management solutions. To setup long term analytics on events you need to archive to a CSV and setup another data pipeline to ingest events into a custom tailored data warehouse. With Logflare and BigQuery there is no setup for long term analytics. You can ingest immediately, query in seconds and store data for years. Use our Cloudflare app and catch every request to your web service no matter what. Our Cloudflare App worker doesn't modify your request, it simply pulls the request/response data and logs to Logflare asynchronously after passing your request through. Want to monitor your Elixir app? Our library adds minimal overhead. We batch logs and use BERT binary serialization to keep payload size and serialization load low. When you sign in with your Google account, we give you access to your underlying BigQuery table.
Learn more
Cloudflare R2
Cloudflare R2 is a global object storage service that allows developers to store large amounts of unstructured data without the costly egress bandwidth fees associated with typical cloud storage services. It supports multiple scenarios, including storage for cloud-native applications, web content, podcast episodes, data lakes, and outputs for large batch processes such as machine learning model artifacts or datasets. R2 offers features like location hints to optimize data access, CORS configuration for interacting with objects, public buckets to expose contents directly to the Internet, and bucket-scoped tokens for granular access control. It integrates with Cloudflare Workers, enabling developers to perform authentication, route requests, and deploy edge functions across a network of over 330 data centers. Additionally, R2 supports Apache Iceberg through its data catalog, transforming object storage into a fully functional data warehouse without management overhead.
Learn more
Tabular
Tabular is an open table store from the creators of Apache Iceberg. Connect multiple computing engines and frameworks. Decrease query time and storage costs by up to 50%. Centralize enforcement of data access (RBAC) policies. Connect any query engine or framework, including Athena, BigQuery, Redshift, Snowflake, Databricks, Trino, Spark, and Python. Smart compaction, clustering, and other automated data services reduce storage costs and query times by up to 50%. Unify data access at the database or table. RBAC controls are simple to manage, consistently enforced, and easy to audit. Centralize your security down to the table. Tabular is easy to use plus it features high-powered ingestion, performance, and RBAC under the hood. Tabular gives you the flexibility to work with multiple “best of breed” compute engines based on their strengths. Assign privileges at the data warehouse database, table, or column level.
Learn more
Pricing
Starting Price:
Free
Free Version:
Free Version available.
Company Information
Cloudflare
Founded: 2009
United States
developers.cloudflare.com/r2-sql/
Videos and Screen Captures
Other Useful Business Software
Our Free Plans just got better! | Auth0
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Product Details
Platforms Supported
Cloud
Training
Documentation
In Person
Videos
Support
Phone Support
Online
