Snowflake Health Dashboard

Generated 2026-07-15 07:40:08  |  Lookback window: last 7 days  |  Click any chart or "View details" to drill into the raw rows
9Metrics tracked
76Total rows analyzed
5Sections above threshold

🐢 Top Long-Running Queries

Slowest queries in the window, broken into compile vs execute time, plus scan/spill stats.
12 rows
01b3f2c1-000: 842.32842.3201b3f2c1-00001b3f2c1-001: 752.39752.3901b3f2c1-00101b3f2c1-000: 628.69628.6901b3f2c1-00001b3f2c1-000: 626.25626.2501b3f2c1-00001b3f2c1-001: 568.25568.2501b3f2c1-00101b3f2c1-000: 529.71529.7101b3f2c1-00001b3f2c1-000: 436.66436.6601b3f2c1-00001b3f2c1-000: 382.97382.9701b3f2c1-000
▸ View details
QUERY_ID QUERY_TEXT USER_NAME WAREHOUSE_NAME START_TIME ELAPSED_SEC COMPILE_SEC EXECUTION_SEC GB_SCANNED GB_SPILLED_LOCAL GB_SPILLED_REMOTE PARTITIONS_SCANNED PARTITIONS_TOTAL
01b3f2c1-0003 MERGE INTO dim_product USING stg_product ON... rpatel ADHOC_WH 2026-07-13 07:40:08.321196 842.32 3.45 487.08 191.11 0.00 0.00 23519 54636
01b3f2c1-0011 INSERT INTO reporting.daily_summary SELECT ... svc_etl ANALYTICS_WH 2026-07-13 05:40:08.321281 752.39 4.18 286.32 416.91 45.10 0.00 6474 53627
01b3f2c1-0009 SELECT * FROM raw.events WHERE event_date > '2026-01-01'... rpatel ADHOC_WH 2026-07-12 16:40:08.321275 628.69 2.13 851.51 355.79 0.00 0.00 14920 59789
01b3f2c1-0000 SELECT * FROM sales.fact_orders o JOIN dim_customer c ON... mkumar ETL_WH 2026-07-12 22:40:08.321134 626.25 0.95 656.36 134.03 0.00 0.00 306 56892
01b3f2c1-0010 SELECT * FROM sales.fact_orders o JOIN dim_customer c ON... mkumar ANALYTICS_WH 2026-07-09 21:40:08.321278 568.25 1.90 557.77 273.08 2.30 32.70 40442 52693
01b3f2c1-0004 SELECT * FROM raw.events WHERE event_date > '2026-01-01'... rpatel ADHOC_WH 2026-07-12 21:40:08.321252 529.71 2.03 848.16 178.30 2.30 8.20 48802 51059
01b3f2c1-0001 INSERT INTO reporting.daily_summary SELECT ... rpatel ANALYTICS_WH 2026-07-14 10:40:08.321186 436.66 1.88 327.76 75.20 0.00 0.00 21618 51678
01b3f2c1-0005 SELECT * FROM sales.fact_orders o JOIN dim_customer c ON... adas ETL_WH 2026-07-14 17:40:08.321259 382.97 1.09 752.52 132.78 0.00 32.70 41623 56668
01b3f2c1-0008 MERGE INTO dim_product USING stg_product ON... svc_etl ADHOC_WH 2026-07-13 01:40:08.321271 263.85 3.82 541.14 320.39 15.60 8.20 18241 55915
01b3f2c1-0007 SELECT customer_id, SUM(amount) FROM orders GROUP BY... svc_etl ETL_WH 2026-07-10 20:40:08.321268 255.49 0.33 502.55 90.28 45.10 0.00 22503 53157
01b3f2c1-0006 INSERT INTO reporting.daily_summary SELECT ... svc_etl ETL_WH 2026-07-13 05:40:08.321264 78.17 2.64 672.80 7.32 0.00 0.00 45251 59914
01b3f2c1-0002 SELECT customer_id, SUM(amount) FROM orders GROUP BY... svc_etl ETL_WH 2026-07-11 15:40:08.321192 75.94 0.98 527.76 8.02 2.30 0.00 22461 53242

⏳ Queued Queries (Resource Contention)

