Hello guys. We use

dbt=1.9.1
dbt-bigquery=1.9.0
elementary-data=0.16.3

So, when we run

dbt build --select fact_orders

in the log we see

12:04:36  Missing Elementary models in '666.elementary'. Please run 'dbt run -s elementary --target dev'.
12:04:36  Missing Elementary models in '666.elementary'. Please run 'dbt run -s elementary --target dev'.
12:04:36  1 of 2 START hook: CDM.on-run-end.0 ............................................ [RUN]
12:04:36  1 of 2 OK hook: CDM.on-run-end.0 ............................................... [OK in 0.11s]
12:04:36  Missing Elementary models in '666.elementary'. Please run 'dbt run -s elementary --target dev'.
12:04:36  2 of 2 START hook: elementary.on-run-end.1 ..................................... [RUN]
12:04:36  2 of 2 OK hook: elementary.on-run-end.1 ........................................ [OK in 0.01s]

I’ve run

dbt run -s elementary --target dev

but it didn’t help. Maybe someone knows how to fix it? Unfortunately Elementary doesn’t upload logs into the database and it contains info only after running

dbt run -s elementary --target dev

.

Hi @Oleksandr Gubin, is dev your default target?

Hi, we're working in the same project so let me answer. Above command is building all 29 models in elementary schema. Models have already been built, so that's why we don't understand that dbt build command seems not to see them.

Hey Magdalena, thank you 🙂 Do you have answers for our previous questions on this thread?

Hi, yes 'dev' is our default target. We are using ldap users to connect to BigQuery. Elementary models have been created in both ways with default target and with target defined with

--target dev

and still the same results. elementary_test_results table is empty, beside we ran

dbt test --target dev

( tests are defined and passed with success). Other elementary tables like dbt_run_results, dbt_tests are not empty.

Thank you! A few things that can help: 1. Make sure there isn't any materialization override in your

dbt_project.yml

that might affect Elementary tables:

models:
  elementary:
    +schema: elementary
    # Don't add any materialization settings here

2. Check if you have the required flag for dbt 1.8+ in your `dbt_project.yml`:

flags:
  require_explicit_package_overrides_for_builtin_materializations: false

3. Try to force a full refresh of Elementary models with the following command:

dbt run --select elementary --full-refresh --vars '{"elementary_full_refresh": true}' --target dev

If these steps don't solve your issue, please send us these two files: 1.

dbt test --debug --target dev

results 2. Your

dbt.log

file (from the

edr_target

folder)