Managed cloud data warehouse with separated storage and compute
Storage
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
Storage
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
Storage
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.