Data storage benchmark and key features

Name
Link
Deployment
Solution
Target Market
Core Use Case
Support for Standard SQL
Supports semi-structured data
Decoupled storage/compute
Snowflake
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Amazon Redshift
Saas
Modern
Universal
Cloud Data warehousing
Yes
No
Yes
Google BigQuery
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Databricks
Saas
Modern
Enterprise
Cloud Data warehousing
Yes
Yes
Yes
Firebolt
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Clickhouse
Open-source
Modern
Universal
Real-time analytics
Yes
No
No
Apache Pinot
Open-sourceSaas
Modern
Universal
Real-time analytics
Yes
Yes
No
Apache druid
Open-source
Modern
Universal
Real-time analytics
Yes
Yes
No
Materialize
Saas
Modern
Universal
Real-time analytics
Yes
No
No
Azure Synapse Analytics
Saas
Modern
Enterprise
Cloud Data warehousing
No
No
No
Yellowbrick
Saas
Modern
Enterprise
Cloud Data warehousingReal-time analytics
Yes
Yes
Yes
SAP Hana
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Oracle
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
IBM db2
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Vertica
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Startree (Managed Apache Pinot)
Open-sourceSaas
Modern
Universal
Real-time analytics
Yes
Yes
No