Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dbt compile failed after installing elementary-data #1427

Closed
HantonMing opened this issue Feb 22, 2024 · 4 comments
Closed

Dbt compile failed after installing elementary-data #1427

HantonMing opened this issue Feb 22, 2024 · 4 comments
Labels
Bug Something isn't working Triage 👀

Comments

@HantonMing
Copy link

HantonMing commented Feb 22, 2024

Describe the bug
For business purpose, we need to run dbt compile. But after we started to use elementary, 'dbt compile' is giving this error:

`Runtime Error
  Compilation Error in operation elementary-on-run-end-0 (.\dbt_project.yml)
    'None' has no attribute 'values'
> in macro clean_elementary_temp_tables (macros\edr\system\system_utils\clean_elementary_temp_tables.sql)
> called by macro on_run_end (macros\edr\system\hooks\on_run_end.sql)
> called by operation elementary-on-run-end-0 (.\dbt_project.yml)`

I traced it and in macro clean_elementary_test_tables, I found out that a dictionary temp_test_table_relations_map is not getting updated anywhere. Then an error is cast.

To Reproduce
Steps to reproduce the behavior:

  1. Install elementary by following all instructions
  2. Activate dbt-env
  3. run "dbt compile

Expected behavior
Dbt compile is expected to run without error

Screenshots
image

Environment (please complete the following information):

  • edr Version: [0.14.0]
  • dbt core version: [1.7.8]
  • dbt databricks version: [1.7.7]

Additional context
Could you also explain the purpose of clean_elementary_test_tables? Is it possible to set elementary/macros/edr/system/system_utils/get_config_vars.sql/" 'clean_elementary_temp_tables': true," to false by default?

@HantonMing HantonMing added Bug Something isn't working Triage 👀 labels Feb 22, 2024
@MWS-TAI
Copy link

MWS-TAI commented Feb 27, 2024

I am getting the same thing, upgraded from 0.13.2 to 0.14.0 and this error is now coming up.

dbt-core: 1.7.8
dot-redshift: 1.7.3

@will-warner
Copy link
Contributor

I am getting the same thing, upgraded from 0.13.2 to 0.14.0 and this error is now coming up.

Have you run dbt run --select elementary in production since upgrading?

https://docs.elementary-data.com/release-notes/upgrading-elementary#upgrade-elementary-dbt-package

@MWS-TAI
Copy link

MWS-TAI commented Mar 11, 2024

@will-warner I had not tried that and yes it did resolve my issue. Not sure if this issue is due to upgrading but likely would be the same issue, maybe could be closed. Thanks!

@haritamar
Copy link
Collaborator

Closing since I believe this PR fixed this issue. Please re-open if relevant!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Triage 👀
Projects
None yet
Development

No branches or pull requests

4 participants