Snowflake interactive warehouses: cheaper, always-warm, and yes, the SQL API works
Snowflake’s interactive warehouses sit in a sweet spot for user-facing workloads: they cost 60% of a same-sized standard warehouse, can stay warm across business hours, and still serve sub‑second lookups from an interactive table