Data Analytics SQL Review

Reviews analytical SQL for correctness and cost: the join fan-out and row-loss traps, filters that silently change join semantics, window and grain errors, null and timezone handling, then scan volume, partition pruning, and predicate placement. Use when a query is about to feed a report or model, when results look wrong or duplicated, when a query is expensive or slow, or when reviewing someone else's analytical SQL. Trigger on 'review this query', 'why are my rows duplicated', 'this query is expensive', 'check my SQL', 'the join is wrong', 'why is this so slow'. Not for verifying a finished report's outputs against an independent source — that is data-analytics-report-qa; not for deciding what the metric should mean, which is data-analytics-metric-definition.

alihusains Updated 0 repo stars

File contents

alihusains/enterprise-skills commit 8d42c33109

Frequently asked questions

npx get-skill add alihusains/data-analytics-sql-review