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?
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.