Technologies/Redis/snowflake_billing_warehouse_credits_used
RedisRedisMetric

snowflake_billing_warehouse_credits_used

Total credits billed for warehouse compute
Dimensions:None

About this metric

The snowflake_billing_warehouse_credits_used metric measures the cumulative number of Snowflake credits consumed by virtual warehouses for compute operations. As a counter-type metric, it continuously increments to track the total credit expenditure across warehouse usage, which directly translates to cloud infrastructure costs. This metric is fundamental to understanding Snowflake's consumption-based pricing model, where virtual warehouses consume credits based on their size and the time they remain active. Each credit represents a specific amount of computational resources, and monitoring this metric provides visibility into the primary cost driver for most Snowflake deployments. Organizations can track credits used per warehouse, enabling granular cost attribution across different workloads, teams, or applications.

From an operational perspective, this metric is critical for cost management, capacity planning, and identifying inefficiencies in warehouse utilization. By analyzing credit consumption patterns, teams can detect anomalies such as warehouses left running idle, oversized warehouses for light workloads, or unexpected spikes in query processing that drive up costs. The metric should be monitored alongside warehouse uptime and query patterns to calculate effective cost per query or cost per hour. According to Snowflake's resource monitoring documentation, establishing resource monitors with credit quotas can help prevent budget overruns. Healthy patterns typically show predictable credit consumption aligned with business hours and known workload schedules, with minimal credit usage during non-peak periods when automated warehouse suspension should be in effect.

Common alerting use cases include setting thresholds for unexpected credit consumption rates (credits per hour exceeding baseline), detecting warehouses consuming disproportionate credits relative to their expected workload, and triggering notifications when approaching monthly or quarterly credit budgets. For troubleshooting, sudden increases in this metric often indicate runaway queries, missing warehouse auto-suspend configurations, or newly deployed workloads requiring optimization. Teams should correlate spikes with the WAREHOUSE_METERING_HISTORY view in Snowflake's Account Usage schema to identify specific warehouses and time periods driving cost increases, enabling targeted investigation and remediation.

Technical Annotations (63)

