bigquery/ERR/2023_003

Product: BigQuery
Rule class: ERR - Something that is very likely to be wrong

Description

A BigQuery query sometimes could not be executed in the allotted memory

resource.type="bigquery_resource"
severity=ERROR
protoPayload.methodName="jobservice.jobcompleted"
protoPayload.status.message:"Resources exceeded during query execution: The query could not be executed"

Remediation

The common root causes for resources getting exceeded are data skew, join operations, table creating more partitions after query completion , too many subqueries or query complexity

Further information

Please follow the best practices mentioned here http://cloud/bigquery/docs/best-practices-performance-patterns to avoid Data skew and https://cloud.google.com/bigquery/docs/best-practices-performance-compute