Query routing
Lake or Snowflake?
For each statement, melt decides whether DuckDB on your S3 lake can answer it. Eligible reads go local for cents. Writes and Snowflake-only features pass through. Dual execution stitches plans that touch both.
Melt is a proxy that sits in front of Snowflake and routes each query to the cheapest engine, right-sized compute, in real time. No code changes, no warehouse downtime.
5-minute setup · Drop-in for any Snowflake driver · Self-hosted
Trusted by data teams, agents, and analytics studios
Melt makes two decisions per query — independently, transparently, with no driver changes. Together they form the unified Snowflake cost layer.
Lake or Snowflake?
For each statement, melt decides whether DuckDB on your S3 lake can answer it. Eligible reads go local for cents. Writes and Snowflake-only features pass through. Dual execution stitches plans that touch both.
Which Snowflake warehouse?
For the queries that stay on Snowflake, melt picks the warehouse that actually fits — XSMALL for a tiny filter, LARGE for the nightly aggregate. Per-statement, transparent to your driver.
Tables flow through Pending → Lake / Snowflake / Dual as melt routes them, with latency and cost attached to each. Same view your engineers see at 3am, in the metrics tab, on a 32-inch operations dashboard.
May statement
Saved
−82%
See exactly which workloads route off Snowflake, which engine they ran on, what they would have cost, and what they cost now. Whether you bill by warehouse, by team, or by agent — melt keeps the books straight.
Scan budget
2 GB
Parity sampler
1 / 100
Allowlist
analytics.*
Sensitive
pii.users
Tune scan budgets, mark sensitive tables Snowflake-only, sample for parity, allowlist by schema. Make melt feel like an extension of your data platform.
JDBC, ODBC, the Python connector, dbt, Looker, Sigma, Hex — all connect unmodified. Push routing decisions into Datadog, Slack, or your own warehouse.
Every routing decision streams to /metrics, with structured logs and tracing. See, in real time, where each query landed and why.
We translate Snowflake SQL to DuckDB on the fly — IFF, QUALIFY, FLATTEN, time-zone arithmetic — and refuse routes that can't round-trip.
Toggle between dashboards, route tables, kanban-style sync state, or timeline views — pick the lens that fits your team's shift.
Supported integrations and drivers
Download Melt for free and route your first query in under five minutes. No credit card required.
Try Melt free