Queries that waited on warehouse resources before running — sign of undersized or overloaded warehouses.
8 rows
REPORTING_WH: 50.7450.74REPORTING_WHETL_WH: 44.944.9ETL_WHADHOC_WH: 43.9543.95ADHOC_WHANALYTICS_WH: 32.032ANALYTICS_WH
▸ View details
QUERY_ID USER_NAME WAREHOUSE_NAME START_TIME QUEUED_PROVISIONING_SEC QUEUED_OVERLOAD_SEC QUEUED_REPAIR_SEC
01b3f2c1-0001 svc_etl ETL_WH 2026-07-09 15:40:08.330244 6.70 44.90 0.00
01b3f2c1-0003 mkumar ADHOC_WH 2026-07-08 11:40:08.330252 0.78 43.95 3.20
01b3f2c1-0007 jsmith REPORTING_WH 2026-07-10 10:40:08.330267 8.55 28.55 3.20
01b3f2c1-0004 jsmith ANALYTICS_WH 2026-07-13 05:40:08.330256 3.05 18.50 0.00
01b3f2c1-0006 jsmith REPORTING_WH 2026-07-12 21:40:08.330263 8.36 15.53 0.00
01b3f2c1-0002 adas ANALYTICS_WH 2026-07-12 18:40:08.330248 4.85 12.01 0.00
01b3f2c1-0000 mkumar REPORTING_WH 2026-07-08 21:40:08.330230 2.63 6.66 0.00
01b3f2c1-0005 jsmith ANALYTICS_WH 2026-07-09 00:40:08.330259 2.96 1.49 3.20

🧮 Query Compilation Time by Warehouse

Warehouses averaging high compile time — often caused by very complex SQL, huge IN-lists, or many joins/CTEs.
4 rows
ADHOC_WH: 3.213.21ADHOC_WHETL_WH: 1.851.85ETL_WHANALYTICS_WH: 0.620.62ANALYTICS_WHREPORTING_WH: 0.410.41REPORTING_WH
▸ View details
WAREHOUSE_NAME QUERY_COUNT AVG_COMPILE_SEC MAX_COMPILE_SEC TOTAL_COMPILE_SEC
ADHOC_WH 340 3.21 14.60 1,091.40
ETL_WH 856 1.85 9.80 1,583.60
ANALYTICS_WH 1204 0.62 4.20 746.50
REPORTING_WH 2103 0.41 2.10 862.20

💾 Queries Spilling to Disk

Spilling to local/remote storage means the warehouse ran out of memory — a strong signal to resize up.
3 rows
ADHOC_WH: 156.8156.8ADHOC_WHETL_WH: 22.522.5ETL_WHANALYTICS_WH: 0.00ANALYTICS_WH
▸ View details
WAREHOUSE_NAME QUERY_COUNT TOTAL_GB_SPILLED_LOCAL TOTAL_GB_SPILLED_REMOTE
ADHOC_WH 34 312.40 156.80
ETL_WH 12 88.20 22.50
ANALYTICS_WH 5 14.10 0.00

💰 Warehouse Credit Usage (per day)

Daily credit burn per warehouse.
28 rows
2026-07-09: 150.922026-07-10: 71.272026-07-11: 110.992026-07-12: 88.752026-07-13: 124.832026-07-14: 78.322026-07-15: 81.762026-07-092026-07-102026-07-112026-07-122026-07-132026-07-142026-07-15
▸ View details
WAREHOUSE_NAME USAGE_DATE CREDITS_USED
ANALYTICS_WH 2026-07-15 27.49
ETL_WH 2026-07-15 19.15
ADHOC_WH 2026-07-15 19.10
REPORTING_WH 2026-07-15 16.02
ETL_WH 2026-07-14 37.11
ADHOC_WH 2026-07-14 24.26
REPORTING_WH 2026-07-14 11.47
ANALYTICS_WH 2026-07-14 5.48
ADHOC_WH 2026-07-13 38.02
ETL_WH 2026-07-13 36.33
REPORTING_WH 2026-07-13 32.58
ANALYTICS_WH 2026-07-13 17.90
REPORTING_WH 2026-07-12 36.81
ADHOC_WH 2026-07-12 31.05
ANALYTICS_WH 2026-07-12 12.41
ETL_WH 2026-07-12 8.48
ANALYTICS_WH 2026-07-11 36.54
ADHOC_WH 2026-07-11 33.61
ETL_WH 2026-07-11 23.85
REPORTING_WH 2026-07-11 16.99
ETL_WH 2026-07-10 31.92
ANALYTICS_WH 2026-07-10 22.22
ADHOC_WH 2026-07-10 10.99
REPORTING_WH 2026-07-10 6.14
ANALYTICS_WH 2026-07-09 44.29
REPORTING_WH 2026-07-09 42.44
ETL_WH 2026-07-09 38.91
ADHOC_WH 2026-07-09 25.28

