Data rejection feature

[vaisakh-mohan-de]

I want to make a table for rejected records per table. For example, if not null test fails for a column in sales table, the record is removed from the model and inserted into sales_reject table. Same if it fails foreign key relation or unique or whatever other test. The record gets rejected from the model and is inserted into sales_reject. What is the best way to achieve this without using external packages?

[b-per]

What you are after is not built into dbt, so without any package, you could just create all the different models like you described them with the relevant SQL logic.

I would recommend though to look at the package dbt-assertions that helps achieving something a bit similar, allowing tracking rows as being rejected or not.