> /v1/alternatives/snowflake
Open source alternatives to Snowflake[006]
Snowflake provides a cloud data warehouse that separates storage from compute for SQL analytics over very large datasets. Below are 6 self-hostable open source alternatives, ranked by GitHub popularity.
ClickHouse
ClickHouse is the fastest and most resource efficient open-source database for real-time apps and analytics
★ STARS
47.3k
⑂ FORKS
8.4k
Timescale
A time-series database for high-performance real-time analytics packaged as a Postgres extension
★ STARS
22.6k
⑂ FORKS
1.1k
Cube
Cube Core is open-source semantic layer for AI, BI and embedded analytics
★ STARS
19.9k
⑂ FORKS
2.0k
Activeloop
Database for AI
★ STARS
9.1k
⑂ FORKS
709
CloudQuery
Data pipelines for cloud config and security data. Build cloud asset inventory, CSPM, FinOps, and vulnerability management solutions. Extract from AWS, Azure, GCP, and 70+ cloud and SaaS sources.
★ STARS
6.4k
⑂ FORKS
544
CrateDB
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
★ STARS
4.4k
⑂ FORKS
594
// EDITOR'S TAKE
ClickHouse is the realistic replacement for the warehouse itself, faster than Snowflake on most analytical scans but leaving cluster operations and concurrency limits to you. CrateDB suits high-ingest sensor and log workloads, while Cube and CloudQuery solve the neighbouring problems of semantic modelling and data ingestion rather than storage.
// FREQUENTLY ASKED
What is the best open source Snowflake alternative?
ClickHouse is the most popular open source Snowflake alternative by GitHub stars (47,289 stars). The other 5 options are ranked above.
Are these Snowflake alternatives self-hostable?
Yes — every project listed here is open source and runs on your own infrastructure. Click into a project to see its license, stars, language, and current health status.
Are they free?
All projects shown are free and open source. Check each project's license page for the terms — most are MIT, Apache 2.0, or AGPL.