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
www.snowflake.com
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Amazon Redshift
aws.amazon.com
Saas
Modern
Universal
Cloud Data warehousing
Yes
No
Yes
Google BigQuery
cloud.google.com
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Databricks
databricks.com
Saas
Modern
Enterprise
Cloud Data warehousing
Yes
Yes
Yes
Firebolt
www.firebolt.io
Saas
Modern
Universal
Cloud Data warehousing
Yes
Yes
Yes
Clickhouse
clickhouse.com
Open-source
Modern
Universal
Real-time analytics
Yes
No
No
Apache Pinot
pinot.apache.org
Open-sourceSaas
Modern
Universal
Real-time analytics
Yes
Yes
No
Apache druid
druid.apache.org
Open-source
Modern
Universal
Real-time analytics
Yes
Yes
No
Materialize
materialize.com
Saas
Modern
Universal
Real-time analytics
Yes
No
No
Azure Synapse Analytics
azure.microsoft.com
Saas
Modern
Enterprise
Cloud Data warehousing
No
No
No
Yellowbrick
www.yellowbrick.com
Saas
Modern
Enterprise
Cloud Data warehousingReal-time analytics
Yes
Yes
Yes
SAP Hana
en.wikipedia.org
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Oracle
www.oracle.com
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
IBM db2
www.ibm.com
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Vertica
vertica.com
Saas
Legacy
Enterprise
Cloud Data warehousing
Yes
Yes
No
Startree (Managed Apache Pinot)
www.startree.ai
Open-sourceSaas
Modern
Universal
Real-time analytics
Yes
Yes
No