Blair Mo
01/10/2025, 9:34 PMdbt 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.Noya Offer
01/13/2025, 9:12 AMelementary_test_results contain updated data?
Can you see which tables are not updating?Blair Mo
01/13/2025, 2:17 PMelementary_test_results does not contain updated data.Blair Mo
01/13/2025, 4:05 PMNoya Offer
01/13/2025, 4:32 PMdisable_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!Noya Offer
01/13/2025, 5:10 PMBlair Mo
01/14/2025, 6:46 PMNoya Offer
01/15/2025, 9:04 AMelementary_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 πBlair Mo
01/15/2025, 2:26 PM