# Query exceeded resource limits

**URL:** <https://discourse.getdbt.com/t/query-exceeded-resource-limits/9561>\
**Category:** Help\
**Tags:** bigquery\
**Created:** [August 15, 2023, 7:52pm UTC](https://discourse.getdbt.com/t/query-exceeded-resource-limits/9561 "2023-08-15T19:52:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gerbetta2992](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/gerbetta2992/32/2881_2.png) [@gerbetta2992](https://discourse.getdbt.com/u/gerbetta2992)\
**Post date:** [August 15, 2023, 7:52pm UTC](https://discourse.getdbt.com/t/query-exceeded-resource-limits/9561/1 "2023-08-15T19:52:41Z")

</div>

## The problem I’m having

I receive this message when trying to load the data from one of my models in dbt  
Someone had a similar error or knows how to solve it?

## The context of why I’m trying to do this

I’m trying to create a table based on other tow tables in my database (bigquery)

## What I’ve already tried

## Some example code or error messages

`Query exceeded resource limits. This query used 133418 CPU seconds but would charge only 299M Analysis bytes. This exceeds the ratio supported by the on-demand pricing model. Please consider moving this workload to the flat-rate reservation pricing model, which does not have this limit. 133418 CPU seconds were used, and this query must use less than 76500 CPU seconds.`

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [August 15, 2023, 11:31pm UTC](https://discourse.getdbt.com/t/query-exceeded-resource-limits/9561/2 "2023-08-15T23:31:14Z")

</div>

This is an issue with your query as opposed to dbt itself, you might find [sql - Google BigQuery Query exceeded resource limits - Stack Overflow](https://stackoverflow.com/questions/69190480/google-bigquery-query-exceeded-resource-limits) useful

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/1X/a7a7ca1fe379aaf90952b0e13118a817babcd14f.png) [@system](https://discourse.getdbt.com/u/system)\
**Post date:** [August 25, 2023, 7:17pm UTC](https://discourse.getdbt.com/t/query-exceeded-resource-limits/9561/3 "2023-08-25T19:17:55Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.