Referential Integrity Spot-Checks Without Foreign Key Constraints
Spot missing references with a simple LEFT JOIN query pattern.
Tomasz Wielecki
Section
Data Profiling
7 stories in Data Profiling.
Distribution Shift Detection Between Pipeline Runs
Detecting when data silently changes between pipeline runs.
Denise Okafor
Detecting Statistical Outliers in Numeric Columns
The right outlier detection method depends on your data's shape and what you're willing to miss.
Priya Nanthakumar
Null Rate Analysis Across Warehouse Tables
Continuous null rate monitoring catches pipeline breaks before downstream users do.
Marcus Seligman
Duplicate Record Detection Before Aggregation
Catching duplicates before aggregation prevents cascading errors across metrics.
Priya Nanthakumar
Data Type Mismatch Auditing in Snowflake and BigQuery
Catch silent type conversions before they corrupt downstream data.
Tomasz Wielecki
Cardinality Profiling for Categorical Columns
Cardinality ratios reveal whether a column behaves like a category, identifier, or unique key.
Priya Nanthakumar