Tracking credit spend and account activity so costs don't surprise anyone

Snowflake provides built-in tools to monitor usage and control costs, primarily through Resource Monitors, the Account Usage and Organization Usage schemas, and various system views/functions that expose credit and storage consumption. Account Admins can set spending limits, receive alerts, and analyze historical usage to optimize warehouse sizing and query efficiency.

1 · Learn the must-know

• 1Resource Monitors track warehouse credit usage and can trigger actions (NOTIFY, SUSPEND, or SUSPEND_IMMEDIATE) when defined thresholds are reached, but they only monitor virtual warehouse credits, not storage or cloud services costs.
• 2Resource Monitors can be set at the account level or assigned to specific warehouses, and only users with the ACCOUNTADMIN role can create or modify them.
• 3The ACCOUNT_USAGE schema (in the SNOWFLAKE database) provides views like WAREHOUSE_METERING_HISTORY, QUERY_HISTORY, and STORAGE_USAGE for historical monitoring, with data retention up to 365 days but a latency of up to 2 hours (unlike INFORMATION_SCHEMA, which is near real-time but only retains 7 days-6 months depending on the view).
• 4The ORGANIZATION_USAGE schema allows monitoring and cost analysis across multiple accounts within an organization, useful for consolidated billing insight.
• 5Auto-suspend and auto-resume settings on virtual warehouses are key cost-control features, automatically pausing idle compute to avoid unnecessary credit consumption.
• 6The Snowsight web interface includes native cost management dashboards (Account > Usage) that visualize credit consumption by warehouse, query, and time period, helping identify cost drivers without writing SQL.

2 · Check your understanding