Configuration Parameters (11)
AUTO_RESUMErecommended: TRUE
Enables automatic warehouse startup when queries submitted
AUTO_SUSPENDrecommended: 60
Seconds before warehouse suspends; reduces idle billing compared to default 300 seconds
VALIDATION_MODErecommended: RETURN_ERRORS or RETURN_10_ROWS
Test COPY commands before production to avoid wasting credits on failed loads
SCHEDULErecommended: 1 day
Daily monitoring frequency for credit usage alerts
daily_creditsrecommended: 500
Example threshold for daily credit consumption per warehouse
auto_suspendrecommended: based on actual usage patterns
Default values often leave warehouses running idle unnecessarily
warehouse_sizerecommended: X-Small
Default size; scale up only when performance SLA is not met
auto_suspend_timeoutrecommended: 0 for ETL, 600 for BI, 300 for DevOps
Suspension timeout in seconds for warehouse workload type
STATEMENT_TIMEOUT_IN_SECONDSrecommended: 3600
Maximum execution time for queries before automatic cancellation
STATEMENT_QUEUED_TIMEOUT_IN_SECONDSrecommended: varies by workload
Maximum time query can remain queued before cancellation
MIN_CLUSTER_COUNTrecommended: 1
Allows warehouse to scale down to single cluster during low demand periods
Error Signatures (2)
090105error code
Cannot Perform Operation. Warehouse Suspendedlog pattern
CLI Commands (10)
ALTER WAREHOUSE my_warehouse RESUME;remediation
SHOW WAREHOUSES;diagnostic
ALTER WAREHOUSE my_warehouse SET AUTO_RESUME = TRUE;remediation
COPY INTO customers FROM @my_stage/customers.csv FILE_FORMAT = (TYPE = CSV) VALIDATION_MODE = 'RETURN_10_ROWS'diagnostic
COPY INTO customers FROM @my_stage/customers.csv FILE_FORMAT = (TYPE = CSV) VALIDATION_MODE = 'RETURN_ERRORS'diagnostic
CREATE OR REPLACE ALERT load_failure_alert WAREHOUSE = monitoring_wh SCHEDULE = '5 MINUTE' IF (EXISTS (SELECT 1 FROM SNOWFLAKE.ACCOUNT_USAGE.COPY_HISTORY WHERE START_TIME >= DATEADD(MINUTE, -10, CURRENT_TIMESTAMP()) AND STATUS = 'Partially Loaded' AND ERROR_COUNT > 0)) THEN CALL send_slack_alert('Data load failures detected!')monitoring
select sum(credits_used) from account_usage.metering_historymonitoring
ALTER WAREHOUSE LOAD_WH SET STATEMENT_TIMEOUT_IN_SECONDS= 3600;remediation
SHOW PARAMETERS IN WAREHOUSE LOAD_WH;diagnostic
ALTER WAREHOUSE your_warehouse_name SET MIN_CLUSTER_COUNT = 1;remediation
Technical References (40)
virtual warehousecomponentCOPY_HISTORYcomponentwarehouse creditsconceptWAREHOUSE_METERING_HISTORYcomponentACCOUNT_USAGEcomponentACCOUNT_USAGE schemacomponentSnowsightcomponentWAREHOUSE_METERING_HISTORY viewcomponentResource MonitorscomponentACCOUNTADMINcomponentwarehouse_credit_usagecomponentvirtual warehousescomponentauto-scalingcomponentauto-suspensioncomponentcredit consumptionconceptwarehouse sizeconceptcredit consumption rateconceptBI dashboardconceptrefresh frequencyconceptauto-suspendcomponentbilling minimumconceptwarehouse size (X-Small, Small, Medium, Large)componentmulti-cluster warehousescomponentwarehouse cacheconceptdata cachesconceptETL/ELT warehousescomponentBI warehousescomponentfrozen clustercomponentresource monitorscomponentwarehousecomponentconcurrency scalingcomponentmulti-clustercomponentmulti-cluster warehousecomponentcompute creditsconceptQUERY_HISTORYcomponentRELATIVE_PERFORMANCE_COSTconceptWAREHOUSE_SIZEcomponentCOST_PER_QUERYconceptX-Small warehousecomponentquery historycomponent
Related Insights (34)
Suspended warehouse prevents query executioncritical
Default auto-suspend causes excessive idle billinginfo
Failed COPY operations consume warehouse credits unnecessarilywarning
Warehouse daily credit consumption exceeds thresholdcritical
Unexpectedly high bills from unmonitored per-second billingwarning
Warehouse inefficiency from improper sizing and configurationinfo
Snowflake credit consumption exceeds budget due to elastic compute modelwarning
Idle virtual warehouses incur continuous credit costswarning
Daily credit usage exceeding 100 indicates cost overrunwarning
Untracked warehouse usage causes unexpected high monthly costswarning
Incorrect warehouse sizing causes performance degradation or cost overrunswarning
Oversized or undersized warehouses causing waste or bottleneckswarning
Idle warehouses running without auto-suspensionwarning
60-second minimum charge inflates costs for short querieswarning
Oversized warehouses multiply credit consumption rateswarning
High-frequency dashboard refreshes accumulate disproportionate compute costswarning
60-second billing minimum creates idle time waste on short querieswarning
Warehouses sized for edge cases waste credits on average querieswarning
Multiple warehouses per team multiply idle billing windows and scatter cachewarning
Virtual warehouse auto-suspend disabled causes continuous credit consumptionwarning
Inappropriate warehouse timeout settings degrade cache performance or waste creditsinfo
Missing statement timeout parameters allow runaway querieswarning
Warehouse size changed but not reverted to baselinewarning
Idle warehouses burn credits during off-peak periodswarning
Concurrency scaling expands silently without workload policywarning
Persistent use of oversized warehouses for light workloadswarning
Fixed multi-cluster warehouse sizing prevents scale-down and wastes credits during low demandwarning
Unbounded processing causes exponential compute cost overrunscritical
Warehouse suspend-resume within 60 seconds triggers multiple minimum chargeswarning
Warehouse resize from 5XL or 6XL incurs dual resource chargeswarning
Inefficient warehouse configurations waste Snowflake creditswarning
Expensive queries consuming excessive credits relative to warehouse sizewarning
Warehouse credit consumption disproportionate to query countwarning
Snowflake credit usage exceeds query execution time calculationwarning