Elementary Community

example.txt

Hey all, so i have an issue with the   for the elementary.
i used to hade a set up with the following:

`dbt-core==1.4.0`
`dbt-bigquery==1.4.0`
`elementary-data==0.9.2`
  `- package: elementary-data/elementary`
    `version: 0.9.1`

Until now everything worked great but when i upgraded to the following:

`dbt-core==1.5.1`
`dbt-bigquery==1.5.1`
`elementary-data==0.13.2`
  `- package: elementary-data/elementary`
    `version: 0.13.2`

the on-run-end hook is failing due to the following error
```Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex.```
attached is the example of the query that keeps failing, and there for all the elementary tables dont get updated.

Besides the error, for some reason all the data that is being inserted in the end run is null...

any advice?

Hey <@U035FGRPXQX>,
Can you share the dbt.log file please ? :slightly_smiling_face:

Hi Noam, I'm getting exactly the same issue after upgrading, did you manage to find a fix for this? Thanks!

Hey <@U072GUN4CUW> 
Sorry for not replying didn’t see this.
On my end the main issue was that I didn’t notice that I was running with 2 different versions of elementary, once they were aligned it solved the problem