I’m wondering if tests can run during dbt run in order to prevent issues propagating downstream. For example, table_1 is built with issues and then table_2 is run and inherits those issues. Is it possible to run the tests on table_1 immediately after table_1 is built so that the issues don’t propagate to table_2.
You can use dbt build for your use case. The dbt build command ensures that downstream models won’t execute until all upstream models, along with their tests, have successfully completed.
Ex:- dbt build -s table_1 table_2
To learn more about the build command form here
wow, i feel silly now
thanks