Hello, I just saw in our Cloud build logs that in our daily load a elementary model dbt_models takes up huge amount of time. It merges 0 rows but take 3350 seconds ( 55minutes) which is beyond acceptable. What is going on here?

Hey there @Christopher Ekfeldt! What version of Elementary and Dbt are you running? If you could, add all that info to a Github issue so we can track and make sure it's dealt with.

We are using elementary 0.13 with dbt 1.7.0

We gather that for our artifacts, but it should not affect your reports. We'll still try to fix the speed of that as fast as possible, however the flag is there to overcome your current problem

It doesn't work, This is our current config:

elementary:

+dataset: "elementary"

+enabled: "{{ not target.name.endswith('_ci') }}"

disable_run_results: "{{ target.name != 'prd' }}"

disable_tests_results: "{{ target.name != 'prd' }}"

disable_dbt_columns_autoupload: true

disable_dbt_artifacts_autoupload: true

disable_dbt_invocation_autoupload: "{{ target.name != 'prd' }}"

collect_metrics: "{{ target.name == 'prd' }}"

In our top 15 most heavy models , elementary is 3 of them. dbt_columns takes ~44 minutes in our daily run. dbt_tests take ~18 minutes in our daily run. dbt_models take ~12 minutes in our daily run. What is going on, are we doing something incorrectly?

are all the variables set under

vars

(from what you send it does not seem like the case), a screenshot of your

dbt_project.yml

file would be helpful also, can you share your

dbt.log

file?

Yes, they are set under the vars. Our dbt_project.yml is huge, so I just copied the necessary configs. 🙂 Don't think I can share our dbt.logs , not here at least.

you can do so privately if you prefer

Did you manage to find a resolution to this as we are having the same problem 😭