Zurück zu Utils
Snowflake · View
warehouse_cost
Täglicher Credit-Verbrauch pro Warehouse, aufgeteilt in Compute- und Cloud-Service-Kosten.
Quelle: SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY · Latenz: ~3h
| Spalte | Beschreibung |
|---|---|
| day | Datum |
| warehouse_name | Warehouse-Name |
| warehouse_size | Größe zum Zeitpunkt der Messung |
| credits_used | Gesamt-Credits (Compute + Cloud Services) |
| credits_compute | Nur Compute-Credits |
| credits_cloud_services | Nur Cloud-Service-Credits |
Quellcode
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;