bigquery error: Query exceeded resource limits. This query used 7163 CPU seconds but would charge only 20M 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. 7163 CPU seconds were used, and this query must use less than 5100 CPU seconds.
After getting this error, we have set up a reservation for our project in BQ using flat-rate. I've tested in BQ to confirm the query is using reservation, however, we're still getting the same error from Dataform. Is there something else we're missing?
After getting this error, we have set up a reservation for our project in BQ using flat-rate. I've tested in BQ to confirm the query is using reservation, however, we're still getting the same error from Dataform. Is there something else we're missing?