u/Historical_Soil3222

▲ 3 r/snowflake+1 crossposts

Tried Cortex Code to debug a query spike — actually helped

Saw a big spike in query throughput (Apr 25–26) in Snowsight, so instead of digging manually, I asked Cortex Code:

>

Snowflake Cortex Code effectively identified a 3k queries/hour spike on April 25–26 by analyzing query history, identifying heavy task activity and infrastructure changes. The tool accelerated root-cause analysis by providing immediate breakdowns of SYSTEM tasks and user warehouse activity without manual query writing.

https://preview.redd.it/wsz6nwhxupxg1.png?width=2880&format=png&auto=webp&s=48007be88c8de97f394ed75457cee7752263f8df

The experience highlighted the tool’s value for proactive debugging, though it was noted as reactive without built-in cost insights or automated guardrails.

reddit.com
u/Historical_Soil3222 — 26 days ago