| 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 |