Diagnostic tools
Launch profiling
Compute column statistics: null rates, distinct counts, min/max for numerics, top values for categoricals.
Data profiling
Profiling is read-only against connections your role can access. Large tables use sampling strategies documented in the UI—note sample percentages when interpreting rare-value counts.- Key integrity
- PII awareness
Check primary key uniqueness and foreign key presence when diagnostics expose join cardinality hints.
Anomaly detection
Anomaly detection models seasonality on volume, null rate, or numeric aggregates. When today’s batch diverges from the forecast band, diagnostics opens an incident card with likely upstream nodes.Seasonal businesses (retail holidays, fiscal close) need custom calendars; configure blackouts or adjusted baselines before major events.
False positives
False positives
If legitimate marketing spikes trigger alerts, widen bands temporarily and document the business event in the alert note.
True negatives
True negatives
Silent failures can occur when bad data still matches schema—pair profiling with business reconciliation queries monthly.
Related topics
Dead letter queue
Inspect rows that failed validation or loads.
Data contracts
Encode rules diagnostics surfaces informally today.