Snowflake Cost Optimization
OhChimp reads your Snowflake credit usage to cut idle warehouse spend: tighten auto-suspend, reset multi-cluster minimums, verify the drop on your bill.
How does OhChimp connect to Snowflake?
Through the Snowflake SQL API using key-pair JWT authentication. You assign OhChimp's public key to a Snowflake user and grant a read-only role. OhChimp signs a JWT with the matching private key and runs read-only statements against ACCOUNT_USAGE and SHOW WAREHOUSES. It reads usage metadata and warehouse settings only.
Does OhChimp need write access or see my data?
No. OhChimp runs as the read-only role you grant and only reads credit metering, warehouse settings, and the compute versus cloud-services split. It never queries your tables, and it never stores your application data, secrets, or query contents. The plans it writes are ALTER WAREHOUSE statements you review and apply yourself.
What Snowflake costs can OhChimp actually reduce?
Idle warehouse credits, mostly. OhChimp finds warehouses that never auto-suspend or suspend too slowly, multi-cluster warehouses with a minimum cluster count above one, and ranks every warehouse by credits consumed so you see the biggest spenders. It also splits your usage into compute and cloud-services credits.
Who applies the changes, and can they be rolled back?
You do. Each fix is a reviewable plan, an ALTER WAREHOUSE statement, with a confidence score, a risk level, and rollback steps. Nothing changes in your account until you click apply, and you are always the one who clicks.
How are Snowflake savings verified, and what does it cost?
Against your real Snowflake bill. A plan is marked VERIFIED only after 7 or more days, a drop of at least 10%, and 3 consecutive positive checks. Until then it stays flagged not implemented. Pricing is a flat monthly fee with no cut of your savings, plus a year-one ROI guarantee: a full refund of subscription fees if it does not pay for itself in your first 12 months on a paid plan.