📊 Warehouse Load (Running vs Queued Avg)

Average concurrency load per warehouse.
4 rows
REPORTING_WH: 2.32.3REPORTING_WHANALYTICS_WH: 0.10.1ANALYTICS_WHETL_WH: 0.050.05ETL_WHADHOC_WH: 0.00ADHOC_WH
▸ View details
WAREHOUSE_NAME AVG_RUNNING_QUERIES AVG_QUEUED_QUERIES
REPORTING_WH 5.60 2.30
ANALYTICS_WH 3.20 0.10
ETL_WH 1.80 0.05
ADHOC_WH 0.90 0.00

🗄️ Storage Usage Trend

Active, stage, and fail-safe storage over the last 7 days.
7 rows
2026-07-09: 13.042026-07-10: 12.932026-07-11: 12.882026-07-12: 12.792026-07-13: 12.642026-07-14: 12.552026-07-15: 12.512026-07-092026-07-102026-07-112026-07-122026-07-132026-07-142026-07-15
▸ View details
USAGE_DATE STORAGE_TB STAGE_TB FAILSAFE_TB
2026-07-15 12.51 0.66 1.00
2026-07-14 12.55 1.19 1.00
2026-07-13 12.64 0.68 1.01
2026-07-12 12.79 1.18 1.02
2026-07-11 12.88 1.12 1.03
2026-07-10 12.93 0.69 1.03
2026-07-09 13.04 1.09 1.04

🔒 Failed Login Attempts

Basic security hygiene check.
4 rows
unknown_user: 27.027unknown_usersvc_etl: 5.05svc_etljsmith: 3.03jsmithadas: 2.02adas
▸ View details
USER_NAME CLIENT_IP REPORTED_CLIENT_TYPE ERROR_MESSAGE FAILED_ATTEMPTS
unknown_user 185.220.101.5 JDBC_DRIVER Incorrect username/password 27
svc_etl 10.2.3.1 PYTHON_DRIVER Incorrect password 5
jsmith 10.2.3.4 PYTHON_DRIVER Incorrect password 3
adas 10.2.3.9 SNOWFLAKE_UI MFA timeout 2

🔁 Frequently Repeated Query Patterns

Same query hash run often — candidates for result caching or materialized views.
6 rows
a1b2c3d0: 340.0340a1b2c3d0a1b2c3d1: 289.0289a1b2c3d1a1b2c3d2: 156.0156a1b2c3d2a1b2c3d3: 145.0145a1b2c3d3a1b2c3d4: 98.098a1b2c3d4a1b2c3d5: 87.087a1b2c3d5
▸ View details
QUERY_HASH SAMPLE_QUERY_TEXT EXECUTION_COUNT AVG_ELAPSED_SEC TOTAL_CLOUD_CREDITS
a1b2c3d0 SELECT * FROM dim_customer WHERE customer_id = ? 340 0.40 0.02
a1b2c3d1 SELECT COUNT(*) FROM fact_orders WHERE order_date = ? 289 0.80 0.01
a1b2c3d2 SELECT * FROM reporting.daily_summary WHERE... 156 12.30 0.08
a1b2c3d3 SELECT product_id, name FROM dim_product WHERE... 145 0.60 0.01
a1b2c3d4 SELECT * FROM raw.events WHERE event_type = ? 98 2.10 0.03
a1b2c3d5 SELECT SUM(amount) FROM orders WHERE region = ? 87 5.40 0.04