GoogleCloudPlatform / GoogleCloudPlatform/bigquery-utils
Too many subqueries or query is too complex for "Job Concurrency Slow"
Open
bug
- Dominant language
- Jupyter Notebook
- Stars
- 1.3k
- Forks
- 337
- PR merge metrics
- No merged PRs in 30d
Description
Hi, I've successfully copied over most of the data sources for [BigQuery System Tables Reports](https://github.com/GoogleCloudPlatform/bigquery-utils/tree/master/dashboards/system_tables) but hit an issue with the "Job Concurrency Slow" datasource. When I swap the `INFORMATION_SCHEMA_PUBLIC_V2` references for `` `region-{region_name}`.INFORMATION_SCHEMA`` and reconnect I see the error:
```
Resources exceeded during query execution: Not enough resources for query planning - too many subqueries or query is too complex.
```
Is this expected? Is there a simplified query I can use instead?
Contributor guide
Assessment
This issue has not been assessed yet.