Carl Wilhelm Müller

Results 8 comments of Carl Wilhelm Müller

Is it possible to use TRANSFORM clause on dbt_ml?

Would also love support for the transform clause.

"Too many queries or query is too complex" issue

I'm also experiencing this on 0.16.0, dbt-bigquery 1.8.2. I tried setting the the query_max_size and insert_rows_method parameters, as my impression was that this was an attempt make changes that would...

"Too many queries or query is too complex" issue

Uploaded log file: [dbt.log](https://github.com/user-attachments/files/17191326/dbt.log)

"Too many queries or query is too complex" issue

Hi @haritamar , The log I posted above is the output from elementary actively failing **with** the configuration you are mentioning. Unless I have incorrectly set these parameters, they have...

"Too many queries or query is too complex" issue

Uploaded a new log running with the following profiles config: ``` elementary: insert_rows_method: "chunk" dbt_artifacts_chunk_size: 500 query_max_size: 1000000 ``` Will get back to you on vars. [dbt.log](https://github.com/user-attachments/files/17211038/dbt.log)

"Too many queries or query is too complex" issue

Hi @haritamar , Indeed! I moved the config from to `vars`, and i was able to run and test the entire project, and elementary models without any failures. I had...

"Too many queries or query is too complex" issue

We had to reduce the `dbt_artifacts_chunk_size` to `100` to get the fix to work for our project.

"Too many queries or query is too complex" issue

@nickozilla Our settings are: ``` elementary: insert_rows_method: "chunk" dbt_artifacts_chunk_size: 100 query_max_size: 1000000 ```