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 |