Resource Monitoring and Cost Management

Snowflake's consumption-based pricing charges for compute resources (virtual warehouses), data storage volumes, and data transfer across regions or cloud platforms. Resource monitors track credit consumption and trigger actions when specified limits are reached: notifications, warehouse suspension, or immediate suspension of all assigned warehouses to enforce hard budget limits.

Cost Optimization Strategies

• Analyzing warehouse utilization patterns to identify underutilized resources
• Implementing auto-suspend policies that stop warehouses during idle periods
• Right-sizing warehouse configurations to match workload requirements
• Consolidating workloads onto shared warehouses where appropriate
• Establishing chargeback mechanisms that attribute costs to responsible business units
• Governance policies requiring cost justification for resource provisioning

The account usage views in the shared SNOWFLAKE database provide comprehensive historical data about warehouse usage, query performance, storage consumption, and user activity. Query profile visualizes execution plans, identifies bottlenecks, and highlights optimization opportunities like missing clustering keys or suboptimal join strategies.