dbt test by default will only select the specific column for not_null test.

However, when you have --store-failures flag when running the test, dbt will query select * to store the failed rows. select * on huge tables will cost you lot when running frequently.