Troubleshooting and Common Mistakes
Use this section as a triage map. Start with the symptom you observe, then apply focused checks before rewriting the full query.
Query Returns No Rows
- Confirm date ranges and filters.
- Validate parameter values and types.
- Run a simplified version first.
Duplicates or Inflated Totals
- Check join keys and grain.
- Aggregate at the correct level before joining when needed.
Unexpected Nulls
- Validate join direction and optional dimensions.
- Use explicit null handling, such as COALESCE, where appropriate.
Copilot Output Is Not What You Intended
- Clarify grain in plain language, for example, “one row per claim.”
- Provide exact fields and sort order.
- Ask Copilot to explain its assumptions before generating final SQL.