Hello Currently trying to get hold of model errors from the Elementary Community #community-support

Hello !! Currently trying to get hold of model err...

Collins Oyugi

03/09/2024, 8:23 AM

Hello !! Currently trying to get hold of model errors from the dbt artifacts. I saw from the elementary documentation from alerts_dbt_models view one can access the errors but for some reason, the view from my side is empty as compared to other elementary dbt artifacts tables which have data, for example, the dbt_run_results. Thank You!!

Ofek Weiss

03/21/2024, 11:33 AM

Hey @Collins Oyugi, the

alerts_dbt_models

view is deprecated since version

0.14.0

of elementary, where did you see it documented? ill make sure to update there. regardless, you can now find the data in the

alerts_v2

table:

Copy code

select ... from <elementary_schems>.alerts_v2 where type = 'model'

Collins Oyugi

03/26/2024, 12:09 AM

Hi @Ofek Weiss got it from here https://docs.elementary-data.com/dbt/package-models#alerts-views Thanks for the support I will be checking the referred table

Collins Oyugi

03/28/2024, 8:05 AM

Hi, @Ofek Weiss can't seem to find the table.Is there any special command am supposed to run to create the table?. I have orther tables created by elementary but not this one Currently am running this version: [">=0.7.4", "<0.7.6"] for elementary. FYI .I am trying to find the actual error message when a model fails due to the status = error .Let me know if I can get such data from the dbt artifacts uploaded by elementary

Ofek Weiss

03/31/2024, 1:12 PM

hi @Collins Oyugi, this is a veeery old version 😅 and we dont really support it anymore, i highly recommend upgrading

Open in Slack

Previous Next