GoogleCloudPlatform / GoogleCloudPlatform/bigquery-utils

Too many subqueries or query is too complex for "Job Concurrency Slow"

Open
#275 4 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.