SkillVaultskills Browse all 1,000+ skills

Debugging · Version 1.1.0 · Reviewed 2026-08-02

Snowflake Production Debug Specialist

Diagnose snowflake production incident triage and snowflake root-cause isolation with evidence, explicit trade-offs, and a verification plan.

4 method steps 4 documented failure modes 4 diagnostic checks 7 quality gates

Diagnoses production failures from runtime evidence instead of symptom matching in Snowflake using warehouse sizing, table layout, query history, and task or stream definitions and query profile, partition pruning, queue time, spill, and credit use, with explicit attention to poor pruning or uncontrolled concurrency multiplying scan cost and queue time.

₹199 one-time

Get this skill archive

Install in your AI coding tool

SkillVault packages this skill in the open Agent Skills format for five leading coding tools.

What this skill helps you do

  • Snowflake production incident triage
  • Snowflake root-cause isolation
  • Snowflake fix verification

How Snowflake Production Debug Specialist works

You provide

Symptoms, timestamps, recent changes, and logs

It inspects

Correlated subset and first failing component for snowflake production incident triage

It decides

A ranked cause for snowflake root-cause isolation that explains recovery too

You verify

The cheapest discriminating test, run before the fix

What it checks first

Snowflake Production Debug Specialist diagnoses production failures from runtime evidence instead of symptom matching in Snowflake using warehouse sizing, table layout, query history, and task or stream definitions and query profile, partition pruning, queue time, spill, and credit use, with explicit attention to poor pruning or uncontrolled concurrency multiplying scan cost and queue time. Use it when the work involves Snowflake production incident triage, Snowflake root-cause isolation, Snowflake fix verification.

  1. The precise first failure time and whether it is a step change or gradual degradation.
  2. What changed within the preceding window: deploy, config, flag, traffic shape, or data.
  3. Whether the failure is universal or correlated with a subset (region, tenant, version, device).
  4. Whether the error is deterministic on retry, which separates a logic defect from a timing or capacity defect.

Failure modes it recognizes

  • A symptom appearing in a component that merely shares a resource with the failing one.
  • An error message describing the last effect rather than the original cause.
  • A latent bug activated by a data value that first appeared in production traffic.
  • A retry layer masking an underlying failure until it saturates and fails loudly.

Answers it will reject

  • Accepting the first plausible hypothesis without testing an alternative that would falsify it.
  • Changing several variables at once, making the recovery unattributable.
  • Trusting a log timestamp without confirming clock alignment across hosts.

Decision rules it applies

  • A valid explanation must account for onset, all symptoms, the affected subset, and the recovery.
  • Choose the test that eliminates the most hypotheses per unit of effort.
  • If nothing in the system changed, examine the inputs.

Evidence it asks for

  • Reconstruct a timestamped timeline from artifacts, not memory.
  • Break metrics down by dimension to isolate the correlated subset.
  • Reproduce in a controlled environment before attempting a fix.

The method inside

  1. Reconstruct the symptom timeline and define what healthy behavior would look like for snowflake production incident triage.
  2. Rank hypotheses for snowflake root-cause isolation by evidence, blast radius, and ability to explain every observed symptom.
  3. Run the cheapest discriminating check for snowflake fix verification; update confidence only when evidence changes.
  4. Separate immediate stabilization, confirmed cause, contributing conditions, and prevention; finish with a reproducible verification.

Deliverables

  • Snowflake production incident triage assessment
  • Snowflake root-cause isolation decision and action plan
  • Snowflake fix verification verification checklist

Evidence requirements

  • Exact symptoms and timestamps
  • Reproduction conditions and recent changes
  • Logs, traces, metrics, code, or configuration

Quality gates

  • Every material claim traces to supplied evidence or is labeled as a hypothesis.
  • The response follows the declared deliverable contract.
  • No execution, access, measurement, or verification is invented.
  • Secrets and personal data are redacted rather than repeated.
  • The user receives a concrete independent verification step.
  • The relevant failure modes in this domain were considered rather than only the reported symptom.
  • No listed anti-pattern was recommended as a solution.

Example task

Input

Apply the production debug specialist to our Snowflake system before the next production change. We can provide warehouse sizing, table layout, query history, and task or stream definitions; the main concern is poor pruning or uncontrolled concurrency multiplying scan cost and queue time.

Expected output

Start with query profile, partition pruning, queue time, spill, and credit use and split the affected population before changing configuration. The leading hypothesis is poor pruning or uncontrolled concurrency multiplying scan cost and queue time. Run the smallest test that distinguishes that mechanism from dependency failure, preserve the evidence, and verify recovery against the original symptom.

Boundaries and compatibility

Ideal for

  • Snowflake production incident triage: produce a decision or artifact grounded in supplied evidence.
  • Snowflake root-cause isolation: produce a decision or artifact grounded in supplied evidence.
  • Snowflake fix verification: produce a decision or artifact grounded in supplied evidence.

Out of scope

  • Guessing a root cause from a symptom alone
  • Claiming a fix worked without test evidence

Agent compatibility

  • GitHub Copilot Agent Skills
  • Cursor Agent Skills
  • Claude Code Skills
  • OpenAI Codex Skills
  • JetBrains Junie Skills

Tool policy: Advisory by default. No tools are assumed. If the host provides tools, use read-only evidence gathering unless the user explicitly approves a scoped write or execution action.