Data Warehouses
8 providers in this category.
Data warehouses store and query large analytical datasets, optimized for aggregations across billions of rows rather than transactional workloads. Modern ones separate storage from compute and can scale compute to zero between queries. Look at free tier, serverless billing, storage/compute separation, open-source options, and multi-cloud portability.
Companies
Neutral ordering. Not a recommendation.
Amazon Redshift
aws.amazon.com/redshift
Amazon Redshift is AWS's managed data warehouse for running analytics across large datasets, tightly integrated with the AWS ecosystem.
Azure Synapse Analytics
azure.microsoft.com/en-us/products/synapse-analytics
Azure Synapse Analytics is Microsoft's analytics service combining data warehousing and big-data processing, targeting teams running analytics on Azure.
ClickHouse Cloud
clickhouse.com/cloud
ClickHouse Cloud is the managed service for ClickHouse, a column-oriented database engine built for fast, real-time analytical (OLAP) queries.
Databricks
www.databricks.com
Databricks is a data and AI platform built on the lakehouse architecture, unifying data engineering, analytics, and machine learning in one environment.
Firebolt
www.firebolt.io
Firebolt is a cloud data warehouse focused on low-latency, high-concurrency analytics, aimed at teams powering analytics-heavy applications and data products.
Google BigQuery
cloud.google.com/bigquery
Google BigQuery is Google Cloud's fully serverless data warehouse for fast SQL analytics over very large datasets, with storage and compute separated.
MotherDuck
motherduck.com
MotherDuck is a serverless cloud data warehouse built on DuckDB, pairing cloud storage and compute with DuckDB's fast local execution in a hybrid query model.
