Hello! We get an error that says:

Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex.

This happens when elementary tries to load dbt_columns table with an INSERT INTO VALUES() statement. The satement is hugh since it hold all tables in the platform.. Is this a known error?

Hey @Fabian, This issue usually happens when BQ exceeds query size limit, so the solution that usually works is to split queries into smaller chunks. Can you try to add the following to your`dbt_project.yml` and let me know if it resolves the issue?

vars:  
  query_max_size: 100000

Is this var specific for elementary?

Yes 🙂 This is a var we use to limit the size of the insert queries elementary does 🙂 It should not affect other packages and your project itself

I see! I will try it and return, thanks!