Open source alternatives to Snowflake

2 projects on starwire do the same job. Ranked by how much of what Snowflake does each one covers, read from its README and website. Ties go to the most active.

What Snowflake does

Cloud data warehousecore
SQL analytics at scalecore
Separate storage and compute
Data sharing
Python and ML workloads
Semi-structured data
Data ingestion

Each dot in the table is one job, in this order. Square dots are core jobs and count double. Full means yes, half means partly. "See the evidence" under a project shows the line behind each one. Coverage is what a project documents, not how well it works or how hard it is to move to. How we score this

Project	Covers	Stars	Commits, 12 weeks	Last release	Closed vs opened	Setup	License
databendCloud data warehouse in Rust for analytics, search and Python workloads on S3	Replaces it83%	9.5k+2	430	7 months ago	100%	Hosted version	Apache-2.0
Covers all 2 core jobs. Partly: Semi-structured data. Not shown: Data sharing.See the evidence Cloud data warehousecoreYesopen-source data warehouse built in Rust SQL analytics at scalecoreYesLarge-scale SQL analytics Separate storage and computeYeselastic compute on object storage Data sharingNot shownNeither the README nor the website mentions it. Python and ML workloadsYessandboxed Python UDFs for agents Semi-structured dataPartlyJSON & search Data ingestionYesData ingestion vs. Snowflake
ClickHouseColumn-oriented database for real-time analytical queries	Covers one part56%	51k+112	41,354	today	68%	Hosted version	Apache-2.0
Covers all 2 core jobs. Not shown: Separate storage and compute; Data sharing; Python and ML workloads; Semi-structured data.See the evidence Cloud data warehousecoreYesfastest and most resource efficient real-time data warehouse SQL analytics at scalecoreYesgenerating analytical data reports in real-time Separate storage and computeNot shownNeither the README nor the website mentions it. Data sharingNot shownNeither the README nor the website mentions it. Python and ML workloadsNot shownNeither the README nor the website mentions it. Semi-structured dataNot shownNeither the README nor the website mentions it. Data ingestionYesintegrations for data ingestion, visualization, language clients

Vital signs from GitHub, checked weekly. How we read these · How setup is read

These also replace

BigQuery1

All repos

Sort

Form Platform Works with Theme License Setup Language

New repos every two days, stars refreshed daily. Visits are counted without cookies, and the numbers are public. How it works Data RSS Newsletter