Terug naar Utils
Snowflake · View
warehouse_cost
Dagelijks creditverbruik per warehouse, uitgesplitst in compute en cloud services kosten.
Bron: SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY · Latentie: ~3h
| Kolom | Beschrijving |
|---|---|
| day | Datum |
| warehouse_name | Naam van het warehouse |
| warehouse_size | Grootte op het moment van meten |
| credits_used | Totaal credits (compute + cloud services) |
| credits_compute | Alleen compute credits |
| credits_cloud_services | Alleen cloud services credits |
Broncode
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;