Not able to get columns for source, when defining unit test on a model that depends on source about dbt-core HOT 1 OPEN

Hi @kd-nishanth - moved this conversation over to a new issue as I don't think this is related to the ephemeral model problem. The direct parents of the model that you’re unit testing (in your example, anything model_a depends on - source_b and model_c) need to exist in the warehouse before you can execute the unit test, because we need to know what field names and data types to use when constructing the unit test sql.

Given that:

• your source_b does exist on the database and is dbt profile is able to read from it
• the unit test works if you swap out source_b with a table materialized model of source_b in the unit test and the model for model_a

this is quite perplexing!

Could you do two things:

• check if you're able to run dbt docs generate for source_b
• send an example of what your source yml definition looks like for source_b

from dbt-core.