Back to Utils
Snowflake · View
warehouse_cost
Daily credit consumption per warehouse, split into compute and cloud services.
Source: SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY · Latency: ~3h
| Column | Description |
|---|---|
| day | Date |
| warehouse_name | Warehouse name |
| warehouse_size | Size at time of metering |
| credits_used | Total credits (compute + cloud services) |
| credits_compute | Compute credits only |
| credits_cloud_services | Cloud services credits only |
Source code
create_admin_views.sql
create or replace view warehouse_cost
comment = 'Daily credit consumption per warehouse, split into compute and cloud services (source: SNOWFLAKE.ACCOUNT_USAGE)'
as
select date_trunc('day', start_time)::date as day
, warehouse_name
, warehouse_size
, sum(credits_used) as credits_used
, sum(credits_used_compute) as credits_compute
, sum(credits_used_cloud_services) as credits_cloud_services
from snowflake.account_usage.warehouse_metering_history
group by 1, 2, 3
order by 1 desc, 4 desc;