opensourcestartups

> /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.

// 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.