Ask HN: What do you use to ensure your data is correct?

At what point in your data pipeline do you check that your data adhears to constraints on it? Is it embedded in the code that performs the ingestion, at the point of the analysis or, prehaps, do you have a utility that allows you to view data in your database that do not conform to constraints on it?