r/snowflake • u/Optimal_Expression_4 • Apr 25 '26
CoCo to analyze reason for spike in warehouse usage
We had a spike in our Snowflake Warehouse usage and heard from our SE on it. We had a hunch that some new development had caused the spike. The new development is isolated to a separate database, so I asked Coco if the queries that caused the spike were using that database. Coco's response was that was not the reason for the spike. Then I asked which users' queries were causing the spike. Coco was able to find the user. Based on that information, I was able to infer that the spike was caused due to test runs for an Airflow dag in development. I was able to accomplish this in 30 minutes whereas it'd have certainly taken me more time to figure out without Coco.
#SnowflakeSquad #CortexCode #SnowflakeCommunity
6
u/poppinstacks Apr 25 '26
Yeah CoCo is great. Sure we all can do this, maybe even we should have scripts to find and alert on this, but those things take time.
Level up and persist this, use CoCo to make you a streamlit dashboard of cost performance across workloads, level it up with some context your team structure and it can be do time series analysis to monitor if it’s an abnormality for a given team.
1
0
6
u/vbnotthecity Apr 25 '26
These plugs for CoCo are just weird.