# Data quality + transformation in DBT

**URL:** <https://discourse.getdbt.com/t/data-quality-transformation-in-dbt/12875>\
**Category:** Help\
**Created:** [April 15, 2024, 5:22am UTC](https://discourse.getdbt.com/t/data-quality-transformation-in-dbt/12875 "2024-04-15T05:22:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![siva1091](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/siva1091/32/2964_2.png) [@siva1091](https://discourse.getdbt.com/u/siva1091)\
**Post date:** [April 15, 2024, 5:22am UTC](https://discourse.getdbt.com/t/data-quality-transformation-in-dbt/12875/1 "2024-04-15T05:22:29Z")

</div>

Hi All,

I’m looking for to DQ for a table A and redirect the validation passed records into a table and validation failed records into another table. any options available in dbt?

---

<div class="post-metadata">

**Author:** ![lisa.fang](https://avatars.discourse-cdn.com/v4/letter/l/ee7513/32.png) [@lisa.fang](https://discourse.getdbt.com/u/lisa.fang)\
**Post date:** [April 17, 2024, 3:27pm UTC](https://discourse.getdbt.com/t/data-quality-transformation-in-dbt/12875/2 "2024-04-17T15:27:27Z")

</div>

By “validation” here, do you mean records that pass/fail a test configured in dbt?

I don’t know of anything out of the box, but I have used post-hooks on models to do things like update records for hard or soft deletion. You could probably use a post-hook to mark the records that pass/fail in the model, and then use that field to determine whether to include those records in your passed/failed tables.