Snowflake alternatives

5 open source tools you can use instead of Snowflake

The most-starred open source alternative to Snowflake is ClickHouse. Other notable options: DuckDB, Apache Doris, Trino, StarRocks. All of them are free to download and most can run on your own server.

ClickHouse50.8k

ClickHouse/ClickHouse

Fast column-oriented database management system for real-time analytics on very large datasets.

Alternative to: Snowflake

LicenseOpen sourceApache-2.0

CategoryData & DatabasesSelf-hosted

LanguageC++

Last updatetoday

PlatformsDockerCommand line

DuckDB42.8k

duckdb/duckdb

High performance analytical database that runs embedded or from the CLI.

Alternative to: Snowflake

LicenseOpen sourceMIT

CategoryData & Databases

LanguageC++

Last updatetoday

PlatformsCommand line

Apache Doris16.2k

apache/doris

Real-time analytical database with fast SQL queries and hybrid search, designed for large datasets.

Alternative to: Snowflake

LicenseOpen sourceApache-2.0

CategoryData & DatabasesSelf-hosted

LanguageJava

Last updatetoday

PlatformsLinuxDocker

Trino13.5k

trinodb/trino

Distributed SQL query engine that runs fast interactive queries across many data sources for big data analytics.

Alternative to: Snowflake

LicenseOpen sourceApache-2.0

CategoryData & DatabasesSelf-hosted

LanguageJava

Last updatetoday

PlatformsDocker

StarRocks12.2k

StarRocks/starrocks

Open-source query engine for sub-second analytics on and off the data lake

Alternative to: Snowflake

LicenseOpen sourceApache-2.0

CategoryData & DatabasesSelf-hosted

LanguageJava

Last updatetoday

PlatformsDocker