Ask questions about billing, storage, and usage monitoring

[sherly]

Snowflake usage cost is high this month. Any suggestions to optimize it?

[Wills]

Enable auto-suspend for warehouses and use the smallest size unless needed.

[allison]

Try materialized views for frequent queries. Also, monitor QUERY_HISTORY to find heavy queries.

[Meera]

I’ve also seen cost reductions by monitoring storage growth regularly and archiving old data that’s no longer queried frequently.
We now run a monthly review of unused tables and large result caches.
Also, switching to transient tables where possible helped lower long-term storage costs.

Let me know if anyone wants to collaborate on setting up resource monitors and alerts — we did it via Snowflake’s UI and some simple SQL scripts.

[Author]

Posts