I am facing this issue all of a sudden while running EDR report. It was working till yesterday. 2025-02-17 162006 — ERROR — Could not generate the report - Error: Failed to run dbt command. {"info": {"name": "RunningOperationCaughtError", "code": "Q001", "msg": "Encountered an error while running operation: Database Error\n Database Error\n [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name

unique_key

cannot be resolved. Did you mean one of the following? [

unique_id

,

name

,

meta

,

owner

,

alias

]. SQLSTATE: 42703; line 24 pos 18", "level": "error", "invocationId": "fab5fa38-6bf5-444c-b3f5-53138695ebf6", "pid": 12734, "thread": "MainThread", "ts": "2025-02-17T162006.564091Z"}, "data": {"exc": "Database Error\n Database Error\n [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name

unique_key

cannot be resolved. Did you mean one of the following? [

unique_id

,

name

,

meta

,

owner

,

alias

]. SQLSTATE: 42703; line 24 pos 18"}} Please reach out to our community for help with this issue.

Interesting. Similar to what I just posted about (didn't read your before posting). Did your

edr

version also change from one day to another? Maybe you should also pin it to the version that worked.

Hi @Dharmin Siddesh J, what's your dbt-data-reliability package version?

Hey, same problem here. My setup:

- package: elementary-data/elementary
    version: 0.16.0

elementary-data==0.16.1

Hey @Mika Kerman, In our

dependencies.yml

we have 0.13.2 specified.

- package: elementary-data/elementary
    version: 0.13.2

Hi @Daniel Horvath@Dharmin Siddesh J @Julius Lipavičius, The minor version in the dbt package and the Python package should be aligned. As we add more functionality to the OSS, we occasionally need to update some schemas. When that happens, we update the minor version (like

0.15.X

->

0.16.X

) in both the dbt package and the Python package. Can you update the dbt package version to 0.16.X? The latest version, 0.16.4, was just released a couple of weeks ago. Here's a full guide on How to Upgrade Elementary. I hope this helps! Let me know if it works for you.

Thanks @Mika Kerman, I just have 2 questions: 1. If we execute

dbt run --select elementary

will that preserve the history of the incremental models? 2. If we'd want to downgrade afterwards (e.g., performance degrades, or conflict with something else), do these steps work for that direction as well?

@Mika Kerman yes it worked fine. Thanks for the help! 🙇‍♂️

Hey @Daniel Horvath, 1. Yes, the history will be preserved as the tables are not full-refreshed by default. 2. dbt package will work the same way. For the CLI, you will probably need to uninstall and install the version you need. Let us know if there are issues with the new version! 🙂