1 Hour Interval Average Load

One_Hour_Interval_Average_Load.sql

SELECT DATE_TRUNC('hour', start_time) start_time_trunced_at_hour,
       HOUR(start_time)               start_time_hour,
       AVG(avg_running)               avg_running,
       AVG(avg_queued_load)           avg_queued_load,
       AVG(avg_queued_provisioning)   avg_queued_provisioning,
       AVG(avg_blocked)               avg_blocked
 FROM snowflake.account_usage.warehouse_load_history
WHERE DATE_TRUNC('DAY', start_time) = '2020-03-17'
  AND warehouse_name = 'PUT_YOUR_WAREHOUSE_NAME'
GROUP BY start_time_trunced_at_hour, start_time_hour
ORDER BY start_time_trunced_at_hour;