R2 SQL

R2 SQL

Cloudflare
+
+

Related Products

  • AnalyticsCreator
    46 Ratings
    Visit Website
  • Denodo
    387 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website
  • LM-Kit.NET
    29 Ratings
    Visit Website
  • DataBuck
    6 Ratings
    Visit Website
  • Code-Cube.io
    7 Ratings
    Visit Website
  • QuantaStor
    6 Ratings
    Visit Website
  • IONOS Cloud Object Storage
    45,199 Ratings
    Visit Website
  • SuperOps
    223 Ratings
    Visit Website

About

Dremio delivers lightning-fast queries and a self-service semantic layer directly on your data lake storage. No moving data to proprietary data warehouses, no cubes, no aggregation tables or extracts. Just flexibility and control for data architects, and self-service for data consumers. Dremio technologies like Data Reflections, Columnar Cloud Cache (C3) and Predictive Pipelining work alongside Apache Arrow to make queries on your data lake storage very, very fast. An abstraction layer enables IT to apply security and business meaning, while enabling analysts and data scientists to explore data and derive new virtual datasets. Dremio’s semantic layer is an integrated, searchable catalog that indexes all of your metadata, so business users can easily make sense of your data. Virtual datasets and spaces make up the semantic layer, and are all indexed and searchable.

About

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.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Data engineers

Audience

Data engineers and backend developers needing a solution to run scalable analytics over large datasets stored in R2 using SQL

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Pricing

Free
Free Version Supported
Free Trial Not Supported

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation Not Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Supported

Company Information

Dremio
Founded: 2015
United States
www.dremio.com

Company Information

Cloudflare
Founded: 2009
United States
developers.cloudflare.com/r2-sql/

Alternatives

Denodo

Denodo

Denodo Technologies

Alternatives

Cloudflare R2

Cloudflare R2

Cloudflare
Apache Iceberg

Apache Iceberg

Apache Software Foundation
Apache Drill

Apache Drill

The Apache Software Foundation

Categories

Big Data Supported
Data Engineering Supported
Data Lake Supported
Data Lineage Supported
Data Warehouse Supported
Query Engines Supported
Semantic Layer Supported

Categories

Query Engines Supported

Integrations

Apache Iceberg Supported
SQL Supported
Apache Superset Supported
BI Book Supported
Cloudflare Not Supported
Codd AI Supported
Cyral Supported
DashboardFox Supported
DataClarity Unlimited Analytics Supported
Emgage Supported
HPE Ezmeral Supported
Hex Supported
Looker Supported
Okera Supported
Privacera Supported
PuppyGraph Supported
Tableau Supported
Yurbi Supported
data.world Supported
witboost Supported

Integrations

Apache Iceberg Supported
SQL Supported
Apache Superset Not Supported
BI Book Not Supported
Cloudflare Supported
Codd AI Not Supported
Cyral Not Supported
DashboardFox Not Supported
DataClarity Unlimited Analytics Not Supported
Emgage Not Supported
HPE Ezmeral Not Supported
Hex Not Supported
Looker Not Supported
Okera Not Supported
Privacera Not Supported
PuppyGraph Not Supported
Tableau Not Supported
Yurbi Not Supported
data.world Not Supported
witboost Not Supported
Claim Dremio and update features and information
Claim Dremio and update features and information
Claim R2 SQL and update features and information
Claim R2 SQL and update features and information