| 测试 1 | count(*) = count(distinct pk) |
|---|---|
| 测试 2 | 主键空值率 |
| 测试 3 | 样本键唯一性抽查 |
粒度校验
粒度校验
SELECT
count(1) AS rows_all,
count(DISTINCT order_id) AS rows_distinct,
count(1) - count(DISTINCT order_id) AS dup_rows,
sum(CASE WHEN order_id IS NULL OR order_id = '' THEN 1 ELSE 0 END) AS null_key_rows
FROM dwd_order WHERE dt = '2026-10-12';粒度测试在上线前与每次重大变更后都要跑，作为验收证据留存。