UNRESOLVED_COLUMN exception when upgrading to elementary 0.15.1

[hamzamazhar]

Describe the bug
When I upgrade to elementary 0.15.1 and run elementary models, it fails for the model model_run_results and throws this exception:

Runtime Error in model model_run_results (models/edr/run_results/model_run_results.sql)
  [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column or function parameter with name `models`.`unique_id` cannot be resolved. Did you mean one of the following? [`run_results`.`unique_id`, `models`.`metadata_hash`, `run_results`.`query_id`, `run_results`.`name`, `run_results`.`failures`]

To Reproduce
Steps to reproduce the behavior:

1. One a new dbt project, use elementary==0.15.0 as a package and run elementary models with dbt run -s elementary
2. Then, upgrade the elementary package to 0.15.1 and install this package.
3. Run the elementary models again with dbt run -s elementary and this exception occurs.

Expected behavior
Elementary models should run.

Environment (please complete the following information):

• edr Version: 0.15.1
• dbt package Version: 1.7.14

Additional context
Add any other context about the problem here.

[haritamar]

Hi @hamzamazhar !
Thanks for posting this issue. Unfortunately I'm not able to reproduce this, so I'm guessing this issue is a bit more specific to your environment.

I see that you are using Databricks. Are you using it with or without Unity Catalog?
Does the dbt_models table exist in the elementary schema when this error occurs?

Any additional information about your setup can help to understand this.