apache / apache/beam

BigQuery pipelines which query INFORMATION_SCHEMA views can fail to determine a query location

Open
#20,996 1 comment 0 reactions 0 assignees View on GitHub
bug gcp io java P3
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
1d 20h
Merged PRs (30d)
196

Description

Repro steps:

1. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.TABLES` view for a dataset
2. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.SCHEMATA` view for a region
3. Run a BigQueryIO pipeline which executes a BigQuery query over the `INFORMATION_SCHEMA.SCHEMATA` view without specifying a region

Expected behavior: all 3 pipelines succeed

Imported from Jira [BEAM-12752](https://issues.apache.org/jira/browse/BEAM-12752). Original Jira may contain additional context.
Reported by: kjung520.

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.