Asked about Moving data reliably
What quality checks would you put in a pipeline?
An answer that works
Row count against expectation, uniqueness of keys, null checks on required fields, range checks on numerics, and a volume check. The volume check is what catches an upstream failure that still produces structurally valid but nearly empty data.
Reading an answer is not being able to give one. The section that teaches this is Moving data reliably, 5 hours of Data pipelines.
Learn this properlyAlso asked about Data pipelines
How do you make a data pipeline safe to rerun?How do you handle an upstream schema change?When would you choose streaming over batch?How do you handle late-arriving data?A daily job failed halfway and was restarted. Now some rows appear twice. How do you prevent this?How do you keep a RAG index up to date as documents change?