Snowflake Emulator
Local Snowflake Development with Go and DuckDB
Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.
Want to reach these readers? Sponsor an issue.
Hi HN! I built a Snowflake emulator for local development and testing.Testing Snowflake code locally is frustrating – you need a real account (expensive) or mock everything (tedious). I wanted something that just works with the standard [gosnowflake](https://github.com/snowflakedb/gosnowflake) driver or REST API.snowflake-emulator fixes this by:- Using DuckDB as the storage engine - Auto-translating Snowflake SQL (IFF→IF, NVL→COALESCE, DATEADD, etc.) - Supporting gosnowflake driver protocol – no code changes needed - Providing REST API v2 – use from any language (Python, Node.js, etc.)```go dsn := "user:pass@localhost:8080/TEST_DB/PUBLIC?account=test&protocol=http" db, _ := sql.Open("snowflake", dsn) db.Query(`SELECT IFF(score >= 90, 'A', 'B') FROM users`) ``````bash docker run -p 8080:8080 ghcr.io/nnnkkk7/snowflake-emulator:latest ```GitHub: https://github.com/nnnkkk7/snowflake-emulatorWould love feedback – especially on SQL functions you'd want supported!
HN · launched Jan 3, 2026 · 6 upvotes (top 75%) · 0 views
Niche: software and system emulators · 114 launches, 2 in the last 7 days ▼ -80% · Explore this niche →
Category and tags
- Horizontal
- Data infrastructure
- Developer
- Not AI
- Hobby / open-source project
Visit website ↗ Source listing ↗
More like this: all 114 launches in software and system emulators →
Could you build this?
Partial While wrapping DuckDB behind a Go server wire protocol is straightforward, emulating Snowflake-specific SQL dialect quirks and proprietary features accurately requires significant low-level engine translation.
What it would actually take: The architecture involves a Go HTTP/JSON server that implements the Snowflake wire protocol and translates queries into DuckDB SQL via AST rewriting. The hardest piece is handling Snowflake-specific SQL functions, session parameters, and procedural logic (e.g., Snowflake Scripting) that DuckDB does not natively support, demanding deep database internal knowledge.
Discussion
4 comments analyzed.
Competitors mentioned: LocalStack
Concerns raised: FLATTEN translation to DuckDB UNNEST incomplete, missing Snowflake output columns, Queries work locally but break in subtle ways on deployment, Named parameter syntax not supported
Feature requests: Complete FLATTEN implementation with full Snowflake output columns (SEQ, KEY, PATH, INDEX, VALUE, THIS), Support named parameter syntax for FLATTEN
Competitors
Other products that read as similar to this one : 114 launches clear the similarity bar, closest 8 shown.
Attention rank: #98 of 115 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 66 days after the earliest competitor.
- Connect DuckDB to any database that has an ADBC driver · hn · 2026-07-08 · 7 upvotes · similarity 0.55
- Ducktape · hn · 2025-12-16 · 12 upvotes · similarity 0.50
- duckdb-rust-workers · github · 2026-09-29 · 17 upvotes · similarity 0.45
- Ducklang: Achieving 100x more requests per second than NextJS · hn · 2026-01-01 · 9 upvotes · similarity 0.43
- TablePro · ph · 2026-09-13 · 17 upvotes · similarity 0.43
- GEDB · hn · 2026-02-16 · 9 upvotes · similarity 0.42
- Dbxlite · hn · 2025-12-12 · 5 upvotes · similarity 0.42
- Jevflake · github · 2026-09-20 · 10 upvotes · similarity 0.42
The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.