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.
SQL-first transformation workflow for analytics engineering
Processing
dbt is a transformation framework that compiles modular, version-controlled SQL models and runs them inside the warehouse, with testing, documentation, and lineage built in.
Distributed SQL query engine for federated analytics
Processing
Trino is an open-source distributed SQL engine that queries data where it lives — object storage, lakehouse table formats, and operational databases — through a single interface.
In-process analytical database for local and embedded analytics
Processing
DuckDB is an open-source, in-process OLAP database — an embeddable columnar SQL engine that queries Parquet, CSV, and dataframes with no server to run.
Apache Flink is an open-source framework for stateful computation over unbounded and bounded data streams, with event-time processing and exactly-once state consistency.