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-emulator

Would love feedback – especially on SQL functions you'd want supported!