Managed cloud data warehouse with separated storage and compute
Data Warehouses
Snowflake is a commercial cloud data platform offering elastic SQL warehouses, cross-account data sharing, and multi-cloud availability as a fully managed service.
BigQuery is Google Cloud's serverless, fully managed data warehouse with on-demand or capacity-based pricing, streaming ingestion, and built-in ML functions.
Column-oriented OLAP database for real-time analytics
OLAP Engines
ClickHouse is an open-source columnar database designed for low-latency analytical queries over large volumes, available self-hosted or as ClickHouse Cloud.
Open storage framework with ACID transactions for data lakes
Table Formats
Delta Lake is an open-source table format providing ACID transactions, schema enforcement, and time travel over Parquet files, closely integrated with Spark and Databricks.
Durable object storage that anchors cloud data lakes
Object Storage
Amazon S3 is AWS's managed object storage service — the de facto substrate for data lakes and lakehouses, with tiered storage classes and fine-grained access control.
MinIO is an open-source, S3 API-compatible object store for self-hosted, on-prem, and edge deployments, built for high-performance analytical workloads.
