| 维度 | 行数/去重行数/金额 |
|---|---|
| 时机 | 每层产出后 |
| 阈值 | 按业务定 |
| 动作 | 超阈值阻断下游 |
对账 SQL
对账 SQL
SELECT 'ods' AS layer, count(1) AS rows_cnt, sum(cast(pay_amt as decimal(18,2))) AS amt
FROM ods_order WHERE dt='2026-10-12'
UNION ALL
SELECT 'dwd', count(1), sum(pay_amt)
FROM dwd_trade_order_di WHERE dt='2026-10-12' AND order_status='PAID';对账脚本要区分「正常口径差异（如过滤测试单）」与「异常差异」，前者在脚本里显式扣除。