Subject: Issue with dbt Elementary Tables Not Upda...
# community-support
b
Subject: Issue with dbt Elementary Tables Not Updating in Snowflake Hi Elementary Support Team, I have Elementary 0.16.1 and it was worded before.I am currently experiencing an issue with dbt Elementary where the tables in Snowflake are not updating after I run
dbt test
. Here are the details of my setup and the steps I have taken so far: 1. The dbt Elementary package is correctly deployed . package.yml file: package: elementary-data/elementary version: 0.16.1 dbt_projecr.yml models: elementary: +schema: ELEMENTARY 2. The
ELEMENTARY_TEST_RESULTS
table exists and contains data. 3. Permissions are correctly set, and the user has access to the necessary schemas. 4. I have tried running
dbt run --select elementary --full-refresh
, and then run dbt test, but the tables are not updating. Despite these steps, the tables are still not updating as expected. Could you please provide guidance on how to resolve this issue? Thank you for your assistance.
n
Hey Blair πŸ™‚ Thank you for the detailed description. Does
elementary_test_results
contain updated data? Can you see which tables are not updating?
b
The views are updated, but the tables are not updated.
elementary_test_results
does not contain updated data.
One more question : We have dbt 1.9. does elementary 16.1 work with dbt 1.9?
n
The issue could be related to the
disable_dbt_artifacts_autoupload
configuration, which disables automatic updates of the elementary tables. Make sure to cancel it if enabled. If that’s not the case, I recommend updating the dbt data reliability package to the latest version (0.16.3). This could resolve any issues related to the package. As for the dbt 1.9, we're currently checking the Snowflake integration and should have an update soon πŸ™‚ Let me know if this helps!
dbt 1.9 works with elementary data reliability 0.16.3 on Snowflake. There is no reason why it shouldn't work with elementary 0.16.1, but I would still suggest updating to the latest version πŸ™ŒπŸΌ
b
Hi Noya,I updated to dbt elementary 0.16.3. The DBT_TESTS table data is updated, but ELEMENTARY_TEST_RESULTS is not updated after I run dbt test. The dbt commands I ran are as follows: dbt deps; dbt run --select elementary --full-refresh; dbt test; dbt build
πŸ‘€ 1
n
There might be an issue with the incremental model of
elementary_test_results
. Try the full refresh this way:
dbt run --select elementary --full-refresh --vars '{"elementary_full_refresh": true}'
If this doesn't work, please DM me the outputs of
dbt test
and your
dbt.log
file (within the edr_target folder) and we will try to work it out πŸ™‚
b
Hi Noya, It works by running your command!!!!!!!!!!!! THanks!!
πŸ₯³ 1
πŸš€ 1