SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python Snowflake Projects
-
airbyte
Open-source data movement for ELT pipelines and AI agents — from APIs, databases & files to warehouses, lakes, and AI applications. Both self-hosted and Cloud.
Project mention: Show HN: Airbyte Agents – context for agents across multiple data sources | news.ycombinator.com | 2026-05-05 -
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
Project mention: I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code | news.ycombinator.com | 2026-06-24
-
-
Project mention: Show HN: Data contracts engine for the modern data stack | news.ycombinator.com | 2026-01-28
-
-
-
-
For more information about Xorq, head over to their GitHub or their official documentation.
-
-
Project mention: Zero-boilerplate bridge between ML models and AI agents | news.ycombinator.com | 2026-06-10
-
-
-
snowflake-cli
Snowflake CLI is an open-source command-line tool explicitly designed for developer-centric workloads in addition to SQL operations.
-
Pontoon
Open source data export platform. For devs who ship data to their customers 🚀 (by pontoon-data)
Project mention: Show HN: Pontoon – open-source customer data syncs | news.ycombinator.com | 2025-08-01> Open source: Pontoon is free to use by anyone
And yet, the top level license file contains two licenses, a goddamn if statement, and finally a default to Elastic License which is not open source
Then, because if this trickery, lawyers get to make good money because does "2. LICENSE file in the same directory as the work" combined with "4. Defaults to Elastic License 2.0 (ELv2)" mean that this zero byte file NAMED LICENSE but devoid of any content match clause 2 or 4?
https://github.com/pontoon-data/Pontoon/blob/v0.2.0/data-tra...
I hate cutesy licenses with all my heart. Just say you want to use Elastic, drop the Open Source pretense and go back to selling software instead of trying to position yourself as "open"
No educated person is going to give you free commits in the current state so no need to be opaque in hopes of tricking them
-
CueObserve
Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases
-
Streamlit: 30 Days of AI
-
dbt-ml-preprocessing
A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.
-
-
data-observability-installer
Installer for DataKitchen's Open Source Data Observability Products. Data breaks. Servers break. Your toolchain breaks. Ensure your team is the first to know and the first to solve with visibility across and down your data estate. Save time with simple, fast data quality test generation and execution. Trust your data, tools, and systems end to end.
-
-
sidemantic
The universal metrics layer. Compatible with 15+ formats: Cube, MetricFlow, LookML, Omni, BSL, LDM, Cortex, Malloy, OSI, SML, TML, Hex, Rill, Superset
-
prism
Prism is the easiest way to develop, orchestrate, and execute data pipelines in Python. (by runprism)
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Python Snowflake discussion
Python Snowflake related posts
-
Pg_ClickHouse: A Postgres extension for querying ClickHouse
-
All Data and AI Weekly #192 - June 2, 2025
-
I built a data pipeline tool in Go
-
Show HN: I built an open-source data pipeline tool in Go
-
Show HN: Snowflake warehouse implementation using DuckDB and Apache Iceberg
-
Query Snowflake tables locally without any need for a running warehouse
-
Show HN: SQLFrame – I ran PySpark without Spark on a SQL database
-
A note from our sponsor - SaaSHub
www.saashub.com | 21 Jul 2026
Index
What are some of the best open-source Snowflake projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | airbyte | 21,628 |
| 2 | sqlglot | 9,429 |
| 3 | ibis | 6,600 |
| 4 | soda-core | 2,391 |
| 5 | jupysql | 849 |
| 6 | datacompy | 654 |
| 7 | snowChat | 553 |
| 8 | xorq | 535 |
| 9 | versatile-data-kit | 486 |
| 10 | predikit | 448 |
| 11 | snowpark-python | 339 |
| 12 | grai-core | 315 |
| 13 | dbt-coves | 276 |
| 14 | snowflake-cli | 263 |
| 15 | Pontoon | 244 |
| 16 | CueObserve | 235 |
| 17 | 30DaysOfAI | 217 |
| 18 | dbt-ml-preprocessing | 186 |
| 19 | SnowDDL | 151 |
| 20 | data-observability-installer | 139 |
| 21 | diepvries | 129 |
| 22 | sidemantic | 105 |
| 23 | prism | 88 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com