This quetion appeared sometimes (Check Columns present when running Schema Tests for a source · Issue #2405 · dbt-labs/dbt-core · GitHub) but still unclear for me. I listed table in source.yml. I run some commands like dbt parse
, dbt docs
and in all cases (except run) I got models compiled even when source tables do not exist.
- Is there a setting to check tables presence?
- Can dbt automatically validate all columns presence for all models and related sources? I know that there are some packages that allow me to write
column_exists
test but I do not want write explicit check for all columns and tables. Can it be done with just one setting? Any ideas?
Thanks in advance!