SQL Assertions for Monotonic and Sequence Columns
Distinguish monotonic ordering from gap-free continuity in SQL assertions.
Tomasz Wielecki
Section
SQL Patterns for Quality
6 stories in SQL Patterns for Quality.
Regex-Based Format Validation for String Columns
Structurally malformed strings hide in plain sight and wreak havoc at scale across your pipeline.
Denise Okafor
Running Quality Score Columns With CTEs
Build data quality signals into your SQL pipelines using CTEs.
Priya Nanthakumar
Date Range and Freshness Validation in SQL
Catch stale data and malformed timestamps that standard quality checks miss.
Denise Okafor
Cross-Table Consistency Checks With Reconciliation Queries
Matching row counts masks data mismatches that reconciliation queries can catch.
Tomasz Wielecki
Conditional Aggregates for Data Quality Metrics
Segment-level metrics reveal data quality problems hidden by table-wide averages.
Marcus Seligman